Cracking Power BI Performance Tuning

Data Céilí are proud to bring you this pre-conference event. All of our precons will be running in Trinity College Dublin on Thursday 13th June.

Congratulations! You've built your shiny fancy Power BI report and your charts look terrific. But, your data refresh takes forever...Or, your report is utterly slow when interacting with visuals...You switch to DirectQuery mode to make things better, just to discover that the report performance sucks even more...

And, if you feel lost, I don't blame you - I've also been there!

That's why this workshop is for you: we will examine potential bottlenecks in your Power BI report - starting with defining the best practices for data model size optimization, understanding the importance of query folding feature, all the way to identifying culprits for your slow report rendering. We will wrap it up with learning when and why (not) to use DirectQuery mode, and how to apply improvements on the data source side to make things faster in the Power BI.

Participants will walk out well-equipped to identify the potential Power BI development areas that need improvement. By understanding specific important concepts and features, and the way Power BI works internally, participants will be able to create highly efficient reporting solutions.

We will wrap it up with learning when and why (not) to use DirectQuery mode, and how to apply improvements on the data source side to make things faster in the Power BI. We'll also examine how to get the most out of the latest Direct Lake mode in Microsoft Fabric, and in which scenarios makes sense to go this route.

Agenda

1. Introduction
2. Data Modeling best practices
3. Data Model Size
4. Data Refresh Process
5. Aggregations
6. DAX Calculations
7. Visualization rendering time
8. Storage Mode choice
9. Performance tuner toolbox
10. Direct Lake Best Practices
11. Summary and quiz

I'm making music from the data! Power BI and Microsoft Fabric addict, Microsoft Data Platform MVP, 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!

• Seats are limited so don't delay! Once we are full you can apply to go on a waiting list for cancellations.
• Refunds are available at 100% up to 3-days before the event, after which the cost is non-refundable as we have commited to various operational costs.
• Covid is not currently an issue we need to manage so we are not forcing any policies on mask wearing, hand sanitizing or maintaining distance. You are free to manage your own personal preferences unless they cause interference with any other attendees or speakers.
• The Data Ceili code of conduct will be fully adhered to on this day. Please take the time to read it at https://www.dataceili.io/code-of-conduct

Event Venue & Nearby Stays

Trinity College Dublin, College Green, Dublin 2, Ireland