10th September 25 | East Midlands Data | Nottingham | Speaker - Joe Billingham

___________________________________________________________________________________

MeetUp Agenda

18:00 - Arrive. Networking
18:30 - Guest Speaker Talk
19:30 - Pizza. Networking
20:30 - Event Close

___________________________________________________________________________________

The DAX Speed Blueprint: Locate, Understand, Accelerate
Slow performing Power BI reports and visuals are a major cause of frustration. Finding the cause of these slow-downs and understanding why they are happening are the first steps in resolving them.

In this session we'll discuss the troubleshooting steps for slow DAX executions, using tools like Performance Analyser and DAX Studio.

We'll cover the different purposes behind the two parts of the DAX engine - Storage and Formula, and how to write expressions that target each individual component, allowing us to utilise their combined power to unlock the full potential of DAX.

We'll see how optimising expressions in order to harness the power of these engines helps increase performance. This will be done using live demonstrations showing the actual difference in executions times as well as exploring query plans.

By the end of this session, you will know how to identify which DAX expressions are causing issues in your reports, you'll have a solid understanding of what the DAX engine consists of, how the parts work together and how to use them to your advantage to make your expressions faster and more efficient. You will also know how to view a DAX query plan to help troubleshoot slow performing queries.
___________________________________________________________________________________

Venue Website

https://www.castlerockbrewery.co.uk/pubs/vat-and-fiddle

___________________________________________________________________________________

MeetUp Member Resources In GitHub Here:

https://github.com/EastMidlandsData

Including introduction slides and our Code of Conduct.

___________________________________________________________________________________