Get startedGet started for free

Facts vs. dimensions

The two main building blocks of the dimensional model are facts and dimensions. It's important to be able to distinguish between both.

Consider the following star schema:

Diagram of a star schema with an Orders fact surrounded by Location, Item, Customer, Employee, and Time dimensions

Should the fields be part of the fact table, or one of the dimension tables?

This exercise is part of the course

Data Modeling in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise