<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Home / SQL Server / Advanced SSAS

Advanced SSAS

An advanced class on SQL Server 2008/2008R2/2012/2014/2016 Analysis Services (SSAS). Learn to build scalable tier 1 SSAS solutions, utilize best practices, focus on architecture, design, scaling, making SSAS your analytics choice.

Free Community Plan View Pricing Plans
  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

This class is designed to take you to the next level in your understanding of SQL Server 2008/2008R2/2012/2014/2016 Analysis Services (SSAS). 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.

Course Outline ( Free Preview)

Advanced SSAS - What you need to get started

Module 01 - Understanding the SSAS Ecosystem

Module 02 - Optimizing Dimension Usability

Module 03 - Advanced Dimension Design 102 min.

Module 04 - Advanced Partition Design 52 min.

Module 05 - Distinct Count Measure Groups 20 min.

Module 06 - Advanced Aggregation Design 73 min.

Module 07 - Memory Management 15 min.

Module 08 - MDX Query Performance & Optimization 15 min.

This course includes:

  • 5+ hours of training
  • 9 Modules
  • * Access on mobile and browser
  • Certificate of Completion
Free Community Plan View Pricing