Get startedGet started for free

Setting up relationships

Modeling data is a crucial aspect of report development as it helps connect different tables in the form of a star or snowflake schema. There is no column in the Geography table with distinct values, so we cannot directly create its relationship with the Sales table.

In this exercise, you will set up the appropriate relationship between Sales and Geography by creating a calculated column that combines two columns to set up a relationship. Additionally, we will be creating a dedicated date table.

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

This exercise is part of the course

Case Study: Competitor Sales Analysis in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise