Optimizing Your Data Warehouse for OLAP Processing
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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
Database Administration and SQL Language BasicsA Cloud Guru PostgreSQL Administration Deep Dive
A Cloud Guru Administering an AlloyDB Database
Google via Google Cloud Skills Boost Advanced Data Modeling
Meta via Coursera Amazon Aurora MySQL - Migration (Korean)
Amazon Web Services via AWS Skill Builder