No video :(

Master Dimensional Modeling Lesson 02 - The 4 Step Process

Подписаться 41 тыс.

Просмотров 2,7 тыс.

50% 1

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.co...
Slides
github.com/bca...
Understanding Dimensional Modeling
• Dimensional Modeling
Databricks Blog: Dimensional Modeling on Databricks
www.databricks...

Опубликовано:

17 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 16

@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 3 месяца назад

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

@tonee84 3 месяца назад

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

@BryanCafferky 3 месяца назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RNMoWnSWcTo.html

@mattstreet4104 4 месяца назад

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

@renanpereira5487 3 месяца назад

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

@arkadiuszstaniec3842 5 месяцев назад

Hello, I like that series. Please keep going.

@sirojiddinsobirov5508 5 месяцев назад

very informative! Keep up good work please!

@BryanCafferky 5 месяцев назад

Thanks

@jaiprakashpe 4 месяца назад

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 3 месяца назад

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

@shanaebrown1563 3 месяца назад

Can you do a more practical example

@BryanCafferky 3 месяца назад

What are you thinking of?

@shanaebrown1563 3 месяца назад

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

@BryanCafferky 3 месяца назад

@@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 3 месяца назад

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