talk-data.com

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

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.

Details

When: Thursday 29th May 2025 Time: arrive for 5:45pm with talks starting from 6pm start prompt Location: Slalom, Bloc Building, 17 Marble St, Manchester M2 3AW Session will not be streamed over MS Teams Complimentary drinks & pizza provided by our hosts & sponsors Robert Walters

May's PBIMCR will feature ..... Speaker Details - the man the myth the legend... Chris Webb (Microsoft) with: The complete guide to Power BI memory usage and memory errors If you've ever seen the "The visual has exceeded the available resources" error in a Power BI report or had your semantic model refresh with a "Resource governing" error, this is the session for you. In it you'll find out how Power BI semantic models use memory, how you can measure memory usage, when and why memory errors occur and what you can do to fix them.

Joe Billingham Consultant @ Purple Frog Systems

The DAX Speed Blueprint: Locate, Understand, Accelerate

Description

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.

About Joe: 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 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 instruments.

This October the Birmingham Microsoft Data Platform User Group is launching a FREE brand new in-person event!

Introducing, FabFest 2024!!🎉

It will take place at Millennium Point in Birmingham on October 3rd.

• 1 day
• 7+ sessions
• Non-stop learning

A full day’s learning and networking, and some free refreshment thrown in to boot.

Join us and delve into the world of Microsoft Fabric and AI, featuring seven dynamic sessions. Attendees will start with an introduction plus the latest news from Fabric and AI, then progress to more advanced, practical sessions designed to provide a comprehensive understanding and hands-on experience.

Agenda:

09:20 - Alex Whittles – CEO of Purple Frog Understanding Microsoft Fabric Get a deep dive into Microsoft Fabric and how it’s shaping the future of data platforms.

10:25 - Lewis Prince – AI Engineer at Purple Frog Systems Introduction to AI; What, Why and How? In this session Lewis will break down the stigmas on AI and talk about how AI solutions can help any business in any sector.

11:20 - Barney Lawrence – Specialist Microsoft Data Platform Analytics and Engineering Consultant. What's What and Who's Who? Cross System Record Linkage in Fabric Barney will cover the basics of what deterministic, fuzzy, and probabilistic matching are and then dive into creating and applying a model to example data and look at how to analyse the results.

12:40 - James Dales - CEO at Tekantis Realtime streaming data with Microsoft Fabric James will use the Real-Time Intelligence capabilities of Microsoft Fabric to ingest live aircraft flight data as they are flying right now!

13:35 - Joe Billingham – Senior Data Engineer at Purple Frog Systems Harnessing the Power of the DAX Engine: Storage vs Formula Joe will be breaking down the DAX engine, explaining the difference between the storage and formula engines and how understanding this can help optimisation.

14:40 - Abhinav Jayanty – Data Engineer at Quorum Moneyball: How Data has Revolutionised Analytics in Sports Dive into how data analytics has transformed the world of sports, enhancing strategies and driving performance.

15:35 - Paul Andrew – Co-Founder & CTO of Cloud Formations Administering Microsoft Fabric: Capacities, Workspaces, and Domains In this session, Paul will explore the administration of Microsoft Fabric, with a focus on the organisation and management of data storage/compute through the configuration of capacities, domains, data products, environments and workspaces.

For the full agenda and timing, please visit Agenda – FabFestConf

Please let us know if you have registered and can no longer attend as this frees up space for another attendee.

Sponsors: Purple Frog Systems Power BI Sentinel RP Analytics

Microsoft Data Platform Group Birmingham

Thursday 2nd May at 13:00 (BST - UK Time) This week we are doing things a little different and hosting 2 shorter sessions back-to-back.

Session 1: Joe Billingham Title: Harnessing the Power of the DAX Engine: Storage vs Formula

Description: In this session we'll discuss the inner workings of the two parts of the DAX engine - Storage and Formula.

We'll cover the differences between the two parts and how to write expressions that target each individual component, allowing us to utilize their combined power to unlock the full potential of DAX. We'll see how optimizing expressions in order to harness the power of these engines helps increase performance. We'll also introduce two tools to help with diagnosis, Performance Analyser and DAX Studio.

By the end of this session, 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.

Session 2: Lewis Prince Title: CoPilot Studio: Guiding Your Chatbot Take-off with AI Aviation!

Description: I will talk you through how I created the CoPilot chatbot for the SQLBits website. We will look at why CoPilot is relevant, using CoPilot Studio to create your own bespoke bot, how to deal with answers not being right, how to use the inbuilt analytics, how to test and then deploy your bots. There will also be some hints and tips on best practice and what I think works best from my personal experience of using the tool.

Agenda:

12.45 - 13:00 : Setup and Join

13:00 - 13:05 : Open Lobby and Introductions

13:05 - 13:30 : Joe Billingham - Harnessing the Power of the DAX Engine: Storage vs Formula

13:30 - 13:55 : Lewis Prince - CoPilot Studio: Guiding Your Chatbot Take-off with AI Aviation!

13:55 - 14:00 : Questions and Closing Remarks

Venue: Anywhere you have access to a computer or smart device! This session will be online only!

Other Details:

*** Please note registration on MeetUp is required to gain access to the Teams link!***

Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help.

Event Organiser Contact Details:

If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.

Email: [email protected]

Twitter: @MSDataGroupBrum

Sponsors:

Purple Frog Systems

Power BI Sentinel