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.
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.