Identifying Anti-Patterns in Analytical Queries
Offered By: PASS Data Community Summit via YouTube
Course Description
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
Related Courses
Introduction to DatabasesMeta via Coursera Web Development
Udacity Introduction to Data Science
University of Washington via Coursera Datenmanagement mit SQL
openHPI Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX