Analyzing Multi-Dimensional Data with Microsoft SQL Server 2000 Training Class

Lesson 1: OLAP Review

The following topics are covered in this module:
OLAP Databases
OLAP Definitions
Warehouse Data Flow

Lesson 2: MDX Foundations

The following topics are covered in this module:
The Role of MDX
MDX Member Names
Using the Calculated Member Builder
Working with Calculated Members

Lesson 3: Using MDX Expressions

The following topics are covered in this module:
Using MDX Expressions
Displaying Member Information
Displaying Family Tree Relatives
Working with Member Properties
Using Conditional Expressions

Lesson 4: Retrieving Values from a Cube

The following topics are covered in this module:
Understanding Multidimensional Coordinates
Retrieving a Value from a Cube
Percent of Total Calculations
Growth Calculations

Lesson 5: Creating Simple MDX Queries

The following topics are covered in this module:
Understanding MDX Query Statements
Creating Simple MDX Query Statements

Lesson 6: The following topics are covered in this module: Creating and Manipulating Sets

The following topics are covered in this module:
Using Set Creation Functions

Lesson 7: Using Aggregation Functions

The following topics are covered in this module:
Understanding Aggregation Functions
Using Time Set Functions
Calculating a Trend

Lesson 8: Case Study - Implementing Budget Allocations

The following topics are covered in this module:
Allocating Values from a Grand Total
Allocating Values from a Subtotal
Allocating Values Across Multiple Dimensions

Lesson 9: Using Calculated Cells

The following topics are covered in this module:
Using Calculated Cells