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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
