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.

Agenda

  • 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

Trainer

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 http://cwebbbi.wordpress.com/

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

Organic Themes