Pragmatic Master SSAS (Online)

This four (half day) class is designed to take you to the next level in your understanding of SQL Server 2008/2008R2/2012/2014 Analysis Services (SSAS). We use a variety of lab exercises and exclusive internals lectures to ensure lecture are backed up by hands on experience and real world knowledge. With the hands-on labs, you will learn how to build tier 1 Analysis Services solutions that will scale, while understanding all the internals to help you back up these best practices you will be implementing. This class will focus on the architecture, design, scaling and internals that make Analysis Services the powerful analytics platform of choice.

IMPORTANT: When you purchase a seat in this class you also receive 2 hours of our BI Virtual Mentor service for assistance with YOUR project work. This remote service lets you work ONE on ONE with our BI mentors to accelerate YOUR project and further improve YOUR skills. Your Virtual Mentor hours can be used during business hours anytime during the 12 months following your class. To set up a session, download this simple questionnaire, fill it out, and send it as an attachment to This unique Pragmatic Works offering insures that your training will translate into real world success for YOUR projects.

All virtual training students are provided a previously recorded version of the class that are available for 7 days after the end of the class.


Day 1

  1. Understanding the SSAS Ecosystem
    • BISM Overview
    • Deciding Between Multidimensional and Tabular
  2. Optimizing Dimension Usability
    • Reviewing Dimension Best Practices
    • Usability and Performance Enhancements

Day 2

  1. Advanced Dimension Design
    • Parent-Child Hierarchies
    • Unary Operators
    • Many-to-Many Dimensions
    • Referenced Dimensions
    • Natural Hierarchies
    • Junk Dimensions
    • Degenerate Dimensions
  2. Advanced Partition Design
    • Partitioning for Performance
    • Partition Properties

Day 3

  1. Distinct Count Measure Groups
    • Partition Design Tenants
  2. Advanced Aggregation Design
    • Understanding Aggregations
    • Designing Meaningful Aggregations

Day 4

  1. Memory Management
    • SSAS Memory Architecture
    • SSAS Memory Settings
    • Tuning the Economic Model of Memory Management
  2. MDX Query Performance & Optimization
    • Identifying Query Problems
    • Optimizing MDX Queries and Calculations


The target of this class is at developers, architects or IT professionals who have above average Analysis Services skills already and a basic understanding of MDX and cube building. This class assumes that you have a strong understanding of SSAS fundamentals. For example, you should already know and use the majority of the functions in basic cube development before attending this class. It is not mandatory but ideally you should have an instance of Analysis Services to follow some sections of the class.


  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
    • SQL Server Database Engine
    • SQL Server Analysis Services Multidimensional
    • SQL Server Data Tools (SQL 2012/2014) or Business Intelligence Development Studio (SQL 2008/2008R2)
    • SQL Server Management Studio
    • Follow this installation guide to ensure all items are installed correctly
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 database installed on the instance.

Some of our clients