Get startedGet started for free

Splitting data into facts and dimensions

Datasets will frequently come in a "wide" format, containing both fact and dimensional data. Breaking these files out into facts and dimensions will improve queries and can improve performance on larger datasets.

In the next few exercises, we'll be creating the following star schema:

Diagram of a star schema with an Establishment Survey fact surrounded by Age, Industry, and Time dimensions

Let's start by creating the Establishment Survey fact and Industry 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