Introduction to SSAS Multidimensional

Part Of The On-Demand Courses


  • 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 course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course Description

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.


Click here for a downloadable PDF



Module 01 | Dimension Modeling
46m 02s total


Module 01A | Dimension Modeling
46m 02s


Module 02 | SSAS Overview
53m 20s total


Module 02A | SSAS Overview
53m 20s


Module 03 | Cube Design and Browsing
26m 51s total


Module 03A | Cube Design and Browsing
26m 51s


Module 04 | Dimension and Cube Designers
106m 50s total


Module 04A | Dimension and Cube Designers
106m 50s


Module 05 | Adding New Facts and Dimensions
48m 43s total


Module 05A | Adding New Facts and Dimensions
48m 43s


Module 06 | MDX and Calculations
142m 68s total


Module 06A | MDX Basics
104m 42s


Module 06B | Creating Calculations
38m 26s


Module 07 | Data Mining Basics
56m 24s total


Module 07A | Data Mining Basics
56m 24s


Module 08 | Actions and KPIs
21m 15s total


Module 08A | Actions and KPIs
21m 15s


Module 09 | Reporting Services with SSAS
57m 41s total


Module 09A | Reporting Services with SSAS
57m 41s


Module 10 | Using Excel to Build Cube Interfaces
23m 00s total


Module 10A | Using Excel to Build Cube Interfaces
23m 00s


Module 11 | Administration
97m 23s total


Module 11A | Partitions
18m 25s


Module 11B | Aggregations
23m 55s


Module 11C | Perspectives
05m 57s


Module 11D | Security
18m 30s


Module 11E | Deployment
31m 56s



Pragmatic Works President
Devin Knight is a Microsoft Data Platform MVP, Microsoft Certified Trainer, and President of Pragmatic Works Training. He focuses on driving adoption of technology through learning. He is an author of nine Power Platform, Business Intelligence, and SQL Server books. He has been selected as a speaker for conferences like Power Platform Summit, PASS Summit, SQLSaturdays, and Code Camps for many years. Making his home in Jacksonville, FL Devin is a contributing member to several local user groups.


Click Here To Learn More About Devin And See Certifications And Reviews

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

What to Know Before Class

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.


It is a great course. Thank you.


Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required