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) -

2) Google Cloud Platform Beginner Series (2020) -

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 -

***Social Links***

***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!

[kaalabhairavan]

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 .

[ninoska]

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!

[-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!!!

[jellychai]

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

[ebtesamkhan]

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 👍

[BJ-jowf]

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

[basiliospinello]

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

[alexydumenigoaguila]

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.

[Kmno-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!

[yehiamdil]

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

[ramsapkota]

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

[vjp]

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.🙏

[WaliSayed]

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

[sy-vfjs]

Clear and straight to the point. Very good video .

[Kushi-v]

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

[willardmakinishi]

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.

[krishmemes]

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

[spoorthideshmukh]

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

[vishalbarvaliya]

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.

[trainingatamu]

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.