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.
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 firstname.lastname@example.org.
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
Multiple measure groups
Measure group partitioning
Incremental cube updates
Slowly-changing dimensions – manually
and with SSIS
OLAP / MOLAP / ROLAP / HOLAP
MDX stored procedures
MDX in SSRS
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
Jumping to web sites from cubes
Jumping to SSRS reports from cubes
Overview of XMLA
Overview of AMO
Overview of PowerShell (SQL Server 2008 only)
Admin and user roles
Cube, dimension, and cell security
Backup and restore