What is a Data Warehouse - Explained with real life example | datawarehouse vs database (2020)

What is a Data Warehouse - Explained with real-life example | datawarehouse vs database (2020)
#datawarehouse #dwh #datawarehousing #concepts
*Link to Complete playlist*
1) Latest technology tutorial (2020) -
• What is a Data Vault ?...
2) Google Cloud Platform Beginner Series (2020) -
• Google Cloud Platform ...
3) Crunching Data Series (2020) - • Learn - Data Engineeri...
Hi Friends, I am Anshul Tiwari and welcome to our youtube channel ITkFunde.
About this video -
In this video, we will understand what is a datawarehouse using a very simple really life example. A data warehouse is nothing more than a storeroom of your house. Data warehouse stored all your enterprise data into a centralized location and hence called EDW (Enterprise Data Warehouse). So in this video we will cover -
1) What is a Warehouse ?
2) Real-life example to explain datawarehouse ?
3) Various data warehousing stages
4) Characteristics of a datawarehouse
Credits & Resources -
images - pixabay.com
**Social Links**
Facebook - / itkfunde
Linkedin - / ansh9685
Twitter - / ansh9685
Blog - blogs.itkfunde.com/
Instagram - / itkfunde
**About This Channel**
Friends ITkFUNDE channel wants to bring I.T related knowledge, information, career advice, and much more to every individual regardless of whether he or she belongs to I.T or not. This channel is for everyone interested in learning something new!

[@kaalabhairavan665]

i watched many videos about Data Warehousing but failed to grasp even the basics of it. But you explained it in a clear cut way. Thanks a lot. You are Super .

[@ITkFunde]

Thanks Kaala for your feedback means a lot please keep supporting😊🙏

[@Kmno4-with-oxygen]

good job man; no hide n seek, no beating around the bush; just bullet points; even a new born baby will understand this; thanks a lot!

[@RaviKumar-ii6wo]

The best and simplest way of educating on DWH. Thank you so much for your valuable video. It really helps.

[@ninoska991]

Hi Anshul, I discovered your channel yesterday. I really like your teaching style and the fact that you explain the content using analogies, real examples and graphics. You get to summarise the content very well in 10 minutes :) Thanks for the contribution!

[@ITkFunde]

Thank you Nina ☺️☺️

[@zenzeleluckymtshali8433]

hi

[@dataholic_me2750]

I would like to take this moment to appreciate your efforts you did for us. I usually get lazy while learning these things but the way you represent it diagrammatically it helps a lot to get a ease to learn things. Thankyou so much

[@vjp724]

You are a excellent teacher sir! Thank you for sharing and posting all the modules so far..my kids and I are learning so much from you.🙏

[@ITkFunde]

Thanks Vijay I am so happy to know that kids are able to learn something useful from my channel. My love and blessings to them 🙏☺️

[@trainingatamu11]

Thank you for your plain and practical explanation of the data warehouse. Now I understand what the data warehouse is designed to do. My next step, what do I want to analyze based on the data that's captured in our warehouse.

[@-b_d-]

Online class is really difficult. I can't even understand this lesson just by reading the module. But luckily, i found your video and I learned a lot from it. Thank you so much!!!

[@ITkFunde]

Thanks Darlyn

[@amjadpmna7058]

In which grade you are studying

[@hassanlearning4086]

This video helps me understand the Data Warehouse concept and its differences from standard databases. Thank you.

[@alexydumenigoaguila3144]

Great content! This is a subject I sudyed during my engineering career and never fully understood. Thanks to this video, I finally know what a data warehouse is. From now, I am a follower. Thank you and greetings from Cuba.

[@ITkFunde]

Thanks Alexy ☺️🙏

[@krishmemes7639]

IT K Funde, your teaching style is very effective, thanks for sharing.

[@ebtesamkhan7804]

Very well explained. I was aware about DWH, OLAP & OLAP, and analytical tools, but I was unable to connect them in one process. You explain whole thing as a life cycle so it's become very easy to understand. Thanks and keep it up 👍

[@ITkFunde]

Thanks Ebtesam 🙏🙏☺️☺️

[@kvcrao7472]

GOOD WAY OF EXPLANATION WITH RELEVENT EXAMPLES WE COM ACROSS IN OUR DAY-TO-DAY WORKING

[@mcdonald9584]

Just like u explained general of whole damn chapter so easily that lecture made me difficult to understand.
Thank you so much bro

[@basiliospinello]

Thank you bro! You've explained clearly in 10 minutes what my professor did in 3 hours. Damn

[@ITkFunde]

Thanks Basillo I know too little to be compared with a full time professor but I am glad it helped you in someway 🙏☺️

