Back to Search Results

Training Course Summary:

This course provides students with the knowledge and skills necessary to design, implement, and deploy OLAP solutions by using Microsoft SQL Server 2000™ Analysis Services.

At the end of the course, students will be able to:

• Define the term OLAP and its role within data warehousing.

• Design multidimensional data marts by using star and snowflake schemas.

• Recognize the fundamental components of a cube.

• Understand the architecture of Analysis Services.

• Create dimensions from relational dimension tables.

• Understand the many types of dimensions.

• Utilize various dimension properties and settings.

• Design OLAP dimensions based on underlying source data.

• Create cubes by using the Cube Wizard and Cube Editor.

• Create and manipulate measures.

• Develop and understand virtual cubes.

• Design cube storage and aggregations.

• Update dimensions and cubes when source data changes.

• Optimize the processing of dimensions and cubes.

• Create partitions within cubes.

• Implement simple calculations by using multidimensional expressions (MDX) and calculated members.

• Use Microsoft Excel 2000 as an OLAP front-end application.

• Understand how data mining fits within OLAP and the Microsoft data warehousing framework.

• Employ actions, drillthrough, and writeback for data analysis.

• Design and implement cube and dimension security.

• Automate the processing of dimensions and cubes through Data Transformation Services (DTS).

• Create cubes and virtual cubes based on end-user requirements.

Pre-Requisites:

Before attending this course, students must have:

• A basic understanding of database design, administration, and implementation concepts.

• A satisfactory level of comfort within the Microsoft Windows 2000 environment.

Training Course Overview/Content:

Module 1: Introduction to Data Warehousing and OLAP

The following topics are covered in this module:

• Introducing Data Warehousing

• Defining OLAP Solutions

• Understanding Data Warehouse Design

• Understanding OLAP Models

• Applying OLAP Cubes


At the end of this module, you will be able to explain the basic design of an OLAP solution. This includes:


• Describing characteristics, goals, and applications of a data warehouse.

• Understanding the need and use for OLAP solutions.

• Describing data warehouse design.

• Understanding the reasons for implementing OLAP models and describing their components.

• Visualizing a multidimensional database.


Module 2: Introducing Analysis Manager Wizards

The following topics are covered in this module:

• Defining Terms

• Previewing Analysis Manager

• Preparing to Create a Cube

• Building the Sales Cube

• Processing the Cube

• Viewing the Results


At the end of this module, you will be able to use the Analysis Manager tools to create and process a cube. This includes:


• Describing Analysis Services components.

• Navigating through the basic interfaces of Analysis Manager.

• Preparing to create a cube by reviewing data sources and initiating the Cube Wizard.

• Creating an OLAP cube by using the Cube and Dimension Wizards.

• Processing a cube.

• Browsing the cube data and metadata by using the Analysis Manager browser.


Module 3: Understanding Analysis Services Architecture

The following topics are covered in this module:

• Overview

• Microsoft Data Warehousing Overview

• Analysis Services Components

• Metadata Repository

• Cube Storage Options

• Client Architecture

• Office 2000 OLAP Components


At the end of this module, you will be able to explain the integration and interaction of the Analysis Services components. This includes:


• Describing the components of the Microsoft data warehouse strategy.

• Understanding the Analysis Services components.

• Describing the function of the Microsoft Metadata Repository.

• Explaining the basic differences between the three storage modes for OLAP cubes-multidimensional OLAP (MOLAP), relational OLAP (ROLAP), and hybrid OLAP (HOLAP).

• Understanding client architecture and the role of the Microsoft PivotTable Service.

• Recognizing Microsoft Office 2000 OLAP capabilities.


Module 4: Building Dimensions Using the Dimension Editor

The following topics are covered in this module:

• Understanding Dimension Basics

• Shared vs. Private Dimensions

• Working with Standard Dimensions

• Basic Level Properties

• Working with Parent-Child Dimensions


At the end of this module, you will be able to build dimensions by using the Dimension Editor. This includes:

• Understanding dimension fundamentals.

• Knowing when to use shared and private dimensions.

• Describing the characteristics of standard dimensions.

• Adding level properties to dimensions.

• Developing parent-child dimensions.


Module 5: Using Advanced Dimension Settings

The following topics are covered in this module:

• Working with Levels and Hierarchies

• Working with Time Dimensions

• Creating Custom Rollups

• Introducing Member Properties

• Understanding Virtual Dimensions


At the end of this module, you will be able to use various advanced dimension settings and methods to develop OLAP dimensions and cubes. This includes:


• Working with dimension levels and hierarchies.

• Understanding and working with time dimensions.

• Creating custom rollup dimensions.

• Defining member properties at dimension levels.

• Creating virtual dimensions from member properties and member levels.


Module 6: Working with Cubes and Measures

The following topics are covered in this module:

• Introduction to Cubes

• Working with Cubes

• Introduction to Measures

• Working with Measures

• Defining Cube Properties

• Usin

Qualifications:

There is no MCP exam associated with this course