Advanced SSAS


What Will You Learn?

  • How to create complex reports that use Analysis Services as a data source and custom code assemblies
  • How to master advanced topics of Reporting Services like scaled-out deployment, .Net integration and monitoring Reporting Services usage



This course is designed to take you to the next level in your understanding of SQL Server Analysis Services (SSAS). We use a variety of exclusive lectures on SQL Server internals, as well as hands-on lab exercises to back up the material taught.



Microsoft Solution Architect
Dustin is a Microsoft Solution Architect and was previously a Business Intelligence Consultant with Pragmatic Works. Dustin has provided business intelligence solutions for clients whose issues revolve around SSRS, SSIS and SSAS. When Dustin isn’t consulting, you can find him speaking at SQL Saturday and Code Camp events or blogging at and


What to Know Before the Class

This class assumes that you have a strong understanding of SSAS fundamentals. For example, you should already know and use a majority of the functions in basic cube development before attending this class. While it is not mandatory, it is ideal to have an instance of Analysis Services to follow some sections of the class.

System Requirements

  • 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 databases installed on the instance