Business Intelligence training -  SSAS - Multidimensional

SSAS Training

SSAS Multidimensional training course

£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 coursesLocations:Manchester
  • Next SSAS - Multidimensional course locationNext course:Thu 29 August 2019
  • SSAS - Multidimensional course timesTime:09.30-16.30

Course Contents

Multi-dimensional models

  • Training topicOLAP and OLTP
  • Training topicWhat are cubes?

Visual Studio primer

  • Training topicConfiguring Visual Studio
  • Training topicCreating a project
  • Training topicCreating a data source

Data Source Views

  • Training topicKeys and relationships
  • Training topicExploring data
  • Training topicNamed queries
  • Training topicNamed calculations

Dimensions

  • Training topicThe dimension wizard
  • Training topicAttribute hierarchies
  • Training topicDeploying dimensions

Publishing dimensions and cubes

  • Training topicDeploying
  • Training topicProcessing
  • Training topicHandling deployment errors

Basic Cubes

  • Training topicUsing the cube wizard
  • Training topicThe cube designer
  • Training topicFiltering cubes

Star and snowflake schemas

  • Training topicThe 2 types of schema
  • Training topicWhich to use

Hierarchies and Relationships

  • Training topicNatural hierarchies
  • Training topicUnnatural hierarchies
  • Training topicAttribute relationships
  • Training topicSuppressing hierarchies

Parent-child Hierarchies

  • Training topicThe self-join needed
  • Training topicTidying up the dimensions
  • Training topicLimitations

Time dimensions

  • Training topicCreating a time dimension
  • Training topicAutogenerating
  • Training topicCreating time hierarchies

Measures

  • Training topicMeasures and measure groups
  • Training topicFormatting measures
  • Training topicDimension usage
  • Training topicMultiple measure groups

Calculations

  • Training topicCreating calculations
  • Training topicFormatting calculations
  • Training topicBasic MDX expressions

MDX Expressions

  • Training topicYear-to-date
  • Training topicRatios
  • Training topicPrevious period comparisons
  • Training topicRanking

KPIs

  • Training topicKey Performance Indicators
  • Training topicStatus and trend expressions
  • Training topicUsing KPIs in client tools
  • Training topicKPI functions

Using client software

  • Training topicUsing Excel as a client
  • Training topicUsing Reporting Services

Cube actions

  • Training topicCreating URL click-throughs
  • Training topicDrill-through actions

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Manual brilliant and will use in future."

Rob Osipiuk (St James's Place)

"The trainer was brilliant. Examples with comments, manual and exercise book also super helpful for future reference."

George Kelly (CFC Underwriting)

"Course was very intuitive and was very well conducted."

Steven Chambers (Home Group Ltd)

"Excellent course. Very enjoyable. Can't wait to take these skills back to the office."

Claire Jones (Swiss Reinsurance Management Ltd)

"Trainer was friendly, knowledgeable and helpful. Liked the way we were asked questions (as a group) to get us thinking."

Alex Wallace (Manchester Metropolitan University)

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

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).

Scheduled SSAS - Multidimensional training dates

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

Dates Days Venue Price Booking
Thu/Fri 29-30 August 2019 2 £695 Book places
Tue/Wed 22-23 October 2019 2 £695 Book places
Tue/Wed 17-18 December 2019 2 £695 Book places
Date(s) Venue
29/08
22/10
17/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