Great tutorial! You explained Dimensions and Facts beautifully. Now I understand the difference and use enough that I had difficulty understanding before. Subscribed.
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.
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.
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
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?
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.
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
![[LIVE] : ONE ลุมพินี 86 | คู่เอก "คมเพชร vs ชาติพยัคฆ์"](http://i.ytimg.com/vi/m3q_dRYDuU8/mqdefault.jpg)
A newbie to BI world, Never understood this so clearly. Your knowledge and way of explaining is commendable and impressive
a trick : watch series on KaldroStream. Me and my gf have been using it for watching a lot of movies during the lockdown.
@Kobe Brayden yup, I've been using kaldrostream for months myself :D
@Kobe Brayden Yea, I have been watching on KaldroStream for since november myself :D
this is the best tutorial i have watched better than my teacher at college
Best explanation of Fact Dimension model.
I have followed up from Fact Table, Grain and Dimension Table. Thumbs up, you are doing a great Job!!
Thank you . I watched all 13 videos under DW. Very good explanation . Straight to the point . Good information .
Best ever video in this topic. Thanks a lot for this video.
to the point and crystal clear videos .. Thanks for making such good videos
Everything is to the point I appreciate it....
Highly appreciate you for this topic simple explanation and the voice quality is awesome 👍
Simple and meaninfgull presentation with nice slides, Thanks
Beautiful content. Thank you for speaking on point and helping me prepare for my interview. Really appreciate.
This video has explained the definitions of fact and dimension clearly with cases. Thanks!
Perfect example you added there. Great work
Very clear explanation. Thanks.
Information was very straight and very clear to understand
Really crystal clear explination thanks bro
Detailed Explanation. THANKS !
This is a brilliant channel, have watched all your videos. Please post new videos.
Really Nice Video
explained very nicely..with easy word's 👍 thank you
Very nice explanation.Thank you
Great tutorial! You explained Dimensions and Facts beautifully. Now I understand the difference and use enough that I had difficulty understanding before.
Subscribed.
Can you give the definitions in your own words of Fact and Dimension?
Oh beautiful teaching
Thank you really it is useful and easy to understand
You sir, are a Legend. Thank you very much
excellent explanation clear and concise
Very easy to understand, i would recommend a subscription
This was an amazing video and the explanation was crystal clear
Very easy to understand. Thank you.
Tq sir easy and clear explanation
Really helpful and too good
He knows his job!
Good to start
Excellent explaination! Thank u so much
Great explanation
Loved this
Very well explained
very good explanation..
Can we consider an emplyee table and we need to store that table in warehouse. Here employee table emploee id will come under dimension or fact table
Well Said. you explained each topic with examples these are very useful.
can you pls make videos on hadoop and kafka from developer's perspective
Simply superb
sir, well done! thank you!
Easy to understand stuff!
Simple and easy to understand videos. Good job! Thank you very much
very nice explanation sir
Are the videos in the playlist in a logical sequence ?If not , please do it.It will be healpful
Nice and clearly explained.
Thank you😍
Good explanation
Thanks. Very informative, to the point.
Thanks for this vedio.
Excellent video, thank you!
Thank you! Very clearly explained!
Good quick and precise.
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.
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.
Good job.👌..keep it up👍..Thank you👍👌💐
appreciate your kind words.
where are the next set of videos?
This dude is amazing
Woww! That was Crisp.
Very good explanations. Thanks.
Awesome video!
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.
Thanks for motivation. We are working on adding more detailed tutorials.
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
Nice video thanks for the video
Great video, Thank you
This video is greeeeeat thank you master very much
Thank you for the video. Explained very well.
Really helpful, thanks!
Good explanation.Thanks
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.
this was good helped a lot thanks
Very easy to understand , Can we have more videos on Data Warehouse like different types of schemas. Thanq
Very informative :)
quick and clear
thank you so much!
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 ^^
THANKS!
Nice
2 hour class < 5 minute TH-cam video
Thank you it was very easy can you help me with one question.
can you please let me know who are end users regarding banking projects
Thanks :)
Thank You So Much
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?
Thanks
nice
Why can't we have only one table?
Bro these 13 vedios are enough to learn dw concepts
so helpful :)
Which is next video
Thanks sir
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.
use speed feature
Tq sir
you are thorough in knowledge, but very fast. Please go slow as we are beginners.
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
thanks :)
Sounds like he's directly reading it from a book
Just a small suggestion. Please go a bit slow while explaining, you are speaking very fast. Otherwise I found the content quite helpful.
I can't stand this annoying Indian accent, but the information was informative.
dude.. you just speak like me.....
you're giving just theory, what about the practical work
how i can develop my skills in Data warehouse or Data science
JUST? he's doing a good job, don't dishearten people who are going good work.
never ever eat supari