Power BI : Tips, Tricks and Hacks & Reduce your Model Size
This session is a collection of my top tips, tricks & hacks gathered over the years working over the Power BI platform from simple tips to boost your productivity into more advanced non conventional hacks.
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%!
Rui Romano is a Microsoft MVP on Data Platform and has over 15 years of experience working with Microsoft BI/Data Technologies.
Rui is passionate about data and a frequent speaker on Microsoft events.
Lives in Portugal and leads the BI & Analytics team at DevScope.
Data maniac, interested in everything related to data – always eager to extract valuable info from raw data in 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!
A 15 minute break will be held in between sessions.
|18u30||Welcome and introductions|
|18u45||Power BI, Tips, Tricks and Hacks (60 minutes)|
|20u00||From XL to S – Reduce your Power BI model size by 90%!|