www.jbinternational.co.uk sales@jbinternational.co.uk Call Free 0800 028 6400

JB International 1345 High Road London, N20 9HR +44 (0) 20 8446 7555

 

Advanced SQL Server 2005 / SQL Server 2008 Analysis Services (SSAS) Training Course UK

Dates and full course list

Advanced SQL Server 2005 / SQL Server 2008 Analysis Services (SSAS) Training Course Overview

Course Code:	SQL0100
Price:	£995
Duration:	2 Days - custom / on-site options available - please call.
DATE:
Who should attend:	Existing Database specialists who need to get more out of SQL Server 2005 / SQL Server 2008 Analysis Services for Data Warehousing and Data Mining.
Prerequisite Skills:	You should be able to understand table, column, data type design, and write SQL Select statements within any relational database; also to write SQL Server stored procedures. You should have experience of populating a Star Schema; and of designing, building and deploying simple SSAS cubes with the Cube Wizard.

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 email .

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