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
Introducing Partitions
Creating Partitions
Using Advanced Settings
Merging Partitions
|
Lesson 11: Implementing Calculations Using MDX
Understanding Calculated Members
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
Securing 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
|
|
|
| Top |
|