Introduction to Data Warehousing
Defining Data Warehousing Concepts
Introduction to OLAP
Microsoft Analysis Services

Designing a Data Warehouse
The principles of Designing a Warehouse
Identifying Fact Tables and Dimensions
Reviewing a Data Warehouse Case Study

DTS
Using DTS as a Building Block for a Data Warehouse
Bringing Data from Multiple Sources
Aggregating and Cleaning Data

Building Cubes
Converting Relational Databases and Other Data Sources into Data Cubes
Defining Dimensions

Managing a Data Cube
Designing Storage
Developing Build Strategies
Processing Cubes
Restricting Access Through Permissions

Querying a Data Cube
Using Microsoft Tools
Excel’s Pivot Table Service
Web pages
Microsoft Data Analyser

Data Mining
Using the Microsoft Data Mining Algorithms to Find Detail in the Data

MDX
Querying a Data Cube Using the Multi-Dimensional Exchange Query Language