Real World Cube Design and Performance Tuning with Analysis Services

9-10 Feb 2011 (Add to calendar) GMT
Progressive Training Centre , London, GB

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


Other nearby events



Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“My definition of an expert in any field is a person who knows enough about what's really going on to be scared.” - P. J. Plauger