Get startedGet started for free

Create another dimension

Time to add the final dimension, Age. In the data you can see that we have information about the Age code for each establishment, but we don't know what the actual meaning of those values is. Let's load another file as a new dimension to allow for slicing by establishment age.

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

If you have lost any progress, close any open reports and load 3_3_create_dim.pbix from the Exercises folder on the desktop.

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