What is Dimension and Fact in Data Warehouse

Dimension and fact are basic building blocks in Data Warehouse. In this tutorial, we will understand what is dimension and fact and what differentiates any data into these two categories.

[@workaholic7880]

A newbie to BI world, Never understood this so clearly. Your knowledge and way of explaining is commendable and impressive

[@kobebrayden9639]

a trick : watch series on KaldroStream. Me and my gf have been using it for watching a lot of movies during the lockdown.

[@jedidiahcyrus2481]

@Kobe Brayden yup, I've been using kaldrostream for months myself :D

[@brodieharley7040]

@Kobe Brayden Yea, I have been watching on KaldroStream for since november myself :D

[@lakshaysethi9362]

this is the best tutorial i have watched better than my teacher at college

[@omgrubicon6328]

Best explanation of Fact Dimension model.

[@durgamanoja8179]

to the point and crystal clear videos .. Thanks for making such good videos

[@DeepakDaksh]

Everything is to the point I appreciate it....

[@msmktester]

Simple and meaninfgull presentation with nice slides, Thanks

[@balki8774]

Thank you . I watched all 13 videos under DW. Very good explanation . Straight to the point . Good information .

[@zedkamurase851]

I have followed up from Fact Table, Grain and Dimension Table. Thumbs up, you are doing a great Job!!

[@FarahNazifa]

Beautiful content. Thank you for speaking on point and helping me prepare for my interview. Really appreciate.

[@sonutvv]

Best ever video in this topic. Thanks a lot for this video.

[@KalyanS]

Really Nice Video

[@roylee6744]

This video has explained the definitions of fact and dimension clearly with cases. Thanks!

[@sowjanyap2352]

Very nice explanation.Thank you

[@christykpm6374]

Perfect example you added there. Great work

[@akhilhonnuru8321]

Information was very straight and very clear to understand

[@harishkoranne7734]

Good to start

[@ahsanmemon8943]

Highly appreciate you for this topic simple explanation and the voice quality is awesome 👍

[@althafmohammed5478]

Detailed Explanation. THANKS !

[@zainulabdeensaeed5824]

Thank you really it is useful and easy to understand

[@butair1]

Great tutorial! You explained Dimensions and Facts beautifully. Now I understand the difference and use enough that I had difficulty understanding before.
Subscribed.

[@gowthammodepalli7858]

Can you give the definitions in your own words of Fact and Dimension?

[@denissentamu1919]

Oh beautiful teaching

[@tusharsonwane8468]

explained very nicely..with easy word's 👍 thank you

[@surajbais7533]

Really helpful and too good

[@nimmaturipadma6942]

Great explanation

[@yamunau.yamuna5189]

Really crystal clear explination thanks bro

[@jay1970]

Very well explained

[@AlbrechtJ]

Very clear explanation. Thanks.

[@hansikas5665]

very good explanation..

[@johnaj9042]

This is a brilliant channel, have watched all your videos. Please post new videos.

[@rlee95129]

Very easy to understand. Thank you.

[@Moni_Vibes]

This was an amazing video and the explanation was crystal clear

[@rammadipeddi5864]

Tq sir easy and clear explanation

[@kidambiharipriya2255]

Very easy to understand, i would recommend a subscription

[@salonibhatia9438]

Good explanation

[@balaji-venkatraman]

Loved this

[@frankleeying4349]

excellent explanation clear and concise

[@antquinonez]

Thanks. Very informative, to the point.

[@hanostrydom]

You sir, are a Legend. Thank you very much

[@padmakothapalli4631]

Well Said. you explained each topic with examples these are very useful.

[@krneki6954]

sir, well done! thank you!

[@LL-oq8dh]

very good explanation... thanks

[@shyam8722]

Simple and easy to understand videos. Good job! Thank you very much

[@aamshihab]

Nice and clearly explained.
Thank you😍

[@ramesh5643]

Excellent explaination! Thank u so much

[@Shamikism]

He knows his job!

[@doom-mantia]

Thank you! Very clearly explained!

[@bhaveshrawat1364]

Thanks for this vedio.

[@ahmadsyed9405]

Easy to understand stuff!

[@AHandono2000]

You have a good way to explain DW concept, but please do consider talking a bit slow, so the audience can digest what you are saying... the rest is a good job. Thumbs up

[@chandrak.b6391]

Good job.👌..keep it up👍..Thank you👍👌💐

[@aroundBI]

appreciate your kind words.

[@jollydolls1348]

where are the next set of videos?

[@MoyoTaiwo]

