2074 Designing And Implementing Olap Solutions With Microsoft SQL Server 2000 en Monterrey

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
- Using the Disabled Property

At the end of this module, you will be able to use the Cube Editor to create and manipulate cubes, add measures and dimensions, and assign properties to improve cubes. This includes: