Star schemas and circular relationships

Premium Content

The lesson reviews star and snowflake schema design in Power BI, explaining how to construct dimension and fact tables and avoid circular relationships that can produce incorrect subtotal calculations.

Previous Module Clean, Transform and Load Data

This Module Model Data

Star schemas and circular relationships

Managing and deactivating relationships

Relationship cardinality

Relationship types

Cross filter direction

Demo: Cross filters in the AdventureWorks model

Hierarchies for drill-down reporting

Next Module Create Calculations with DAX