SSAS - Multidimensional Model
Course
In London and Manchester
Description
-
Type
Workshop
-
Level
Intermediate
-
Location
-
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
Start date
Start date
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
Microsoft Trainer & Programmer
Course programme
- OLAP and OLTP
- What are cubes?
- Configuring Visual Studio
- Creating a project
- Creating a data source
- Keys and relationships
- Exploring data
- Named queries
- Named calculations
- The dimension wizard
- Attribute hierarchies
- Deploying dimensions
- Deploying
- Processing
- Handling deployment errors
- Using the cube wizard
- The cube designer
- Filtering cubes
- The 2 types of schema
- Which to use
- Natural hierarchies
- Unnatural hierarchies
- Attribute relationships
- Suppressing hierarchies
- The self-join needed
- Tidying up the dimensions
- Limitations
- Creating a time dimension
- Autogenerating
- Creating time hierarchies
- Measures and measure groups
- Formatting measures
- Dimension usage
- Multiple measure groups
- Creating calculations
- Formatting calculations
- Basic 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 Excel as a client
- Using Reporting Services
- Creating URL click-throughs
- Drill-through actions
Additional information
SSAS - Multidimensional Model