Avoiding Common Pitfalls in Models and Reports: Lessons from the Trenches

In this session, Reid Havens will explore best practices for auditing, repairing, and optimizing Power BI PBIX files. Drawing on my experience of building over 100 reports and data models for clients over the past decade, I will share with you the patterns, mistakes, and pitfalls that I have identified. You will learn how to identify common issues in Power Query queries, modeling, relationships, DAX, and report design, and how to apply a toolset of best practices to address them. By following these best practices, you can significantly improve the performance and user experience of your Power BI reports, including reducing file size, improving load and calculation speed, and providing a cleaner interface for end-users.

The meeting will start at 5.30pm with refreshments. The presentation will start shortly after 6pm on Wednesday November 9th.

***LOCATION***
We'll be meeting on the ground floor of the Baker Tilly offices in Madison: 4807 Innovate Ln, Madison, WI 53707. This is where we met in June. It's on the far east side - exit the interstate on US-151 towards Sun Prairie, then exit on American Parkway. Take the first left onto Eastpark Blvd. The Baker Tilly building is 2 buildings after Cambria Suites on Eastpark Blvd. Enter through the main entrance at the front of the building - doors are locked but we'll have someone to let you in and they'll be a phone number to call if you arrive later. What3Words: ///handyman.navigating.mutate