SSAS - Multidimensional Model

Course

In London and Manchester

Save 22%
£ 695 + VAT

Description

  • Type

    Workshop

  • Level

    Intermediate

  • Location

    At 2 venues

  • Duration

    2 Days

  • Start date

    Different dates available

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.

Important information

Documents

  • SSAS (Multidimensional Model).pdf

Facilities

Location

Start date

London
See map
Holland House 1-4 Bury Street, EC3A 5AW

Start date

Different dates availableEnrolment now open
Manchester (Lancashire)
See map
Barlow House, Minshull Street, M1 3DZ

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Multi-dimensional models
  • Visual Studio primer
  • Data Source Views
  • Dimensions
  • Publishing dimensions and cubes
  • Basic Cubes
  • Star and snowflake schemas
  • Hierarchies and Relationships
  • Parent-child Hierarchies
  • Time dimensions
  • Measures
  • Calculations
  • MDX Expressions
  • KPIs
  • Using client software
  • Cube actions

Teachers and trainers (1)

Andy Brown

Andy Brown

Microsoft Trainer & Programmer

Course programme

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

Additional information

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

SSAS - Multidimensional Model

£ 695 + VAT