Loading Events

« All Events

Webinar | Building a Stronger Foundation: Performance, Optimization, and Intelligent Error Handling in Power Query

October 15 @ 14:00 - 15:00 UTC-5

There are two cornerstones to building optimized and low maintenance queries in Power BI.

The first is making sure queries have been designed to refresh at optimal speeds.

Primary topics for performance tuning include: removing columns and rows, applied step configuration and order precedence, query folding, managing variables, and tables vs lists for transformations.

The other important cornerstone is intelligently identifying and handling errors as they occur during scheduled refreshes.

Primary topics for error handling include: replacing vs removing errors, collecting error metadata, and configuring the refresh to either fail or refresh successfully when errors occur.

Speaker

Reid Havens is a Microsoft MVP. He has a formal background in technology and organizational management, having obtained separate Master’s Degrees in Organizational Development & Business Analytics. Reid has experience working with many of the Fortune 50, 100, & 500 companies. Additionally he guest lectures at the University of Washington and other universities, teaching Business Intelligence, Reporting, & Data Visualization.

 

Reid is also an avid content developer, having authored numerous articles and videos on various blog sites and video platforms. He’s written multiple training curriculum’s for various companies, and taught them as an instructor at dozens of companies around the world. He also developed college level courses for The University of Washington and other universities. His most recent endeavors have been the development of online self-guided video courses for various online platforms such as Pluralsight and Packt Publishing.

Details

Date:
October 15
Time:
14:00 - 15:00 UTC-5
Event Category:

Venue

ONLINE

Organiser

SolidQ in North America