Overview

Use methods to optimize performance in Power Query including early filtering, choosing the correct data types and using parameters.  Create Groups to organize your work. See how to break down a long complex query using a modular approach. Take steps to create a query that won't have issues during a future refresh. 

Areas Covered in the Session

• Apply filters early in the query to decrease the amount of data that needs to be processed later on
• Use correct data types to improve data processing and enhance performance
• Create dynamic and flexible queries with parameters
• Create Groups in the Query Pane to organize your work
• Use a modular approach to break down a complex query into smaller segments to improve readability and make it easier to troubleshoot
• Adopt steps to make sure you create a query that won't have issues during a future refresh 
• Remove unnecessary query steps that are no longer needed which can slow down performance
• Learn other miscellaneous tips
  

Who Will Benefit

• Managers
• Business professionals
• Administrative Personnel
• Legal Professionals