behind Power BI
Description
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. We will also cover some core concepts that affect Power BI performance, such as Aggregations, Materialization, and Relationships.
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-life demo showing how the Power BI data model was reduced by 90%!
Speaker
Nikola Ilic
Microsoft Data Platform MVP at Data Mozart
Nikola Ilic is making music from the data! Power BI and Microsoft Fabric addict, Microsoft Data Platform MVP, Pluralsight Author, blogger, and speaker. He is 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!
Learn more about the Power BI track here.