Module 1: Introduction to Microsoft SQL Server Analysis Services

1. Overview of Data Analysis Solutions

2. Overview of SQL Server Analysis Services

3. Installing SQL Server Analysis Services

Module 2: Creating Multidimensional Analysis Solutions

1. Developing Analysis Services Solutions

2. Creating Data Sources and Data Source Views

3. Creating a Cube

Module 3: Working with Cubes and Dimensions

1. Configuring Dimensions

2. Defining Attribute Hierarchies

3. Sorting and Grouping Attributes

Module 4: Working with Measures and Measure Groups

1. Working With Measures

2. Working with Measure Groups

Module 5: Querying Multidimensional Analysis Solutions

1. MDX Fundamentals

2. Adding Calculations to a Cube

Module 6: Customizing Cube Functionality

1. Implementing Key Performance Indicators

2. Implementing Actions

3. Implementing Perspectives

4. Implementing Translations

Module 7: Deploying and Securing an Analysis Services Database

1. Deploying an Analysis Services Database

2. Securing an Analysis Services Database

Module 8: Maintaining a Multidimensional Solution

1. Configuring Processing

2. Logging, Monitoring, and Optimizing an Analysis Services Solution

3. Backing Up and Restoring an Analysis Services Database

Module 9: Introduction to Data Mining

1. Overview of Data Mining

2. Creating a Data Mining Solution

3. Validating Data Mining Models