Module 1: Introduction to Business Intelligence and Data Modeling

• Introduction to Business Intelligence
• The Microsoft Enterprise BI Platform
• Lab: Exploring a BI Solution

Module 2: Creating Multidimensional Databases

• Introduction to Multidimensional Analysis
• Creating Data Sources and Data Source Views
• Creating a Cube
• Overview of Cube Security
• Lab: Creating a Multidimensional Database

Module 3: Working with Cubes and Dimensions

• Configuring Dimensions
• Defining Attribute Hierarchies
• Sorting and Grouping Hierarchies
• Lab: Working with Cubes and Dimensions

Module 4: Working with Measures and Measure Groups

• Working with Measures
• Working with Measure Groups
• Lab: Configuring Measures and Measure Groups

Module 5: Introduction to MDX

• MDX Fundamentals
• Adding Calculations to a Cube
• Using MDX to Query a Cube
• Lab: Using MDX

Module 6: Customizing Cube Functionality

• Implementing Key Performance Indicators
• Implementing Actions
• Implementing Perspectives
• Implementing Translations
• Lab: Customizing a Cube

Module 7: Implementing an Analysis Services Tabular Data Model

• Introduction to Tabular Data Models
• Creating a Tabular Data Model
• Using an Analysis Services Tabular Data Model in an Enterprise BI Solution
• Lab: Implementing an Analysis Services Tabular Data Model

Module 8: Introduction to Data Analysis Expression (DAX)

• DAX Fundamentals
• Using DAX to Create calculated Columns and Measures in a Tabular Data Model
• Lab: Creating Calculated Columns and Measures by using DAX

Module 9: Implementing Reports with SQL Server Reporting Services

• Introduction to Reporting Services
• Creating a Report with Report Designer
• Grouping and Aggregating Data in a Report
• Showing Data Graphically
• Filtering Reports Using Parameters
• Lab: Creating a Report with Report Designer

Module 10: Automating Report Execution and Delivery

• Managing Report Security
• Managing Report Execution
• Delivering Reports with Subscriptions and Data Alerts
• Troubleshooting Reporting Services
• Lab: Implementing Report Subscriptions

Module 11: Delivering BI with SharePoint PerformancePoint Services

• Introduction to SharePoint Server as a BI Platform
• Planning Security for a SharePoint Server BI Solution
• Planning for PerformancePoint Services
• Lab: Implementing PerformancePoint Services

Module 12: Performing Predictive Analysis with Data Mining

• Overview of Data Mining
• Using the Data Mining Add-in for Excel
• Creating a Custom Data Mining Solution
• Validating a Data Mining Model
• Connecting to and Consuming Data Mining Data
• Lab: Using Data Mining to Support a Marketing Campaign