Optimizing Your Data Warehouse for OLAP Processing

Optimizing Your Data Warehouse for OLAP Processing

PASS Data Community Summit via YouTube Direct link

Introduction

1 of 26

1 of 26

Introduction

Class Central Classrooms beta

YouTube playlists curated by Class Central.

Classroom Contents

Optimizing Your Data Warehouse for OLAP Processing

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Introduction
  2. 2 Prerequisites
  3. 3 Main Problem
  4. 4 Agenda
  5. 5 Best Practices
  6. 6 Customer Cube Example
  7. 7 Enterprise Features
  8. 8 Compression Settings
  9. 9 Demo
  10. 10 Cluster Compression
  11. 11 Row Compression
  12. 12 Questions
  13. 13 Partitioning
  14. 14 Physical Partitioning
  15. 15 Demo Physical Partitioning
  16. 16 Incremental Processing
  17. 17 QA
  18. 18 Multiple file groups
  19. 19 Disable compression
  20. 20 File groups
  21. 21 Creating cube partitions
  22. 22 Compression limitations
  23. 23 Bridge dimension
  24. 24 Slides scripts
  25. 25 Thank you
  26. 26 Outro

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.