SQL Server Analysis Services (SSAS) - Multidimensional Model

£1000 per delegate. This may be less for special offers on specific course dates and in-company training courses

Duration: 3 days

Trainer: S047OW

Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...


SQL Server Analysis Services now 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 3-day course shows you how to build "cubes" of the data tied up in your data warehouse or day-to-day transactional database, and use these to monitor KPIs, perform data-mining and much more. On the course you'll learn how to create dimensions and hierarchies, how to build and deploy cubes, and how to write MDX to analyse your data.


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 either SQL Server 2012 or 2008 R2 (there are very few differences between the versions, at least for multi-dimensional models).

Course Contents

Multi-dimensional models

- 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


- 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 and measure groups
- Formatting measures
- Dimension usage
- Multiple measure groups

Advanced dimensions

- Role-playing dimensions
- Referenced dimensions


- Creating calculations
- Formatting calculations
- Basic MDX expressions

Writing MDX Queries

- Using axes
- Default and multiple measures
- Sets and named sets
- Tuples
- WHERE clauses

MDX Expressions

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


- 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

Mining Models

- Creating a mining structure
- Decision trees - example
- Clustering - example
- Reviewing model accuracy

Data-mining algorithms

- The 9 types of algorithm
- When to use each algorithm

Course Times


Usually 9.30am - 4.30pm. Course times will be confirmed in the joininginstructions once the course has been booked.

The course either has new dates in data loading, or is only run as a dedicated or In Company course.
  • Corps Construct Logo
  • Safety & Health Logo
  • Hawks Logo
  • Know How Logo
  • Induct Ltd Logo
  • Ace Safety Logo
  • 1UPACCESS Logo
  • BAM Construction Training Logo
  • Citrus Training Logo
  • 3B Training Logo
  • Astutis Logo
  • Construction Industry Training Providers Logo
  • Health Life and Safety Logo
  • MI Construction Training Logo
  • Innov8 Training Logo
  • BSI Training Logo
  • OM Safety Training Logo
  • TotalComms Training Logo
  • SDA Safety Logo
  • Construction Skills People Logo
  • Phoenix Health and Safety Logo
  • Harris Safety Training Logo
  • First Response Training Logo
  • Alliance Learning Logo
  • ALS Safety Logo
  • KeyOstas Logo
  • Libben Health and Safety Logo
  • Global Management Academy Logo
  • Illumine Logo
  • CCAS Health and Safety Logo
  • ROSPA Logo
  • PJH Safety Training Logo
  • OMS Logo
  • Tala Training Logo
  • PRS Health and Safety Training
  • SSG Training and Consultancy Logo
  • RB Services Logo
  • Safety Training Services Logo
  • Clarkson Evans Training Logo
  • Lighthouse Training Logo
  • The Building Safety Group Logo
  • ProSafety Logo
  • Total Training Solutions Logo
  • Kentec Training Logo
  • Total Electrical Training logo
  • NTSS logo
  • Frinton Training logo
  • Envesca logo
  • The Safety Maintenance Company logo
  • APT Health and Safety logo
  • Sandwell Training Association logo
  • PC Workshops logo
  • Zero Harm Training logo
  • R2 Training logo
  • The Bradley Group logo
  • Risk Health and Safety logo
  • Wise Global Training logo
  • Total Training Company Logo
  • Sibbald Training logo
  • Total Construction Training logo
  • UTN Training logo
  • Collective Safety Solutions logo
Telephone Hotline (footer image)

Telephone Hotline

01933 233884

(Monday to Friday - 8:00am to 5:30pm).

© 2021 Book My Course Limited. All rights reserved

Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy