Course Outline
This course has been written to give delegates with existing skills in Data Warehousing with SQL Server a framework of best practises.
Delegates will gain a deep understanding of Cubes, Star Schemas, and Data Mining, using SQL Server 2005 / SQL Server 2008 Analysis Services (SSAS).
Because of the similarities in architecture and functionality between SQL Server 2005 and SQL Server 2008, demonstrations and course labs will either be on SQL 2005 or SQL 2008 with any specific differences being demonstrated where necessary (usually in a short session at the end of each session).
Available as a public or closed course at our London training centre, delivered on-site as a bespoke, customised training course.
Course Content
Our hands-on Advanced SSAS training course has been developed for real-world, commercial scenarios by our expert instructors.
See below for our detailed Advanced SQL Server 2005 / SQL Server 2008 Analysis Services training course syllabus. The course contains many SSAS tutorials based on real-world scenarios. If you have a technical question, please emailsales@jbinternational.co.uk.
What you will learn
By the end of this course you will gain:
1. Cube design best practises and security
2. A deep understanding of MOLAP / ROLAP / HOLAP
3. MDX Queries and Scripts
4. Learn how to use XMLA to create, process and back-up Cubes
5. Effective Data Mining
Advanced SQL Server 2005 / SQL Server 2008 Analysis Services Training Course Outline
Advanced cube design
3 types of date dimension
Role-playing dimensions
Many-to-many dimensions
Parent-child dimensions
Multiple measure groups
Measure group partitioning
Incremental cube updates
Slowly-changing dimensions – manually
and with SSIS
Aggregation design
OLAP / MOLAP / ROLAP / HOLAP
Pro-active caching
Aggregation wizard
Query logs
Visual Organisation
Folders
Perspectives
MDX language
MDX expressions
MDX queries
MDX scripts
Calculated measures
KPIs
MDX stored procedures
MDX in SSRS
Data mining
Definitions
Building SSAS mining models with SSIS
Data mining visualisation with Excel 2007 (DM Plug-in)
DMX language content queries
DMX language prediction queries
DMX in SSRS
Actions
Drillthrough
Jumping to web sites from cubes
Jumping to SSRS reports from cubes
Write-back cubes
More languages!
Overview of XMLA
Overview of AMO
Overview of PowerShell (SQL Server 2008 only)
Administration
Admin and user roles
Cube, dimension, and cell security
Visual totals
Backup and restore
