Relationships & Star Schemas
A tidy star schema keeps visuals fast and DAX simpler.
Key points
- Separate facts (transactions) from dimensions (who/what/when).
- Single-direction relationships reduce ambiguity.
- Prefer surrogate keys; avoid many-to-many unless necessary.
Tips
- Use date dimensions for time intelligence.
- Push heavy transforms to the data warehouse to keep Power BI snappy.