YoVDO

Optimizing Your Data Warehouse for OLAP Processing

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Database Administration Courses SSAS Courses

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

Microsoft BI Certification Training
Edureka
Building Tabular Models in SSAS
Pluralsight
Série DBA SQL Server - Jobs e Alertas com SQL Server Agent.
Udemy
30+ Saatlik Uçtan Uca İş Zekası Mühendisliği Kursu
Udemy
Modelado y carga de datos con SSAS
PASS Data Community Summit via YouTube