Advanced SSAS
On-Demand Training

Starting At: $395
On-Demand Training
Call Us At: (904) 413-1911

Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our courses cover a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and more.

Advanced SSAS
Per User Per Year
Unlimited Elite Pack


Per User Per Year
Free Trial

Unlimited Elite Pack $100 off through March 31th.


Thanks for reporting a problem. We'll attach technical data about this session to help us figure out the issue. Which of these best describes the problem?

Any other details or context?


Course Details

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.

What Will You Learn?

  • How to create complex reports that use Analysis Services as a data source and custom code assemblies


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

Curriculum For This Course


Dustin Ryan

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 http://www.bidn.com/blogs/dustinryan and http://SQLDusty.wordpress.com.

Related Courses

Course Info
8 Comprehensive Modules
8 Effective Quizzes
Access on Mobile and TV
Certificate of Completion
5h 40m
Download Syllabus
Enrollment Price:
Share this course with your friends