Master Dimensional Modeling Lesson 02 - The 4 Step Process

[@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. kzbin.info/www/bejne/iH-woIqkiLyWitE

[@garretblankenship]

Coming from a coding background and just getting into data you do an amazing job of making all the content so easily understandable and relatable. Seriously good.

[@profbiyi]

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

[@arkadiuszstaniec3842]

Hello, I like that series. Please keep going.

[@arhamanwar3365]

Great Video Bryan! First class tutorial

[@BryanCafferky]

Thank You!

[@renanpereira5487]

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

[@mattstreet4104]

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

[@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.

[@sirojiddinsobirov5508]

very informative! Keep up good work please!

[@BryanCafferky]

Thanks

[@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.