Advanced dimensional modelling
2024TL; DR
Deepen your Power BI expertise with advanced data modeling techniques. This session dives into dimensional modeling, many-to-many relationships, table granularity, and more. Packed with demos and practical examples, it's a crash course for those seeking mastery in Power BI data structures.
Session Details
Are you already familiar with Power BI, but having trouble modeling data in Fact and Dimension tables? Then this deep-dive is for you!
In this session full of demos and practical examples, the following topics will be covered:
- Dimensional modeling: Dimensions, Facts + Snowflakes
- Working with multiple Fact tables
- Many-to-many relationships
- Date and time tables
- Linking tables with different granularity levels
- Header and detail tables: Order + Order details, PO + PO Lines etc.
- Effectively using inactive relationships
- Slowly Changing Dimensions
In this session full of demos and practical examples, the following topics will be covered:
- Dimensional modeling: Dimensions, Facts + Snowflakes
- Working with multiple Fact tables
- Many-to-many relationships
- Date and time tables
- Linking tables with different granularity levels
- Header and detail tables: Order + Order details, PO + PO Lines etc.
- Effectively using inactive relationships
- Slowly Changing Dimensions