Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise