Get startedGet started for free

Date dimension and relating tables

In a Power BI report, a dedicated date table is highly recommended for accurate date and time reporting. In this exercise, we will start by creating a dedicated date table to use throughout this case study.

Modeling data is one of the four pillars of Power BI report development as it enables us to connect different data tables together in the form of a star or snow schema. In this exercise, we will be connecting our six tables together with both active and inactive relationships.

We do not recommend doing so, but if you lost progress you can load the solution workbook of the previous exercise 1_1_load_csvs_solution.pbix from the Exercises folder.

This exercise is part of the course

Case Study: HR Analytics in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise