Real World Cube Design and Performance Tuning with Analysis Services

Filed in

What you will learn

Day 1

Designing a data warehouse for use with Analysis Services
Dimension design: designing optimal attribute relationships, when to use parent/child hierarchies and ragged hierarchies
Complex cube modelling: multiple measure groups with different dimensionality and different granularities, many-to-many dimensions
Securing your cube: administrative security, dimension security, cell security
Productionisation: understanding processing options, scheduling processing and partition creation, maintenance, monitoring and deployment

Day 2

Understanding Query Execution: SSAS Architecture, using Profiler, Monitoring your Cube
Query Performance Tuning – the storage engine: partitioning and aggregation design
Query Performance Tuning – the formula engine: writing efficient MDX, tuning calculations and queries
Tuning Processing
Scale-up, Scale-out and hardware configuration for SSAS

You might also like...

Deep Fried Bytes: What is the Big Deal about Big Data?

Published 8 years ago, running time 0h39m

In this episode, Woody sits down with Andrew Brust to discuss another “big” technology for developers and IT professionals: Big Data. Woody and Andrew talk about what Big Data is, who is using it, what tools are available and finally how we has technologists can use this for our products and serv.