Data model performance optimization
Typically, when exploring data, we load a subset of the data. However, our dataset contains data from 2017 - 2021. For our analysis, we want to review the last three years (2019 - 2021) and see how our manufacturer Sintec performs compared to competitors.
Next, to improve the performance of our data model, we'll want to disable the table load of International Sales
.
We do not recommend doing so, but if you lost progress you can load the solution workbook of the previous exercise 1_3_append_queries_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
