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.
Overview
Syllabus
Introduction
Prerequisites
Main Problem
Agenda
Best Practices
Customer Cube Example
Enterprise Features
Compression Settings
Demo
Cluster Compression
Row Compression
Questions
Partitioning
Physical Partitioning
Demo Physical Partitioning
Incremental Processing
QA
Multiple file groups
Disable compression
File groups
Creating cube partitions
Compression limitations
Bridge dimension
Slides scripts
Thank you
Outro
Taught by
PASS Data Community Summit
