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.