SQL Server 2005 for Business Intelligence Training Class

1. Introduction to Microsoft SQL Server 2005 Analysis Services

Get an introduction to common analysis scenarios and discover how Analysis
Services provides a powerful platform for multidimensional OLAP solutions and
data mining solutions. Discover the main considerations for installing Analysis
Services.

• 
  Overview of Data Warehousing


• 
  Overview of Data Analysis Solutions


• 
  Overview of SQL Server 2005 Analysis Services


• 
  Installing SQL Server 2005 Analysis Services

2. Creating Multidimensional Analysis Solutions

Examine the development tools you can use to create an Analysis Services
multidimensional analysis solution, and learn to create data sources, data
source views, and cubes.

• 
  Developing Analysis Services Solutions


• 
  Data Sources and Data Source Views


• 
  Creating a Cube

3. Working with Dimensions

Learn to edit dimensions and configure dimensions, attributes, and hierarchies.

• 
  Configuring Dimensions


• 
  Defining Hierarchies


• 
  Sorting and Grouping Attributes

4. Working with Measures and Measure Groups

Learn to edit and configure measures and measure groups.

• 
  Working with Measures


• 
  Working with Measure Groups

5. Querying Multidimensional Analysis Solutions

Discover multidimensional expressions (MDX) and learn to implement calculated
members and named sets in an Analysis Services cube.

• 
  MDX Fundamentals


• 
  Adding Calculations to a Cube

6. Customizing Cube Functionality

Learn to customize a cube by implementing KPIs, actions, perspectives, and
translations.

• 
  Understanding KPIs through Application


• 
  Implementing KPIs


• 
  Implementing Actions


• 
  Implementing Perspectives


• 
  Implementing Translations

7. Deploying and Securing an Analysis Services Database

Learn to deploy an Analysis Services database to a production server and
implement security in an Analysis Services multidimensional solution.

• 
  Deploying an Analysis Services Database


• 
  Securing an Analysis Services Database

8. Maintaining a Multidimensional Solution

Explore the maintenance tasks associated with an Analysis Services solution, and
learn how administrators can use the Analysis Services management tools to
perform them.

• 
  Configuring Processing Settings


• 
  Logging, Monitoring, and Optimizing an Analysis Services Solution


• 
  Backing Up and Restoring an Analysis Services Database

9. Introduction to Data Mining

Discover data mining, and learn to implement data mining structures and models
and validate data model accuracy.

• 
  Overview of Data Mining


• 
  Creating a Data Mining Solution


• 
  Validating Data Mining Models

10. Implementing Proactive Caching

Examine the use and importance of indexes in an OLAP environment, and learn to
implement proactive caching.

• 
  Index Creation, Maintenance, and Tuning


• 
  Proactive Caching Overview


• 
  Benefits of Proactive Caching


• 
  Implementing Proactive Caching

11. Analysis Services with Microsoft Office System

Learn to integrate Analysis Services with Microsoft Office.

• 
  Integration with Microsoft Office


• 
  Example Application

12. SQL Server Integration Services (SSIS)

Discover SSIS basics, and learn how to populate a data warehouse using SSIS.

• 
  Overview of SSIS


• 
  New SSIS Architecture


• 
  SSIS Designer


• 
  Running SSIS Packages


• 
  Populating a Data Warehouse with SSIS

13. Set Up and Use Reporting Services

Learn to set up and use Reporting Services.

• 
  Reporting Services Overview


• 
  Development Environment


• 
  Report Manager


• 
  Sample Reports


• 
  Reporting from a Cube

14. Analysis Services Migration 2000 to 2005

Examine the differences between 2000 and 2005 Analysis Services as well as
strategies for moving to SSAS 2005.

• 
  Comparing 2000 to 2005


• 
  Migration vs. Rewrite

• 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