Optimizing Your Data Warehouse for OLAP Processing

YouTube·PASS Data Community Summit

Explore strategies for optimizing data warehouse processing time in this 58-minute conference talk from PASS Data Community Summit. Learn how to leverage Analysis Services features and database engine capabilities to significantly improve OLAP processing performance. Discover best practices, enterprise-level features, and practical techniques such as compression settings, partitioning, and incremental processing. Gain insights from real-world examples, demonstrations, and expert advice on aligning SSAS and database engine features to achieve up to 200% improvement in processing time for large-scale data warehouses.