Agreed! Conversational tone, appropriate visuals, and well-paced. I'm in a $4k EDW graduate school class that teaches from bulleted PowerPoint slides. Doesn't compare 🙆😟
The most understandable, detailed & overall introduction to Dimensional Modeling, with clear key words explanation and logically sequential arrangement on the slide content. Thanks Bryan!
This is the most informative session I have ever seen! 54 minutes of pure knowledge. If only everything I had an interest in learning was taught by Bryan!
I come from an OLTP software data architect side of the house and only had to hand off streaming/replication to an ODS. I just took a role that will require dimensional modeling. So glad I found your video. This clicks.
I'm grateful for the time and efforts you put in explaining one of the key concepts anyone deals with enterrpise data needs. Clear and comprehensive. Thanks a lot
Hi Bryan, many thanks to provide this tutorial. The most solid foundation tutorial on data warehouse & dimensional modelling I have even seen. For those who want to build their career path as a data analyst, data architect etc. This is the best start point. I really regret that I did not see this video 2 years ago when I start off my career.
These are the best 53 minutes I've spent recently. Crisp and Clear. I feel much more confident and I request more videos on Dimensional Modeling. Thank you for your effort.
Thanks. I did do a video on Slowly Changing Dimensions which is a big area for interview questions. What topics are you most interested in regarding dimensional modeling?
Thanks, This is very helpful. When you discussed the scenarios regarding a person getting married, it triggered a bunch of other questions I can ask for my project. I enjoyed the descriptions of what is fact vs what is dimension.
Good sir, I typically never like or comment RU-vid videos. This was a must. You are masterful, and could quite possibly mint some people into data engineers off of this video. God bless you. I hope to become a teacher like you one day
My current favorite channel on RU-vid being a senior data engineer. I would like to have a video created by you telling more about what cubes are, OLAP, ROLAP, etc. This kind of nomenclature is getting more and more rare and people joining data engineering in this modern data stack area should understand them well so that they can understand how we got here and also talk to people familiar with this data engineering nomenclature.
ROLAP and MOLAP are only used in the legacy SSAS Multidimensional Models. They were cool but the Tabular model does not use them b/c everything is in memory. Thanks for the suggestion. Are you using SSAS Multidimensional Models?
A very useful introduction to data warehousing and the common terminologies, presented in an interesting and easy to understand manner. IT was a very quick 53 minutes - I only meant to get an idea of the content and then watch it later - but got completely absorbed.
I wish I had watched it earlier when i was struggling to understand Datawarehousing and Dimension Modeling. Very informative video. Every second was worth spending.
A very comprehensive and fully understandable video during my very first viewing itself. I felt like having read a high quality book on the topic within an hour. Bryan never wastes time on unnecessary talks and very effectively concentrates on the core through and through. Thank you!!
@@BryanCafferky My statement was true. Not just a passing compliment. I got a full perspective on what is dimension modelling and how it is different from Data warehousing. Leave alone warehousing, it actually helped me in designing various reports using data from Database tables. I was able to see the common threads that run through them all.
I have been working in data warehousing for the last 5 years and this video gave me the answer I have looking for so long- why is there so much normalisation in data warehouses we see today? Nobody ever gave me a satisfactory answer but you did sir. Big thanks !! This video deserves to be on the billboard.
Thank you so much!! Struggling through my data modeling/structuring course and your video was incredibly helpful in understanding dimensional modeling.
I dont usually spend time watching a 53 min learning video most of the time unless the course and the orator is really worth it. Trust me sir, you kept me glued every minute. God bless you Sir !
This is an excellent primer. The best one I've seen. I'll recommend it if anyone asks for advice on a good starting point. One point however: USER STORY. In 99% of Agile Software Development, the example from that book is NOT a User Story. A user story actually describes something that needs to be done and why. e.g. As a business manager I need to be able to drill down into the types of sales act my book stores to see the types of books being purchased, how they are being purchased, how they are being paid for, down to the level of the book title, so that I can understand what is being sold and better stock my stores. What the book you mention is actually doing is closer to a Use Case. There is semantic impedance going on. But it's just data. :) Anyway, I really do like this video and think the approach of using use cases is very good. I think though that there will be some need to translate between different groups kind of like what is a location to different systems. :)
Hi Bryan, This video is one of the best videos have watched and has every information required, to the point and well described...Hats off...Thank You. Highly recommend must watch for everyone who is working in DWH domain.
Hi Bryan, This video is one of the best videos have watched and you have covered every piece of information required to the point and well described...Hats off...Thank You. Highly recommend must watch for everyone who is working in the DWH domain.
Thank you for this excellent presentation on Dimensional Modeling. I'm a student and it was so easy to follow because you made it interesting and you provided some excellent examples to support your slides.
This is a must watch video for anyone having a hard time understanding Dimensional Modeling. Wish you could do a full series on Database systems and Warehousing.
Hi Bryan, I found your video extremely helpful. I know dimensional modelling could be a bit outdated compared to newer tools out there these days but I find your videos easy to follow and would love to see more videos on this topic, i.e. olap cube. Thanks for your amazing work!
I listed out some topics (after my failed interview )to gain clearcut understanding and this video answered all my questions in detail,Sir big thumbs to you ,if possible please do a video on interview questions and how to answer them (Dw,DBMS concepts).
Hi Sai, That's a great idea for a video. Do you have any specific questions in mind? BTW: Interviews always have questions to stump you. But I'd like to help with a video that helps. Thanks! Bryan.
Excellent Video and loved it. Being an OLTP modeler, this gave me a very nice idea about dimension modeling. The only one thing which I wanted to bring it to your attention that, When you talked about 7W's of dimensional modeling, it only had 6 Ws and I was searching for the 7th one :)
Hi Sathya, Great observation! Actually, the 'How Many?' is one of the 7 but yeah, it is an H not a W. The book 'Agile Data Warehouse Design' presents it that way so I did to. It should be the 6 W's and 1 H of Data Warehouse Design but that is harder to say. :-) Actually, it helps me remember the How because it is different. Thanks!