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:
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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise