Get startedGet started for free

Load a new dimension

Sometimes, you'll want to import a separate file as a dimension. This will further extend the amount of relevant information you can learn given your fact data. In our case, it would be nice to have some more time-related information. Adding a Time dimension will allow us to aggregate data not just at the year-level, but also the decade- or even century-level.

Let's continue with the star schema from before:

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_2_load_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