Overview
Discover techniques to optimize analytical queries and improve performance in this conference talk from PASS Data Community Summit. Learn how to restructure SQL-based jobs and queries for maximum efficiency, enabling timely delivery of analytical results. Explore common performance anti-patterns and their solutions, applicable to various tools including Python, R, Power BI, SSRS, and SSIS. Gain confidence in recognizing and eliminating major bottlenecks, ensuring your work meets tight deadlines. Benefit from the expertise of a Principal Business Intelligence Developer as he shares insights on dramatically enhancing query performance through minor adjustments.
Syllabus
Identifying Anti-Patterns in Analytical Queries - Bert Wagner
Taught by
PASS Data Community Summit