To enable social distancing we've completely remodelled our classroom training, launched a full range of live online courses and now provide online training-cum-consultancy.
Classroom training -  SSAS - Multidimensional

Classroom Training

SSAS Multidimensional training course

Available as classroom training course only

£695 + VAT for most venues (£795 + VAT for London)

2 days

SQL Server Analysis Services comes in two varieties: multidimensional or tabular models. This course covers the former (creating multidimensional models, which until version 2012 was the only method possible in SSAS).

This two-day course shows you how to build "cubes" to report on data tied up in your data warehouse or day-to-day transactional database, and show results from these in pivot tables, KPIs and much more. During your the course journey you'll learn how to create dimensions and hierarchies, how to create measures in MDX and how to build and deploy cubes.

Course details

  • Locations for SSAS - Multidimensional coursesPossible locations:London, Manchester
  • Next SSAS - Multidimensional course locationNext classroom course:Tue 11 August 2020
  • SSAS - Multidimensional course timesTime:10.00-16.30

Course Contents

The contents of this course are as follows:

Multi-dimensional models

  • OLAP and OLTP
  • What are cubes?

Visual Studio primer

  • Configuring Visual Studio
  • Creating a project
  • Creating a data source

Data Source Views

  • Keys and relationships
  • Exploring data
  • Named queries
  • Named calculations

Dimensions

  • The dimension wizard
  • Attribute hierarchies
  • Deploying dimensions

Publishing dimensions and cubes

  • Deploying
  • Processing
  • Handling deployment errors

Basic Cubes

  • Using the cube wizard
  • The cube designer
  • Filtering cubes

Star and snowflake schemas

  • The 2 types of schema
  • Which to use

Hierarchies and Relationships

  • Natural hierarchies
  • Unnatural hierarchies
  • Attribute relationships
  • Suppressing hierarchies

Parent-child Hierarchies

  • The self-join needed
  • Tidying up the dimensions
  • Limitations

Time dimensions

  • Creating a time dimension
  • Autogenerating
  • Creating time hierarchies

Measures

  • Measures and measure groups
  • Formatting measures
  • Dimension usage
  • Multiple measure groups

Calculations

  • Creating calculations
  • Formatting calculations
  • Basic MDX expressions

MDX Expressions

  • Year-to-date
  • Ratios
  • Previous period comparisons
  • Ranking

KPIs

  • Key Performance Indicators
  • Status and trend expressions
  • Using KPIs in client tools
  • KPI functions

Using client software

  • Using Excel as a client
  • Using Reporting Services

Cube actions

  • Creating URL click-throughs
  • Drill-through actions

You should only attend this course if you have either attended our two-day introduction to SQL course or if you are comfortable creating queries using SQL. You should also have a good understanding of what a relational database means.

This course is suitable for those using any recent version of SQL Server (there are very few differences between the versions, at least for multi-dimensional models).

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Very fluid, informative; good balance between beginner and complexity. Well paced & easy to follow."

Paul Roberts (SMC Pneumatics)

"Really enjoyed the courses, I thought the trainer was excellent, not only knowledgeable but personable too."

Stephen Groves (Volac International Ltd)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled SSAS - Multidimensional training dates

Here are the classroom SSAS - Multidimensional courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Tue/Wed 11-12 August 2020 2 £695 Book places
Tue/Wed 27-28 October 2020 2 £695 Book places
Tue/Wed 08-09 December 2020 2 £695 Book places
Date(s) Venue
11/08
27/10
08/12

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite SSAS training at your offices (we'll even provide and set up the computers).

Related Courses

Reporting Services

Introduction

2 day course

Introduction to SSIS

Introduction

2 day course

SSAS - Tabular Model RECOMMENDED

Introduction

2 day course

Other Analysis Services training resources

SSAS exercises

SSAS exercises

Our exercises on Analysis Services are viewable through this website, so you can see if this is the course for you.

View SSAS or Tabular exercises

SSAS blogs

SSAS blogs

Look through our series of blogs on Analysis Services as a way of supplementing your knowledge.

View SSAS multi-dimensional or SSAS tabular blogs

This page has 0 threads Add post