Home > Analysis Services training

SQL Server Analysis Services training courses

We currently run our standard three-day SSAS course in version 2008 R2. To whet your appetite, here are some of the things that you will learn how to do on this course.

Create cubes

Naturally, you will learn how to create cubes like this:

A simple cube by region and species.

You might also like to look at our PowerPivot training, which accomplishes a similar thing in Excel.

Create natural and unnatural hierarchies

You will learn to impose hierarchies on the dimensions of a cube:

A hierarchy in the making.

Create time (calendar) dimensions

You'll learn how to generate and set up your own calendar dimensions:

An example of a calendar dimension.

Learn MDX

The course covers how to write MDX expressions, using tuples:

You'll learn how to write MDX expressions like this.

KPIs

You'll learn how to create key performance indicators:

An example of three KPIs.

An introduction to data mining

The course includes an overview of data mining in Analysis Services:

The data mining algorithms available.

To see our Analysis Services courseware, exercises and venues, go to our SSAS home page.

Follow @WiseOwlTraining