Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services (M6234)

Classroom Learning

Also available via

Who Needs to Attend

Individuals who design and maintain business intelligence solutions for their organization, work in environments where databases play a key role in their primary job, and may perform database administration and maintenance as part of their primary job responsibilities
Individuals who develop applications that deliver content from SQL Server Analysis Services to the organization

Prerequisites

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
Experience with Microsoft SQL Server, including:
- SQL Server Agent
- SQL Server query language (SELECT, UPDATE, INSERT, and DELETE)
- SQL Server System tables
- SQL Server accounts (users and permissions)

Follow-On Courses

There are no follow-ons for this course.

Learn how to implement an Analysis Services solution in an organization. In this course, you will explore using the Analysis Services development tools to create an Analysis Services database and an OLAP cube and using the Analysis Services management and administrative tools to manage an Analysis Services solution.

This course incorporates material form the Official Microsoft Learning Product (OMLP) 6234: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services.

What You'll Learn

How SQL Server Analysis Services can be used to implement analytical solutions
Create multidimensional analysis solutions with SQL Server Analysis Services
Implement dimensions and cubes in an Analysis Services solution
Implement measures and measure groups in an Analysis Services solution
Query a multidimensional Analysis Services solution
Customize an Analysis Services cube
Deploy and secure an Analysis Services database
Maintain a multidimensional Analysis Services solution
Implement a Data Mining solution

Course Outline

1. Introduction to Microsoft SQL Server Analysis Services

Overview of Data Analysis Solutions
Overview of SQL Server Analysis Services
Installing SQL Server Analysis Services

2. Creating Multidimensional Analysis Solutions

Developing Analysis Services Solutions
Creating Data Sources and Data Source Views
Creating a Cube

3. Working with Cubes and Dimensions

Configuring Dimensions
Defining Attribute Hierarchies
Sorting and Grouping Attributes

4. Working with Measures and Measure Groups

Working With Measures
Working with Measure Groups

5. Querying Multidimensional Analysis Solutions

MDX Fundamentals
Adding Calculations to a Cube

6. Customizing Cube Functionality

Implementing Key Performance Indicators
Implementing Actions
Implementing Perspectives
Implementing Translations

7. Deploying and Securing an Analysis Services Database

Deploying an Analysis Services Database
Securing an Analysis Services Database

8. Maintaining a Multidimensional Solution

Configuring Processing
Logging, Monitoring, and Optimizing an Analysis Services Solution
Backing Up and Restoring an Analysis Services Database

9. Introduction to Data Mining

Overview of Data Mining
Creating a Data Mining Solution
Validating Data Mining Models

Labs

Lab 1: Using SQL Server Analysis Services

Installing SQL Server Analysis Services
Verifying Installation

Lab 2: Creating Multidimensional Analysis Solutions

Creating a Data Source
Creating and Modifying a Data Source View
Creating and Modifying a Cube

Lab 3: Working with Cubes and Dimensions

Configuring Dimensions
Defining Relationships and Hierarchies
Sorting and Grouping Dimension Attributes

Lab 4: Working with Measures and Measure Groups

Configuring Measures
Defining Dimension Usage and Relationships
Configuring Measure Group Storage

Lab 5: Querying Multidimensional Analysis Solutions

Querying a Cube by Using MDX
Creating a Calculated Member
Defining a Named Set

Lab 6: Customizing Cube Functionality

Implementing a KPI
Implementing an Action
Implementing a Perspective
Implementing a Translation

Lab 7: Deploying and Securing an Analysis Services Database

Deploying an Analysis Services Database
Securing an Analysis Services Database

Lab 8: Maintaining a Multidimensional Solution

Configuring Processing
Implementing Logging and Monitoring
Backing Up and Restoring an Analysis Services Database

Lab 9: Introduction to Data Mining

Creating a Data Mining Structure
Adding a Data Mining Model
Exploring Data Mining Models
Validating Data Mining Models

Classroom Dates and Locations

Date	Location
Nov 8 - 10, 2010	Toronto, ON	Register
Jan 5 - 7, 2011	Toronto, ON	Register
Jan 5 - 7, 2011	Ottawa, ON	Register
Jan 5 - 7, 2011	Montreal, QC	Register
Jan 26 - 28, 2011	Vancouver, BC	Register
Jan 26 - 28, 2011	Calgary, AB	Register
May 11 - 13, 2011	Ottawa, ON	Register
May 11 - 13, 2011	Montreal, QC	Register
May 11 - 13, 2011	Toronto, ON	Register