Master Dimensional Modeling Lesson 02 - The 4 Step Process

Dimensional Modeling is the process of developing The Star Schema, a popular and effective way to organize your data to maximize business value. In this video, you will learn about the 4 steps in the Dimensional Modeling process.
Support me on Patreon
www.patreon.com/bePatron?u=63...
Slides
github.com/bcafferky/shared/b...
Understanding Dimensional Modeling
• Dimensional Modeling
Databricks Blog: Dimensional Modeling on Databricks
www.databricks.com/glossary/s...

[@profbiyi]

Thank you so much for this. I am already looking forward to the next video on this series. I love the series.

[@mattstreet4104]

Loving this information its so great as someone who is in a small business breaking through to BI work. Look forward to more

[@renanpereira5487]

Looking forward to the next video! Please continue it :)

[@tonee84]

love this series. please make a video about Data Vault modeling techniques. Much appreciate it.🥰

[@BryanCafferky]

I have not used Data Vault but from what I have read it seems unnecessarily complex. See this great video that explains this really well. ruclips.net/video/RNMoWnSWcTo/видео.html

[@arkadiuszstaniec3842]

Hello, I like that series. Please keep going.

[@sirojiddinsobirov5508]

very informative! Keep up good work please!

[@BryanCafferky]

Thanks

[@jaiprakashpe]

Thanks for the information.. this was very helpful in building dim and facts for my projects.. still I'm confused on certain fields like delinquent days, next payment date and some date related fields.. where these fits?

[@BryanCafferky]

Quantitative fields like delinquent days are probably facts. Dates are almost always dimensions. Hope that helps. Thanks for watching.

[@shanaebrown1563]

Can you do a more practical example

[@BryanCafferky]

What are you thinking of?

[@shanaebrown1563]

@@BryanCafferky like getting a dataset then start creating the facts and dimensions from it using microsoft sql server.

[@BryanCafferky]

@@shanaebrown1563 Good idea. I was thinking of using the OLTP AdventureWorks database and creating the Dimensional Model and DW from that. There is a DW version of the AW database already but I don't think it is very good so this would be a walk through as if the DW did not exist. Make sense?

[@shanaebrown1563]

@@BryanCafferky I think the main thing for me is that I know the concepts but after building the dimensional tables I am a bit loss on how to integrate them in the fact table using queries, so this would be really great.