Which Analysis Services course should you choose?

We run two courses in 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.