New Features of Microsoft® SQL Server™ 2005 Analysis Services

Description:
In this course you administer and program SQL Server 2005 Analysis Services. In addition, you design and deploy a Unified Dimensional Model as well as work with data mining solutions. This course is intended for architects, database developers, database administrators, and business intelligence developers, who are experienced in Microsoft SQL Server. This course also helps prepare you for certification exam 70-445. 

Objectives:
At the end of the course, students will be able to:
Understand the core concepts of SQL Server Analysis Services (SSAS) and the new features in the SSAS architecture.
Design and deploy a Unified Dimensional Model.
Upgrade to and configure SSAS 2005.
Understand the new MDX and programming features in SSAS 2005.
Understand data mining concepts and the tools used to develop data mining models.

Modules & Lessons
Course Overview
Module Introduction
How to Use This Course
Course Information

Exploring SSAS Core Concepts and Architecture
Module Introduction

SSAS Core Concepts
Lesson Introduction
Data Sources and Data Source Views
Dimensions
Measures and Measure Groups
Cubes
The Unified Dimensional Model (UDM)
Self Test

New Features in the SSAS Architecture
Lesson Introduction
New Server Features for Administrators
New Server Features for Developers
New Client Programmability Features
Self Test
Module Summary

Designing and Deploying a Unified Dimensional Model
Module Introduction

Creating an Analysis Services Project
Lesson Introduction
The Business Intelligence Development Studio
The Visual Studio Integrated Development Environment
Creating a Data Source
Creating a Data Source View
Modifying the Properties of a Data Source View
Self Test

Building a Cube
Lesson Introduction
Starting the Cube Wizard
Selecting the Build Method
Identifying Fact and Dimension Tables
Selecting Time Periods
Selecting Measures and Reviewing Dimension Hierarchies
Deploying a Cube
Self Test

Implementing Advanced Features of a Cube
Lesson Introduction
Adding Business Intelligence to a Cube
Adding Key Performance Indicators to a Cube
Adding Translations to a Cube
Adding Perspectives to a Cube
Adding Actions to a Cube
Adding User-Defined Functions to a Cube
Self Test

Lab: Building a Cube
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary

Administering SSAS
Module Introduction

Upgrading and Migrating to SSAS 2005
Lesson Introduction
Considerations for Upgrading to SSAS 2005
Migrating to SSAS 2005
Self Test

Configuring Roles, Groups, and Permissions
Lesson Introduction
User Authentication
Granting Administrative Access
Granting User Access
Granting Permissions to Roles
Self Test

Managing SSAS
Lesson Introduction
Configuring SSAS
Backing Up an SSAS Database
Restoring an SSAS Database
Processing a Cube
Optimizing SSAS Performance
Self Test

Managing Partitions and Real Time BI
Lesson Introduction
Managing Partitions
Creating a New Partition
Managing Proactive Caching
Self Test

Lab: Administering SSAS
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary

Programming in SSAS 2005
Module Introduction

Exploring SQL Server Management Studio
Lesson Introduction
The Toolbar in SQL Server Management Studio
The MDX Query Editor
The Object Explorer
Self Test

New Features of MDX
Lesson Introduction
Attributes
Hierarchies
Subcubes
Named Sets
Calculated Members
Self Test

Scripting with MDX
Lesson Introduction
An Overview of MDX Scripts
Storing Calculations with a Cube
Scripting Scope and Context Elements
Scripting Variables and Parameters
Handling Exceptions in MDX Scripts
Self Test

New Programming Features
Lesson Introduction
XML for Analysis (XMLA)
ADOMD.NET
Analysis Management Objects (AMO)
Self Test

Lab: Programming in SSAS 2005
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary

Working with Data Mining Solutions in SSAS
Module Introduction

Data Mining Concepts and New Features
Lesson Introduction
An Introduction to Data Mining
Using Data Mining to Enhance Business Solutions
Data Mining Algorithms
Self Test

Exploring Data Mining Models
Lesson Introduction
Data Mining Models
Considerations for Developing Data Mining Models
Self Test

Working with Data Mining Tools
Lesson Introduction
Creating a Data Mining Structure
The Data Mining Designer
Validating Data Mining Models
Data Mining Extensions (DMX)
Data Mining Using SQL Server Management Studio
Self Test

Lab: Working with Data Mining Solutions
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary