Are you already familiar with Power BI, but having trouble modeling data in Fact and Dimension tables? Then this video is for you! In this tutorial 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
• Import v.s. Direct Query
• Vertipaq engine

Download slides and Power BI examples: Advanced Dimensional Modelling.zip