Introduction to SSAS
On-Demand Training

Starting At: $195
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.

Introduction To 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

In this course, you’ll learn how to use SSAS in your enterprise. This training takes you from the ground up, teaching you the fundamental skills needed to develop and deploy SSAS solutions and present this new data to your end users.

What Will You Learn?

  • To develop a data warehouse for your company
  • To develop a repeatable methodology for a successful SSAS project
  • To create and configure a cube and dimensions
  • To write MDX (the querying language for cubes)
  • To define calculations, Key Performance Indicators (KPIs) and perspectives, and implementing dynamic security
  • To administer and deploy SSAS, defining actions, implementing data mining
  • To build office-based BI applications and dashboards, and administering SSAS


This class assumes that you have no previous knowledge of OLAP or Analysis Services. Technical knowledge of basic database design concepts is assumed. It is required that you already know how to navigate around SQL Server 2005/2008/2012/2014 and how to query a SQL Server.

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, 2008, 2012, 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
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance

Curriculum For This Course


Devin Knight

Director of Training

Devin Knight is our Training Lead, overseeing our workshops, boot camps, virtual training, webinars and corporate training programs. Devin is a Microsoft Most Valued Professional (MVP) and has authored numerous technical publications, including the books: "Knight’s 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services", "Knight’s Microsoft Business Intelligence 24-Hour Trainer" and "SharePoint 2010 Business Intelligence 24-Hour Trainer". He has been selected as a speaker for conferences like PASS, SQLSaturdays and Code Camps for many years, and is the President of the SQL Server User Group in Jacksonville, Florida (JSSUG).

Related Courses

Course Info
12 Comprehensive Modules
12 Effective Quizzes
Access on Mobile and TV
Certificate of Completion
10h 5m
Download Syllabus
Enrollment Price:

Share this course with your friends