Which Analysis Services course should you choose?
We run two courses in Analysis Services:
| Software | Course | Length |
|---|---|---|
| SSAS tabular model | Introduction to SSAS Tabular | 2 days |
| SSAS multi-dimensional | Introduction to SSAS Multi-dimensional | 2 days |
The rest of this page explains what you'll learn on each of these courses, but you might also like to see our blog on the differences between the two versions of Analysis Services.
Analysis Services (SSAS) Tabular Model
The first thing you'll learn on this course is how to import data, and create a data model:
You'll learn how to import tables, and how to hide tables and columns in your data model.
You'll then learn how to use this to create pivot tables:
The pivot table field list won't show columns/tables which are hidden.
You'll then learn how to use DAX to create calculated columns:
A very simple formula - they will get harder!
You'll then learn how to create measures like this:
A measure (in this case showing total sales for the London region).
You'll learn how to use measures to create and show KPIs:
Part of the dialog box for creating KPIs.
All this, and much more! For a full list of what you'll learn, see our course outline.
Analysis Services (SSAS) - Multidimensional (Cubes0
Until SSAS 2012 this was the only way that you could use Analysis Services. On this two-day course, you'll learn how to import data:
You'll learn how to create a data source, and then a data source view.
You'll then learn how to create dimensions:
A dimension is a hierarchical way of looking at data - here you can view data by region, town and shopping centre.
Having created dimensions, you'll then learn how to build a cube:
You'll also learn how to create measures using the MDX language, as part of a cube.
Here's the structure of a cube:
A cube that you'll learn to create on the course.
This gives you an idea of what the course will cover, but you'll also learn how to create KPIs, time dimensions ... and much more! For a full list of the course contents, go here.