Real World Cube Design and Performance Tuning with Analysis Services

This course aimed at intermediate-to-experienced Analysis Services developers, 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.


  • 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
  • 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


Chris Webb is the owner of Crossjoin Consulting, and is a consultant specialising in Analysis Services, MDX, PowerPivot and DAX. He is a co-author of “Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model”, “Expert Cube Development with SQL Server 2008 Analysis Services”, and “MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase”, and blogs at

Copyright 2019 Orange Man · RSS Feed · Log ind · Google+

Organic Themes