Star schema

The star schema organizes a model around a central fact table linked to several surrounding dimension tables, each in a one-to-many relationship. Simple, readable and performant, it is the recommended form for Power BI analytical models.

Example

Sales in the center, linked to Product, Customer and Date.

Related concepts

The whole glossary