Identifying Anti-Patterns in Analytical Queries

YouTube·PASS Data Community Summit

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.