[@ramsapkota3146]

I normally do not provide feedbacks but you explained the concept very well. Thanks man !!!

[@ITkFunde]

Thanks Ram 🙏🙏☺️

[@BJ-jo5wf]

I dont understand why you dont have so little followers and not in the 100T range this channel is great

[@ITkFunde]

Thanks B J for your support, its fine even it helps some ☺️

[@WaliSayed]

I like the patient you use to explain the subjects. Many thanks for your efforts.

[@ITkFunde]

Thanks Wali

[@pulkitahuja4750]

I really like your outro and yes "there is some worth in this video"

[@vishalbarvaliya2849]

Sir your way to explain any concept is just Amazing....
No one can explain like you others are just give definitions and related to that instead of real-life examples like you.
So, Thank you very much.

[@ITkFunde]

Thanks 😊 Vishal glad it helped you

[@42Siren]

Finally after watching tons videos ... understood datawarehouse

[@yehiamdil8238]

You are amazing. I got the best idea about data warehousing through your video. I watched so many videos but only this one gave me the best knowledge. Thanks a lot!!!!!!!!!

[@ITkFunde]

Thanks ☺️🙏

[@jegadheesh_b2]

Well delivered the exact content clearly sir. I thought if i understood the concept, then i would subscribe. So now i subscribed 🎉😊

[@willardmakinishi6980]

Thank you a million times. I have not found an explanation better than this. How I wish I could find all the course contents or outline for MIS on your platform.

[@ITkFunde]

Thanks Willard 🙏☺️

[@zenzeleluckymtshali8433]

hi

[@31kiransomwanshi]

Very good explanation Anshul. Keep sharing..

[@00EagleEye00]

Hi there.
Got a question on raw data (flatfiles).
These doesn't have identities or keys so you formulate a candidate key by combining some columns (product, location, target_year).
Here's the question, if there are some columns to correct and it belongs to the combination of candidate keys, how can the data be corrected or updated? What approach is to be made ?

[@alevenkateshwarulu-rh9gz]

U rocked the simple concept...with clear explanation

[@yonatanzewdie4483]

Thank you-- very simple detailed explanation-- you should consider writing IT books if you haven't already

[@kayeshparvez]

Thank you for your to-the-point discussion which is not only concise but also very much understandable.

[@ITkFunde]

Thanks Kayesh

[@rembautimes8808]

Good talk very knowledgeable and precise. I was in the industry for 10 years and learnt something new

[@ITkFunde]

Thanks a lot !!

[@rakshitmanage3878]

It was very useful , beautifully explained. Thanks

[@djenobthemixbane1146]

Thank you so much for this explanation. Very helpful

[@sk____1958]

Totally nailed the explanation.... Thanks for the video

[@dlaw4251]

Lovely, properly explained and understood. thank you sir

[@sy-vf4js]

Clear and straight to the point. Very good video .

[@ITkFunde]

Thank you Shin ☺️

[@archanarathore730]

Best video for data warehouse & well explained👏👏

[@learnprogrammingwithproject]

I think you should start series to teach various Data technology and concept.
❤️

[@alno1]

that was a great break down, I finally get it! Thanks!

[@ITkFunde]

Thanks a lot🙏☺️

[@NoDrizzy630]

Excellent video! You are an amazing teacher.

[@spoorthideshmukh6569]

Very crisp and clear explanation..not a single second I felt bore.. It was so informative👍

[@ITkFunde]

Thanks ☺️

[@swapnilkamble1180]

Best sir
Always support you
Thanks again sir

[@prasannakumarz]

Finally Understood.ThankU so much!

[@shrutikathorat5355]

Sir u explained in well manner it helpful in my exams 😊🙏

[@meenuvinod7007]

Thank you for making the concept easy to understand 😊

[@tharinduabeysinghe3126]

I am so happy I found you online.. You have a gift of teaching in a very understandable manner. Keep it up!

[@ITkFunde]

Thanks Tharindu 🙏☺️

[@zenzeleluckymtshali8433]

hi

[@gangadharamdantu9614]

It's crystal clear and easy, thank you so much for this sir.

[@ITkFunde]

Thanks a lot 🙏☺️

[@MR-vt3co]

It's very good explanation thank you.

[@sunilv1807]

Thanks a lot for quick high level explaination. It was very helpful!

[@ITkFunde]

Thanks Sunil

[@googlemani]

Hello Anshul. Your explanations are very clear. Way better than the paid courses. Thanks and keep up the good work.

[@ITkFunde]

Thanks Mani 😊❤️

[@sanikaborhade5408]

Sir its really helpful and easy to understand

[@eddie8742]

Very good explanation, clear and to-the-point examples. Thanks!

