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
Start Exercise