I've seen hours of videos on data warehousing. These are the most valuable 56 minutes.
@MightyMike554 жыл бұрын
Well said
@vaibhav83823 жыл бұрын
53 minutes*
@sndselecta3 жыл бұрын
100% agreed
@maryjones21752 жыл бұрын
Could not agree more, this is the best video on data warehousing I have watched so far!!
@P_Belle2 жыл бұрын
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 🙆😟
@avenuech394 жыл бұрын
The most understandable, detailed & overall introduction to Dimensional Modeling, with clear key words explanation and logically sequential arrangement on the slide content. Thanks Bryan!
@prithvikumar37513 жыл бұрын
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!
@BryanCafferky3 жыл бұрын
Thanks. What are your tech learning interests?
@bradjohnson90222 жыл бұрын
This is by far the best guide to dimensional modeling I've found on the internet!
@markparee995 жыл бұрын
Using for an interview prep. Great refresher. Perfect length and depth of content...
@kasiatuszynska4863 жыл бұрын
Perfect combination of experience and theoretical handle on the subject. Thank you for the time it took to record it.
@BryanCafferky3 жыл бұрын
You're welcome. Glad it was helpful.
@johnlamarre73302 жыл бұрын
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.
@BryanCafferky2 жыл бұрын
Glad it is helpful.
@terryxu14812 жыл бұрын
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.
@BryanCafferky2 жыл бұрын
You're very welcome!
@jilanimohammed46563 жыл бұрын
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.
@BryanCafferky3 жыл бұрын
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?
@manarlab84 Жыл бұрын
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
@Molaa214 жыл бұрын
Amazing video. Well explained. Uploaded 3 years ago, still valid for educational and professional training for 2020. Thanks Bryan!
@kcmalik59922 жыл бұрын
Good sir, I typically never like or comment KZbin 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
@BryanCafferky Жыл бұрын
Thank You
@paoloogr9 ай бұрын
My current favorite channel on KZbin 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.
@BryanCafferky8 ай бұрын
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?
@Lego-tech4 жыл бұрын
Many Thanks !! This is the best video I have even seen on this subject. Simple explanation of all complicated areas.
@TheMadMagician873 жыл бұрын
I'm about 4 or 5 years late to this party. You've still done a great job in this video compared to many other sources. Thanks, and well done!
@BryanCafferky3 жыл бұрын
YW and thanks for watching.
@pranshumishra3 жыл бұрын
This is premium content on the topic. Simple yet effective explanation shows your understanding of the subject. Thank you Bryan!
@BryanCafferky3 жыл бұрын
Glad it was helpful! Thanks
@risebyliftingothers Жыл бұрын
By far the MOST lucid and practical no-nonsense explanation of key terms. Loved it!
@BryanCafferky Жыл бұрын
Glad it is helpful! Thank you for the kind words.
@paulm31064 жыл бұрын
An excellent video on data warehousing, easily the best I've seen.
@stuieblack4 жыл бұрын
Quality. Seeing your videos, I realise that this is the subsection of my role that I enjoy the most and need to learn more about. Great video.
@nandk984 жыл бұрын
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!!
@BryanCafferky4 жыл бұрын
Thanks
@nandk984 жыл бұрын
@@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.
@anjaneynaik30802 жыл бұрын
The concept has been explained thoroughly with real time examples. Thanks Bryan.
@BryanCafferky2 жыл бұрын
YW. Thanks for watching.
@Vermitude3 жыл бұрын
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.
@BryanCafferky3 жыл бұрын
Thanks. Glad you liked it.
@sshfromhere2 жыл бұрын
Great presentation!👍 Thank you Bryan ! 👏
@BryanCafferky2 жыл бұрын
YW. Glad it is helpful.
@himanshityagi50553 жыл бұрын
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.
@BryanCafferky3 жыл бұрын
Thanks. Yeah. I struggled understanding this too for some time. Glad it helped.
@wentingzhu3436 жыл бұрын
among several videos i watched on dimensional modeling, this is the one with more insight and experience sharing!
@marcosoliveira87314 жыл бұрын
Lovely way of teaching. Looking up for more of your material about data warehouse on the web.
@stalsams179 Жыл бұрын
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 !
@BryanCafferky Жыл бұрын
Thank you!
@stephenhordes42443 жыл бұрын
Thanks Bryan, great video.
@akshaybaura2 жыл бұрын
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.
@BryanCafferky2 жыл бұрын
Great! Glad it helped!
@manankashyap77262 жыл бұрын
One of the best videos I’ve seen on DM!!
@simondavidvgm4 жыл бұрын
AMAZING lecture, Bryan - thanks so much! Exactly what I was looking for and an extremely well articulated 56 minutes.
@consumer3235 жыл бұрын
This was an excellent primer. I was alert and it really grounded me on a number of key points. Thank you so much for this contribution.
@user-yw1ef7hx4v Жыл бұрын
The best video I have ever watched till date. Very well explained and neatly presented. This video helped a lot!!!
@BryanCafferky Жыл бұрын
Glad it was helpful!
@erb64113 жыл бұрын
This is so helpful. I'm modeling a data warehouse for my Org and only have experience with OLTP. This has saved so much headache
@BryanCafferky3 жыл бұрын
Great! Yeah. Dimensional Modeling is a very different mindset. Good luck!
@terribradshaw43663 жыл бұрын
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.
@BryanCafferky3 жыл бұрын
Thanks. Glad it helped. Hope you find my other videos helpful too.
@cannonkalra71332 жыл бұрын
This is what I subscribe internet for, it's beautiful piece of 53 mins straight
@BryanCafferky2 жыл бұрын
Thanks. Hope you check out my other videos like the ones on Databricks and Python too.
@rishabhbhatt73734 ай бұрын
Great content Bryan. Great level of detail and insights (from actual experience). Please keep it up !
@LEI8037 Жыл бұрын
I am listening you for the first time and I found out that you are a great teacher.
@BryanCafferky Жыл бұрын
Thanks!
@LEI80376 ай бұрын
@@BryanCafferky After an year I am listening again to refresh concepts.
@individualassignment26612 жыл бұрын
this is great Dimensional Modeling tutorial ever.. !! Thank you so much, sir..
@user-ob2ox5nk8v9 ай бұрын
Crisp, Precise and understandable!
@GokulShanth3 жыл бұрын
For someone just getting started, this was amazing thank you so much!
@BryanCafferky3 жыл бұрын
YW!
@hgiang1004 жыл бұрын
Thank you Bryan for this video. You did an excellent job of explaining the concepts data warehouse design.
@BryanCafferky4 жыл бұрын
Thanks!
@tregatregs88043 жыл бұрын
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.
@BryanCafferky3 жыл бұрын
Thanks. What specific topics are you thinking of?
@houstonfirefox Жыл бұрын
Very well presented! Clear and concise with real-world use cases!
@billrosmus67344 жыл бұрын
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. :)
@BryanCafferky4 жыл бұрын
Thanks!
@C_G_19623 жыл бұрын
The ideal video for a dba trying to reach the dw world (using mssql server and also Azure) . Thanks a lot for the video !
@BryanCafferky3 жыл бұрын
Glad it helped!
@4rmtinc4 жыл бұрын
A nice and concise presentation of dimensional modeling for data warehouse.
@2001july062 жыл бұрын
Amazing simple and focused explanations. Thanks Bryan
@BryanCafferky2 жыл бұрын
You're Welcome! Glad it was helpful.
@shivamahirao53772 жыл бұрын
You're a savior, thank you Bryan.
@BryanCafferky2 жыл бұрын
YW. Glad it helps.
@aaragon09024 жыл бұрын
Thank you so much!! Struggling through my data modeling/structuring course and your video was incredibly helpful in understanding dimensional modeling.
@BryanCafferky4 жыл бұрын
Wow! Really glad to hear that. Thanks for letting me know.
@maniji57563 жыл бұрын
Thank you, loved the content and how well it was structured and presented. Looking forward to your other tutorials!
@mirdhapuneet4 жыл бұрын
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.
@BryanCafferky4 жыл бұрын
Thanks! Appreciate the kind words.
@vijayd15 Жыл бұрын
Best video on DW design ever!
@mohdfaisal95642 жыл бұрын
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.
@BryanCafferky2 жыл бұрын
YW and thanks for watching.
@ghazitozri49893 жыл бұрын
Thank you sir, you saved my life.
@ohnotoyota46923 жыл бұрын
Excellent, specially focus on process model. Thank you
@BryanCafferky3 жыл бұрын
YW!
@tobman7813 жыл бұрын
Great presenation. Very clear and to the point!
@vikaschoudhary69043 жыл бұрын
Great tutorial sir , Thank you so much for such relevent information .
@BryanCafferky3 жыл бұрын
You are most welcome
@clintp35043 жыл бұрын
Excellent video! Thanks for sharing
@BryanCafferky3 жыл бұрын
YW
@helovesdata84833 жыл бұрын
I'm getting into data engineering and I really enjoyed this content.
@dylankelly33183 жыл бұрын
Great video Bryan.
@astersathya5 жыл бұрын
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 :)
@BryanCafferky5 жыл бұрын
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!
@msdew98855 жыл бұрын
@@BryanCafferky hoW? What? When? Where? Who? hoW many? Why? makes 7. Thanks for the video. Very informative!!!👍
@thehouse26204 жыл бұрын
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.
@Ari-lu5ve2 жыл бұрын
Thank you so much for this! Very organized lecture, and I love how you included the time stamps.
@mohammedansari8183 жыл бұрын
This is the first time I loved blue screen on my computer. :) Very good advice.
@lyreco79102 жыл бұрын
Absolutely amazing video, thanks Bryan!
@BryanCafferky2 жыл бұрын
YW. Glad it was helpful.
@aiikaiik3 жыл бұрын
Great Job Bryan, great content .Thanks for sharing
@BryanCafferky3 жыл бұрын
Thanks!
@YeetYeetYe2 жыл бұрын
Absolutely amazing explanations.
@saurabhjain20053 жыл бұрын
You are amazing!! Thank you so much for this. Best summary you can get and which can make you talk like a pro..
@BryanCafferky3 жыл бұрын
Thanks.
@joaorataoo3 жыл бұрын
Thank you so much for sharing your knowledge and your skills to teach them in a so clean, so comprehensible.
@BryanCafferky3 жыл бұрын
Thanks. So glad it is helpful!
@creativeluf Жыл бұрын
Great explanation of dimensional modelling. Highly insightful.
@richardogujawa-oldaccount133610 ай бұрын
Great lecture, definitely worth the watch!
@sendilbm2 жыл бұрын
Amazing video, very detail level. Thanks so much.
@SuperAerodragon4 жыл бұрын
@BryanCafferky Thank you for taking the time to put this together. This is a great foundational video for anyone getting started and presents the subject in a very relatable way.
@BryanCafferky4 жыл бұрын
Thanks.
@Martin-lf9se3 жыл бұрын
Very well done and explained. Thank you for sharing your knowledge.
@BryanCafferky3 жыл бұрын
Thanks for watching.
@sumit12345yadav4 жыл бұрын
@Bryan Cafferky - thank you for creating this great video. Its really a marvel , simple, realistic approach to understand.
@torque63894 жыл бұрын
Excellent job! Thank you for this wonderful video!
@ragacbe3 жыл бұрын
It's a great content and presentation. Thank you very much for this wonderful work!
@BryanCafferky3 жыл бұрын
YW!
@nathankomer86993 жыл бұрын
Priceless resource. Much appreciated!
@barbararibeiromaia15023 жыл бұрын
This video was perfect to answer my questions! Thank you!
@BryanCafferky3 жыл бұрын
Glad to hear that!
@pradeepnagaraj73473 жыл бұрын
Excellent explanation Bryan!!
@haiderali-uf4gy4 жыл бұрын
best video on data warehousing on youtube..
@saisanikommu85514 жыл бұрын
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).
@BryanCafferky4 жыл бұрын
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.
@mathinsovie995411 ай бұрын
Wow. well detail and explainable. Thanks Bryan
@BryanCafferky11 ай бұрын
YW!
@michaelwoodman27465 жыл бұрын
Thanks Bryan. This is a really useful overview; great to have the fruits of your extensive experience.
@BryanCafferky5 жыл бұрын
Thanks Michael!
@martinmkca23204 жыл бұрын
Thank you very much for this GREAT presentation!!!!
@hugomichaelnunezmejia33844 жыл бұрын
THANK YOU FOR THE CLEAR EXPLANATION!!!
@valentinussofa41352 жыл бұрын
Amazing lecture. Thanks Sir. 🙏🙏🙏
@jimpanging874 жыл бұрын
Great video, great explanation!
@stefangabor59852 жыл бұрын
Great presentation.
@BryanCafferky2 жыл бұрын
Thanks
@druthorah4 жыл бұрын
Excellent explanation! Thank you for this.
@myth00s3 жыл бұрын
Just to point out that "dimensional" is not the opposite of "relational". The latter just means you are using certain abstract data types (relations & tuples, i.e. tables & rows) to model your data at the logical level. Both dimension tables and fact tables are ... tables, i.e. relations, if implemented in a relational database. "Dimensional" means syntactically formulated around a specific sentence schema with empty spaces to be filled in about observations (facts) that have taken place in a certain context (dimensions).
@BryanCafferky2 жыл бұрын
Right. Entity Relational (ER) Modeling is used to create optimized OLTP architectures whereas Dimensional Modeling is used to create optimized reporting data warehouse architectures. It is critical that DW designers do not apply ER to a DW or they will get performance and reporting issues. Coming from an OLTP background, that took me a bit to get.
@excelrati3 жыл бұрын
Thank you so much for this video. I really appreciate your efforts to explain this in the best possible way 👍🏻
@BryanCafferky3 жыл бұрын
Glad to help!
@Seamonkey19812 жыл бұрын
outstanding overview, well done
@AaronJOlson3 жыл бұрын
Great video, thank you!
@dalibormares49173 жыл бұрын
very clear, thanks Bryan
@nicoyou112 жыл бұрын
Excellent education. Thank you!
@BryanCafferky2 жыл бұрын
YW. Please share my channel with others on social media.
@xloganp89254 жыл бұрын
Thanks a ton Brian, that was very informative and easy to follow.
@BryanCafferky4 жыл бұрын
Thanks. Glad it was useful.
@Boatsman995 жыл бұрын
Excellent and very informative video. Thank you very much.
@FedericoLov3 жыл бұрын
excellent! This is really missing from the typical data science curriculum