If I have 2 scenarios on transactions data from a pharmacy chain of 10 stores.
1) Each individual store has exclusivity over products. No product exists in more than one store.
2) All stores keep all the products, such that for each product, you can find it in all the 10 stores.
Between the two, what difference should I be aware of in building the dimension and fact table?
I think in scenario 1, the store name is a dimension.
In scenario 2, the store_name is a fact.
Please correct me if I am wrong.

[@CannyInformatics]

In both the scenarios store_name is Dimension. Product sold on those stores will go to fact, e.g. no of products, per day sale, quantity sold etc.

[@ganesh9450]

Simply superb

[@jaggarajusubramanyam7726]

very nice explanation sir

[@akworld4u]

Great Work, Very Nice and descriptive videos explained within short time.
Can we have more videos on Data Warehouse like different types of schemas and its implementation.

[@aroundBI]

Thanks for motivation. We are working on adding more detailed tutorials.

[@WisdomWomenWarrior]

can you pls make videos on hadoop and kafka from developer's perspective

[@suman4tube]

Good quick and precise.

[@Fibolyzer7]

Excellent video, thank you!

[@siddharthsingh5031]

Woww! That was Crisp.

[@poulameepal8065]

Are the videos in the playlist in a logical sequence ?If not , please do it.It will be healpful

[@mubarakalikhan5702]

Nice video thanks for the video

[@tommunt-davies3927]

this was good helped a lot thanks

[@ademajames7250]

Good explanation.Thanks

[@ivomitdiamonds1901]

This dude is amazing

[@jounger]

Really helpful, thanks!

[@anonymousfan9703]

Nice

[@MsIalSs]

His Indian accent is killing me, but I'm not complaining cause content of the video is great. Even my M.Sc lecturer couldn't explain this well.

[@sebon11]

This video is greeeeeat thank you master very much

[@darklink22999]

Great video, Thank you

[@gousebasha1992]

Very easy to understand , Can we have more videos on Data Warehouse like different types of schemas. Thanq

[@sashadongre]

Awesome video!

[@delacruztv3668]

thank you so much!

[@D_I_T_0]

super good and easy explanation, thank you.. but please take a little bit more distance with the microphone so the voice will not be annoying ^^

[@deekshithkatta849]

Very informative :)

[@snehalmagdum878]

THANKS!

[@ketanbhikadiya4679]

Very nice videos.
Just came back to this video again to like and comment. All 13 videos are very informative.
Thanks @aroundBI
Can you send the ppt for all of these videos?

[@veremox]

nice

[@divinelemur9530]

2 hour class < 5 minute UA-cam video

[@TRINI123A]

Very good explanations. Thanks.

[@FWFWFWF]

quick and clear

[@hafsamurtaza6546]

Thanks

[@Jasminrathod]

Excellent overview....please keep up the good work and if possible speak a bit slowly...so many more may understand and follow the video/graphics as well.

[@lakshaysethi9362]

use speed feature

[@derikroby7041]

Thanks :)

[@hijabsarwar8014]

Thank you it was very easy can you help me with one question.

[@Themercifulallah1]

Thank You So Much

[@saikumarchebrolu1071]

Bro these 13 vedios are enough to learn dw concepts

[@rakeshgopidi4066]

Excellent explanation can you also prepare few vids on the below
Role-playing Dimensions
Rapidly Changing Dimensions
Bridge Dimension
Audit Dimension
Mini Dimension
Out Trigger Dimension
Multi-Valued Dimension

[@lostfrequency89]

Why can't we have only one table?

[@mubarakalikhan5702]

Thanks sir

[@braisonkishore1473]

so helpful :)

[@akshardrashti]

Which is next video

[@kammamohankrishna2195]

can you please let me know who are end users regarding banking projects

[@sukumar44]

Just a small suggestion. Please go a bit slow while explaining, you are speaking very fast. Otherwise I found the content quite helpful.

[@topone6860]

Tq sir

[@soniagill4181]

you are thorough in knowledge, but very fast. Please go slow as we are beginners.

[@__-rj9pj]

I can't stand this annoying Indian accent, but the information was informative.

[@vijay9600able]

thanks :)

[@sunithasriharikrishna7359]

Sounds like he's directly reading it from a book

[@yosoyfantastico]

dude.. you just speak like me.....

[@saadullah071]

you're giving just theory, what about the practical work
how i can develop my skills in Data warehouse or Data science

[@ivomitdiamonds1901]

JUST? he's doing a good job, don't dishearten people who are going good work.

[@rupeshsatao681]

never ever eat supari

[@chandu9143]

Good explanation