| Schema and Calculations |
| Star Schema |
The recommended layout for analytical models |
| Relationships |
Cardinality, direction, and active vs inactive joins |
| Measures vs Columns |
Choosing the right approach for each calculation |
| Time Intelligence |
Year-over-year, year-to-date, and rolling windows |
| Calculation Groups |
Reusable computation patterns applied across measures |
| Performance Tools |
| Performance Tuning |
Slimmer columns, fewer relationships, and Storage Engine wins |
| Composite Models |
Mixing Import and DirectQuery in one model |
| Aggregations |
Pre-summarised tables hidden behind detailed sources |