Nikola Ilic

Information & Communications Technology

Microsoft Business Intelligence Microsoft Power BI SQL Server SSAS Azure Azure Synapse Azure Synapse Analytics Microsoft Power platform

Salzburg, Austria

From XL to S - Reduce your Power BI model size by 90%!

Have you ever wondered what makes Power BI so fast and powerful when it comes to performance? So powerful, that it performs complex calculations over millions of rows in a blink of an eye.

In this session, we will dig deep to discover what is “under the hood” of Power BI, how your data is being stored, compressed, queried, and finally, brought back to your report. After the session, you will get a better understanding of the hard work happening in the background and appreciate the importance of creating an optimal data model in order to get maximum performance from the Power BI engine.

Finally, you will see a real use-case demo showing how the Power BI data model was reduced by 90%!


Nikola Ilic

BI Developer, Data Mozart

I'm making music from the data! PowerBI and SQLServer addict, MCT, Pluralsight Author, blogger, speaker...Interested in everything related to data - always eager to extract valuable info from raw data in the most effective way. Multi-year experience working with (predominantly) Microsoft Data Platform (SQL Server, SSAS, SSIS, SSRS, and Power BI). Father of 2 and true football (and Barca) fan!

Nikola's full speaker profile