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

[@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😊🙏

[@jellychai5823]

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

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

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

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

[@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 🙏☺️

[@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 🙏🙏☺️☺️

[@WaliSayed]

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

[@ITkFunde]

Thanks Wali

[@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 ☺️

[@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 ☺️🙏

[@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 ☺️🙏

[@Kushi-v]

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

[@ramsapkota3146]

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

[@ITkFunde]

Thanks Ram 🙏🙏☺️

[@rembautimes8808]

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

[@ITkFunde]

Thanks a lot !!

[@krishmemes7639]

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

[@spoorthideshmukh6569]

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

[@ITkFunde]

Thanks ☺️

[@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.

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

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

[@sy-vf4js]

Clear and straight to the point. Very good video .

[@ITkFunde]

Thank you Shin ☺️

[@gangadharamdantu9614]

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

[@ITkFunde]

Thanks a lot 🙏☺️

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

[@mcdonald9584]

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

[@kayeshparvez]

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

[@ITkFunde]

Thanks Kayesh

[@42Siren]

Finally after watching tons videos ... understood datawarehouse

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

[@Asp.net_Developer]

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

[@ITkFunde]

Thanks Senzo☺️

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

[@googlemani]

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

[@ITkFunde]

Thanks Mani 😊❤️

[@shrikarparab7462]

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

[@ITkFunde]

Thanks Shrikar

[@hassanlearning4086]

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

[@kvcrao7472]

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

[@shrutikathorat5355]

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

[@martlomadrigal4303]

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

[@ITkFunde]

Thanks Martlo

[@laurentiuc7830]

Very well explained! Thank you!
You won a new subscriber.

[@yonatanzewdie4483]

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

[@alevenkateshwarulu-rh9gz]

U rocked the simple concept...with clear explanation

[@SudarsanakrishnanS]

Thank you Sir for your detailed explanation of the subject.

[@pulkitahuja4750]

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

[@jegadheesh_b2]

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

[@sunilv1807]

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

[@ITkFunde]

Thanks Sunil

[@dlaw4251]

Lovely, properly explained and understood. thank you sir

[@ASHISHKENDRE]

Total Dil Chahta Hai vibe

[@ranitdey7369]

I am glad that I came across your channel 😇😇

[@ITkFunde]

thanks Ranit 🙏

[@shannon3525]

Legit had a lightbulb moment when he explained OLAP vs OLTP

[@vc5074]

Very good. Explained a lot clearly in 10 min

[@ITkFunde]

Thanks KK

[@learnprogrammingwithproject]

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

[@bytebuxx]

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

[@alno1]

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

[@ITkFunde]

Thanks a lot🙏☺️

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

[@sk____1958]

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

[@prasannakumarz]

Finally Understood.ThankU so much!

[@udilerner]

just wanted to remark, that the "SUBJECT ORIENTED DATAWAREHOUSE" are actually DataMarts, the combined DataMart unify into a complete DataWarehouse

[@syedhaiderali1519]

There is a lot of worth in this video

[@ashankavindu2409]

The best teacher 🥰🥰🥰🥰🥰🥰🥰🥰

[@archanarathore730]

Best video for data warehouse & well explained👏👏

[@swapnilkamble1180]

Best sir
Always support you
Thanks again sir

[@NoDrizzy630]

Excellent video! You are an amazing teacher.

[@martintovar2645]

You are not as good at drawing users as you are at explaining the concepts. Great!

[@ITkFunde]

❤️

[@lizluft2778]

Great explanation - very helpful for 700-level course!

[@ITkFunde]

Thanks Liz🙏

[@rakshitmanage3878]

It was very useful , beautifully explained. Thanks

[@akhilamoparthi3789]

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

[@shinej11]

Thank you very much for this video

[@srikarjonnala6509]

Very exciting to listen

[@realgouravverma]

Hi please help me in this doubt. Suppose I am running an online course business and I run ads on fb/insta, Google/UA-cam/android-apps, Twitter, etc. So there is lot of data is getting collected. Also if people click on my ads on various places, some fill the lead generation form, some don't buy my course and some do buy my course, some people buy my upsale, etc. So where do I collect all this data at a single place and analyse to get some insights. Is there any software that can collect all the data no matter where it is and analyse. Please help.

[@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?

[@AshishGhosh-b7z]

Very Well Explained !! Thanks

[@Sangarg]

Please create more topic on big data and Data engineering

[@sanikaborhade5408]

Sir its really helpful and easy to understand

[@meenuvinod7007]

Thank you for making the concept easy to understand 😊

[@billyli5174]

Thank you for your sharing.

[@djenobthemixbane1146]

Thank you so much for this explanation. Very helpful

[@minnminncherry7643]

Thank you so much for your sharing. You're grate teacher

[@ITkFunde]

Thanks Minn ☺️🙏

[@roronoazoro-518]

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

[@ITkFunde]

Thanks Shivam 🙏☺️

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

[@eddie8742]

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

[@zenzeleluckymtshali8433]

hi

[@sajjadkabirmdsharifulalam8652]

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

[@ITkFunde]

Thanks Shariful☺️

[@bhushanwagh7192]

sir you are awesome ..what a beautiful explanation ..thank you

[@ITkFunde]

Thanks Bhushan

[@bhushanwagh7192]

@@ITkFunde can you plese make a video on Snowflake and
What is used in real time.?

[@ITkFunde]

Thxx Bhushan for this suggestion I will surely make something on snowflake in near future

[@31kiransomwanshi]

Very good explanation Anshul. Keep sharing..

[@zikrifisehaye323]

Thank you very much. really helpfull!

[@ITkFunde]

Thanks ❤️

[@rociojuarez5489]

Hi Anshul! I bit about myself: I have nearly ZERO experience and limited knowledge in Data Management. I'm in HR and found it necessary to start learning the technical side of things to have more value and in this changing environment that's outpacing us. Your video was SO helpful and way more informative than the certificate course I'm taking. Thank you! Your videos are truly great for people that are coming in more basic than entry-level like myself. Lol.

[@ITkFunde]

Hey Rocio thanks a lot for your kind words, such comments are exactly the reason I started this YT journey 3.5 years back, Making IT intresting for everyone is the mantra and I am so glad its helping people from Non IT background embrace technology. All the Best Mate 👍👍

[@MR-vt3co]

It's very good explanation thank you.

[@nnaemekaobodozie6901]

You are a great teacher.

[@jitinmehndiratta8121]

Crisp and clear! very well explained!

[@bhavyavaibhav6326]

You have explained it very well. Very well paced as well.

[@ITkFunde]

Thanks Bhavya

[@deepakgyandev]

I love this channel

[@kalangiprasad4073]

Love this channel. Great explanation

[@ITkFunde]

Thanks again

[@ИлонаИнч]

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

[@ITkFunde]

Thank you so much 🙏☺️

[@tushtu_mishti]

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

[@ITkFunde]

thank you Deepak for your support !!

[@riyazahmed7907]

Very clear explanation, thank you sir.

[@helovesdata8483]

This was really good. I want to be a data engineer

[@ITkFunde]

Thanks

[@MuhammadKhan-gy3ld]

Hi Anshul, video is wonderful - could you please elaborate metadata in some video - thanks

[@ITkFunde]

Thanks for suggestion will try to do one

[@G3nM]

Bro it was simple & awesome!

[@ITkFunde]

Thanks buddy

[@medhavi2060]

Thank thank you thank you thank you so much sir 😊😊😊

[@ITkFunde]

Thanks a lot 😊😊😊

[@rrl1919]

Nice Explanation.. please make more video on ETL Transformation also👍

[@ITkFunde]

Thanks Rohini for suggestion 🙏

[@VijayTiwari22981]

Very well described गुरुजी

[@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 ?

[@ashwinibhosale5834]

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

[@rahidzeynal]

Good explained bro, thanks!

[@ITkFunde]

Glad it was helpful!

[@shubhstar22]

Good explanation sir but hinglish me samjhaiye or acche se samjh aayega