[@zenzeleluckymtshali8433]

hi

[@kiransatyan]

Amazing content brother, so very well explained to layman like me.

[@josephwaigwa2720]

Prestigious content Sir,

[@jamesbenedict6480]

Question for you Anshul, your intial diagram shows a Data Warehouse and you are showing Raw data stored in the Data Warehouse. The second diagram shows a separate Staging area where the Raw data is stored outside of the Data Warehouse. What is the correct architecture and WHY?

[@shrikarparab7462]

Awesome... I got all the answers with respect to data warehouse.

[@ITkFunde]

Thanks Shrikar

[@riyazahmed7907]

Very clear explanation, thank you sir.

[@Asp.net_Developer]

I love how you explain man.. you made it to be simple for me

[@ITkFunde]

Thanks Senzo☺️

[@bytebuxx]

This helped me a lot sir thank you and keep posting like these videos

[@jellychai5823]

Operational/transactional database - records as things happen, optimize writes over reads, OLTP. Data Warehourse -> static, post fact, optimized for reads, OLAP

[@martlomadrigal4303]

This really help me to my studies ❤️thank you so much

[@ITkFunde]

Thanks Martlo

[@ShivamGupta-il7hj]

First time watching impressed

[@noorjahanbegum7113]

Really I felt it's soo great.... content explanation is soo cool...

[@RyanVemuri]

Simple and easy explanation!

[@user-nk6ov5rk5h]

Very Well Explained !! Thanks

[@VijayTiwari22981]

Very well described गुरुजी

[@lamontkblack]

Super helpful. Thanks!

[@ngqabuthomoyo2672]

You are really good at this! Keep it up!

[@vc5074]

Very good. Explained a lot clearly in 10 min

[@ITkFunde]

Thanks KK

[@yemijegede1766]

Excellent! Thank you so much for this video.

[@ITkFunde]

Thanks Oluyemisi 🙏☺️

[@ashankavindu2409]

The best teacher 🥰🥰🥰🥰🥰🥰🥰🥰

[@OmkarShinde-bz7oy]

great explaination sir i liked it

Very well explained, thanks!

[@maximilianodelatorre2513]

Awsome explanation!

[@billyli5174]

Thank you for your sharing.

[@sajjadkabirmdsharifulalam8652]

Very nice and to the point video ... Great work .... Pls. keep it up

[@ITkFunde]

Thanks Shariful☺️

[@nnaemekaobodozie6901]

You are a great teacher.

[@bigbro_songz]

Great video sir. Very concise. As complex as it is, I like how you managed to simplify this topic.
And for that, I liked and subscribed!!

[@ITkFunde]

Thanks Bro !!!

[@zenzeleluckymtshali8433]

hi

[@nimasherpa7118]

thank you alottt sir from Nepal

[@shivesh2813]

great explanation method.

[@roronoazoro-518]

well explained!! I understood it .I am subscribing to this channel!

[@ITkFunde]

Thanks Shivam 🙏☺️

[@lizluft2778]

Great explanation - very helpful for 700-level course!

[@ITkFunde]

Thanks Liz🙏

[@syedhaiderali1519]

There is a lot of worth in this video

[@shinej11]

Thank you very much for this video

[@khushalitank4247]

hello Mr.anshul, i Really lernt from your video , thank you for making a video with clearification , please make a video on Tableau how to use and when , thank you

[@ashwinibhosale5834]

Can u add more videos about data warehouse ... explanation was too good

[@abdelrahmane657]

Please subtitles the video. Yet very constructive and pedagogical. Well done. Thank you

[@ITkFunde]

Thanks for support I try to add subtitles more and more now

[@srikarjonnala6509]

Very exciting to listen

[@user-lo9gl1jj8e]

nicely done mate

[@Ian-tg4gc]

can i ask waht data warehouse can i make from a delivey management system?

[@lkuliar]

Very well explained

[@tushtu_mishti]

Very well explained 👍
As usual "aasan and saral".

[@ITkFunde]

thank you Deepak for your support !!

[@kevinjoseph8206]

WELL 'n Good👌😊

[@ASHISHKENDRE]

Total Dil Chahta Hai vibe

[@jhonnafg]

Great content. thankyou! new subscriber here

[@husamui]

well explained. Thank you!

[@rushabhparmar7519]

Your videos are really very well explained! Please take suggestions for future videos! :)

[@ShubhamRai06]

very nicely explained

[@user-li7hi9em2o]

wonderful! You are a great teacher!!! Thank You!

[@ITkFunde]

Thank you so much 🙏☺️

[@anjanaharidasan]

awesome explanation

[@akhilamoparthi3789]

Thanks for the video. In which format the data gets stored in Warehouse