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