Data Model Prep - STAR schema Basics - Season 5 Ep.1

This session will be an overview of relational modelling aimed at those who came through a business of Excel path. We’ll review what a star schema is and define dimensions, facts, keys, and relationships. We’ll then define different table structures such as Role Playing, Slowly Changing, and Degenerate Dimensions, plus Factless Fact tables.

Part 1 in The analyst’s guide to advanced data modelling

This three-part series looks at design decisions to create well optimized data models. It is aimed at users primarily from a business or Excel background who work with Power BI. Attendees are expected to have basic knowledge and experience creating datasets and knowledge of using Power BI.

Please Subscribe to our Channel:

[mubarakbabslawal]

18:32
Amazing explanation of Filters vs Values. Every dimension is a filter

[chandra]

1:06:35 that's the exact use case of Junk Dimension. It saved me a lot of time and effort towards create a hierarchical slicer.

[rajarshisingh]

You gave the crocodile a Human to eat 😂😂

[MucahitKatirci]

It was really helpfull, thank you. I learned lots of different concepts. I will read "TheData Warehouse Toolkit".

[fadwa]

could you please make a practical video on SCD ? how you make this report from scratch. thank you

[aartdevletter]

Thanks a ton for this! Really helps.

Questions: how come you point so strongly towards not using values directly from the fact table? I do this often for say a simple distinct count of for instance companies or any other unique_ID basically. What are the risks involved?