VTEC -Course Outline

2791 - Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services

CLASS DATE(s):
Request a Class

COURSE LENGTH: 3 Days

COURSE COST: $1495*

COURSE TIMES: 8:30am - 4:00pm

COURSE OVERVIEW

This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.

*Course Cost does not include books. Please contact a VTEC Account Manager for details.

AUDIENCE AND PREREQUISITES

This course is intended for information technology (IT) professionals and developers who need to implement analysis solutions by using Microsoft SQL Server 2005 Analysis Services. To get the most out of this course, it is highly recommended that students have the following knowledge:

Working knowledge of Transact-SQL. VTEC Course: Introduction to Writing Queries with Transact-SQL

Conceptual understanding of OLAP solutions.

Experience navigating the Microsoft Windows Server environment.

Experience with Windows services (starting and stopping).

Experience creating service accounts and permissions.

SQL Server accounts (users and permissions).

FOLLOW UP COURSES

COURSE TOPICS:

Introduction to Microsoft SQL Server 2005 Analysis Services

Overview of Data Analysis Solutions

Overview of SQL Server 2005 Analysis Services

Installing SQL Server 2005 Analysis Services

Creating Multidimensional Analysis Solutions

Developing Analysis Services Solutions

Data Sources and Data Source Views

Creating a Cube

Working with Dimensions

Configuring Dimensions

Defining Hierarchies

Sorting and Grouping Attributes

Working with Measures and Measure Groups

Querying Multidimensional Analysis Solutions

MDX Fundamentals

Adding Calculations to a Cube

Customizing Cube Functionality

Implementing Key Performance Indicators

Implementing Actions

Implementing Perspectives

Implementing Translations

Deploying and Securing an Analysis Services Database

Maintaining a Multidimensional Solution

Configuring Processing Settings

Logging, Monitoring, and Optimizing an Analysis Services Solution

Backing Up and Restoring an Analysis Services Database

Introduction to Data Mining

Overview of Data Mining

Creating a Data Mining Solution

Validating Data Mining Models