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:

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:

Pivot field table list

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:

DAX calculated column

A very simple formula - they will get harder!

You'll then learn how to create measures like this:

DAX measure

A measure (in this case showing total sales for the London region).

You'll learn how to use measures to create and show KPIs:

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:

Data source view

You'll learn how to create a data source, and then a data source view.

 
 

You'll then learn how to create dimensions:

Dimension wizard

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:

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:

Cube structure

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.

 

This page has 0 threads Add post