Tips to Boost your AS and Power BI Data Model Performance

Performance is one of the major challenges and plays a vital role in the success of your product/application. In the world of agile development, we tend to focus more on the number of features that we can deliver than on the quality ( there are many attributes that contribute to this, will talk about them in a different blog post).

If you are a data analyst, below is what you hear from your users all day every day …and you are used to it …don’t you😀😀😀😀

So let's see some of the techniques that will help us improve the model performance, but before delving into performance improvement techniques, let us discuss the factors that most impact the performance of an AS Tabular Model and a Power BI data model.

Below are the most critical factors that impact the performance from my view.

→ Gaps in understanding the business requirements, application objectives, and user scenarios
→ Misanalysis of data and misinterpretation of user expectations
→ Implementing the model with no clear understanding of the design
→ Storing more than the required data into the model.
→ Add/Edit columns with improper data types and data sizes
→ Improper data transformation techniques
→ Add/keep unwanted measures and calculated tables
→ Missing regular analysis of usage metrics and report…