Loading tweets...WORKSHOP TITLE: BI track: Real World Cube Design and Performance Tuning with Analysis Services
WORKSHOP SPEAKER: Chris Webb
WORKSHOP ABSTRACT:
In this full-day session, aimed at intermediate-to-experienced Analysis Services developers, we’ll be looking at more advanced cube design topics and query performance tuning. You’ll gain a deeper understanding of Analysis Services cube design best practices, and be able to design cubes and tune queries to achieve maximum performance. \
I’ll be covering:
Advanced dimension design tips and tricks
- Attribute properties and what they do
- Attribute relationship best practices
- The pros and cons of parent/child hierarchies compared to ragged hierarchies
Advanced measure group design tips and tricks
- Methods for handling different granularities and different dimensionality
- Many-to-many relationships deep-dive
- Using measure expressions as an alternative to MDX calculations
- The pros and cons of different dimension/measure group relationship types
Understanding SSAS query execution using Profiler
- SSAS query execution internals
- Reading Profiler traces
Designing effective aggregations
- Understanding when aggregations can and can’t improve query performance
- Designing aggregations using the wizards
- Manual aggregation design
Caching and cache warming
- Understanding the different types of SSAS cache
- Scenarios where data is not cached
- Using the CREATE CACHE statement
- Building a cache warmer
WORKSHOP TIME TABLE: Under Construction or (if You want) In Preparation… detail soon
