SQLDay

PLSSUG Conference, Wroclaw, 11 – 13 May 2015

W1: BI track: Real World Cube Design and Performance Tuning with Analysis Services

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