Skip to content

Details

This is an Online event, the Teams link will be published on the right of this page for those who have registered.
18:30: The DAX Speed Blueprint: Locate, Understand, Accelerate - Joe Billingham
19:55 Prize Draw - Packt eBooks

Session details:
The DAX Speed Blueprint: Locate, Understand, Accelerate - Joe Billingham
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.
Slow reports? Learn to identify and fix DAX performance issues! This session covers troubleshooting with tools like Performance Analyzer and DAX Studio, understanding the DAX engine's components, and optimizing expressions for better performance

Speaker:
Joe Billingham
Consultant @ Purple Frog Systems
For more than a decade. I've been involved in the fascinating world of data! From SQL Server and SSIS, to Azure Data Factory, Synapse, Power BI, and more recently, Fabric. Day-to-day I'm a consultant and senior member of the data engineering team at Purple Frog Systems, and in my spare time I run the Microsoft Data Platform Birmingham user group as well as my own blog.
Running a user group allows me to connect with amazing folks and either teach or learn from like-minded people. I've had the privilege of speaking at various user groups and conferences, giving back to the community wherever I can.
There's more to me than just data! I'm also the creator of the Data Luthier blog, where I talk all things tech and give a sneak peek into my other passion: guitars! Yup, I'm a total guitar geek – from playing to collecting, fixing, and even crafting my own instruments.

X: @DataLuthier
LinkedIn: linkedin.com/in/billinghamjh/
Blog: dataluthier.com

Microsoft Azure
Business Intelligence Tools
Data Analytics
Data Engineering
Power BI

Members are also interested in