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
3 things you'll get out of this session
Speakers
Arthur Graus's previous sessions
Master Python in Fabric for Data Engineers
The world of data engineering is changing and being fluent in T-SQL is not enough anymore. In this full day workshop with lots of exercises you will get up to speed with Python and learn all the tips and tricks you need to know.
Python in Fabric for Data Engineers: all you need to know
The data engineering landscape is evolving. T-SQL proficiency isn't enough now. Dive into modern tools like Delta Lake, Jupyter Notebooks, and MS Fabric with Python. This session covers Python syntax, Jupyter in Fabric, data manipulation with Pandas, PySpark for Big Data, and data extraction/loading techniques for various formats.