SQL Server Analysis Services Multidimensional Training Course

SQL Server Analysis Services Multidimensional Training Course, SSAS

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

SQL Server Analysis Services Multidimensional Training Course Agenda

Business Intelligence
  • Overview
  • SSAS Multidimensional Model
  • SSAS Tabular Data Model
  • Schemas
  • Cubes
Creation
  • SQL Server Data Tools
  • Building Dimension Tables
  • Building Fact Tables
  • Building Cubes
Dim Designing
  • Dimensions
  • Attributes, Hierarchies and drill-down
  • Relationships and Collections
  • Parent-Child Dimensions
  • Slowly Changing Dimensions
Cube Designs
  • Calculations
  • MDX
  • KPIs
  • Actions
  • Partitions and Aggregation Design
  • Perspectives
Visualisations
  • SSRS using Cubes
  • Excel
Administration
  • 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!

 

You Might Also Like…

SSRS Training Course
SSIS Training Course
SSAS Tabular Course
Power BI Training Course
Performance Tuning Course
New Features of SQL Course
Data Warehouse Training
Advanced TSQL Course
Advanced SQL DBA Course

 

3 + 3 =

Summary
SQL Server Analysis Services Multidimensional Training Course
Service Type
SQL Server Analysis Services Multidimensional Training Course
Provider Name
Sequallity Ltd,
80-83 Long Lane,London,EC1A 9ET,
Telephone No.020 3507 1989
Area
UK
Description
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.