Learn about the Business Intelligence Multidimensional Model of SQL Server Analysis Services. Fact Tables, Dimensions, Attributes, we cover all the basics with theory and examples. Getting your schema and design right is the most important aspect as well as ensuing a robust, repeatable ETL (that doesn’t cripple your cubes, if it doesn’t work). We look at Cube Design, Visualisation and some Admin topics too.

Learning Outcomes

Creating an end-to-end data warehouse solution, you build the tables, fill the data as well as see it queried from Excel.

Course Requirements

Developers new to Data Warehousing, Beginners new to Data Warehousing.

Course Length

1-day

• Overview
• SSAS Multidimensional Model
• SSAS Tabular Data Model
• Schemas
• Cubes

• SQL Server Data Tools
• Building Dimension Tables
• Building Fact Tables
• Building Cubes

• Dimensions
• Attributes, Hierarchies and drill-down
• Relationships and Collections
• Parent-Child Dimensions
• Slowly Changing Dimensions

• Calculations
• MDX
• KPIs
• Actions
• Partitions and Aggregation Design
• Perspectives

• SSRS using Cubes
• Excel

• Backups and Restoring
• Incremental Updates

Course Price

This course costs £500 excluding VAT

How to Book

Call us or email us on the form below, any questions, ask us!