Module 1: Introduction to Business Intelligence and Data Modeling

1. Introduction to Business Intelligence

2. The Microsoft business intelligence platform

Module 2: Creating Multidimensional Databases

1. Introduction to multidimensional analysis

2. Creating data sources and data source views

3. Creating a cube

4. Overview of cube security

Module 3: Working with Cubes and Dimensions

1. Configuring dimensions

2. Define 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: Introduction to MDX

1. MDX fundamentals

2. Adding calculations to a cube

3. Using MDX to query a cube

Module 6: Customizing Cube Functionality

1. Implementing key performance indicators

2. Implementing actions

3. Implementing perspectives

4. Implementing translations

Module 7: Implementing a Tabular Data Model by Using Analysis Services

1. Introduction to tabular data models

2. Creating a tabular data model

3. Using an analysis services tabular model in an enterprise BI solution

Module 8: Introduction to Data Analysis Expression (DAX)

1. DAX fundamentals

2. Using DAX to create calculated columns and measures in a tabular data model

Module 9: Performing Predictive Analysis with Data Mining

1. Overview of data mining

2. Using the data mining add-in for Excel

3. Creating a custom data mining solution

4. Validating a data mining model

5. Connecting to and consuming a data mining model