Lesson 1: Introduction to Data Warehousing and OLAP

• Introducing Data Warehousing
• Defining OLAP Solutions
• Understanding Data Warehouse Design
• Understanding OLAP Models
• Applying OLAP Cubes

Lesson 2: Introducing Analysis Manager Wizards

• Defining Terms
• Previewing Analysis Manager
• Preparing to Create a Cube
• Building the Sales Cube
• Processing the Cube
• Viewing the Results

Lesson 3: Understanding Analysis Services Architecture

• Overview
• Microsoft Data Warehousing Overview
• Analysis Services Components
• Metadata Repository
• Cube Storage Options
• Client Architecture
• Office 2000 OLAP Components

Lesson 4: Building Dimensions Using the Dimension Editor

• Understanding Dimension Basics
• Shared vs. Private Dimensions
• Working with Standard Dimensions
• Basic Level Properties
• Working with Parent-Child Dimensions

Lesson 5: Using Advanced Dimension Settings

• Working with Levels and Hierarchies
• Working with Time Dimensions
• Creating Custom Rollups
• Introducing Member Properties
• Understanding Virtual Dimensions

Lesson 6: Working with Cubes and Measures

• Introduction to Cubes
• Working with Cubes
• Introduction to Measures
• Working with Measures
• Defining Cube Properties
• Using the Disabled Property

Lesson 7: Case Study - Creating the Store Expense Cube

• Building the Store Expense Cube
• Updating the Store Expense Cube

Lesson 8: Managing Storage and Optimization

• Analysis Server Cube Storage
• The Storage Design Wizard
• Analysis Server Aggregations
• Usage-Based Optimization
• Optimization Tuning   

Lesson 9: Processing Dimensions and Cubes       

• Introducing Dimension and Cube Processing
• Processing Dimensions
• Processing Cubes
• Optimizing Cube Processing
• Troubleshooting Cube Processing

Lesson 10: Managing Partitions

• Creating Partitions
• Using Advanced Settings
• Merging Partitions

Lesson 11: Implementing Calculations Using MDX

• Building Calculated Members
• Creating Non-Measure Calculated Members
• Using Functions Within Calculated Members
• Understanding Other Calculation Methods
• Introducing Solve Order

Lesson 12: Working with Virtual Cubes

• Understanding Virtual Cubes
• Obtaining Logical Results
• Building a Virtual Cube
• Creating Calculated Members

Lesson 13: Using Excel as an OLAP Client

• Office 2000 OLAP Components
• Using Excel PivotTables
• Using PivotCharts
• Working with Local Cubes
• Creating OLAP-Enabled Web Pages

Lesson 14: Using Actions, Drillthrough, and Writeback

• Creating Actions
• Performing Drillthrough
• Understanding Writeback

Lesson 15: Implementing Security

• Introducing Analysis Services Security
• Understanding Administrator Security
• Helping Protect User Authentication
• Understanding Database Roles
• Implementing Dimension Security
• Managing Cube Roles

Lesson 16: Deploying an OLAP Solution

• Introducing DTS
• Executing and Scheduling Packages
• The Analysis Services Processing Task
• Copying and Archiving OLAP Databases

Lesson 17: Introduction to Data Mining

• Introducing Data Mining
• Training a Data Mining Model
• Building a Data Mining Model with OLAP Data
• Browsing the Dependency Network

Lesson 18: Case Study - Working with the Foodmart Database

• Building the Warehouse Cube
• Building the Sales Cube
• Building the Warehouse and Sales Virtual Cube