Optimizing Your Data Warehouse for OLAP Processing
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
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.
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
Related Courses
MongoDB for DBAsMongoDB University MongoDB Advanced Deployment and Operations
MongoDB University 内存数据库管理
openHPI Data Cleansing with Data Quality Services (DQS)
Microsoft via edX Recovering Data in Azure and SQL Server
Microsoft via edX