Course Outline

1 - Introduction to Business Intelligence and Data Modeling

Elements of an Enterprise BI Solution
The Microsoft Enterprise BI Platform
Planning an Enterprise BI Project
Lab : Exploring a BI Solution
Exploring the Data Warehouse
Exploring the Analysis Services Data Model
Exploring Reports

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
Creating a Data Source
Creating and Modifying a Data Source View
Creating and Modifying a Cube
Adding a Dimension

3 - Working with Cubes and Dimensions

Configuring Dimensions
Defining Attribute Hierarchies
Sorting and Grouping Hierarchies
Lab : Defining Dimensions
Configuring Dimensions and Attributes
Creating Hierarchies
Creating a Hierarchy with Attribute Relationships
Creating a Ragged Hierarchy
Browsing Dimensions and Hierarchies in a Cube
After completing this module, you will be able to:
Configure dimensions
Define attribute hierarchies
Sort and group attributes

4 - Working with Measures and Measure Groups

Working with Measures
Working with Measure Groups
Lab : Configuring Measures and Measure Groups
Configuring Measures
Defining a Regular Relationship
Configuring Measure Group Storage
After completing this module, you will be able to:
Configure measures
Configure measure groups

5 - Introduction to MDX

MDX Fundamentals
Adding Calculations to a Cube
Using MDX to Query a Cube
Lab : Using MDX
Creating Calculated Members
Querying a Cube by Using MDX

6 - Enhancing a Cube

Working with Key Performance Indicators
Working with Actions
Working with Perspectives
Working with Translations
Lab : Customizing a Cube
Implementing an Action
Implementing Perspectives
Implementing a Translation

7 - Implementing an Analysis Services Tabular Data Model

Introduction to Analysis Services Tabular Data Models
Creating a Tabular Data Model
Using an Analysis Services Tabular Data Model in the Enterprise
Lab : Implementing an Analysis Services Tabular Data Model
Creating an Analysis Services Tabular Data Model Project
Configuring Columns and Relationships
Deploying an Analysis Services Tabular Data Model

8 - Introduction to DAX

DAX Fundamentals
Enhancing a Tabular Data Model with DAX
Lab : Using DAX to Enhance a Tabular Data Model
Creating Calculated Columns
Creating Measures
Creating a KPI
Implementing a Parent-Child Hierarchy

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
Publishing and Viewing a Report
Lab : Creating a Report with Report Designer
Creating a Report
Grouping and Aggregating Data
Publishing a Report

10 - Enhancing Reports with SQL Server Reporting Services

Showing Data Graphically
Filtering Reports by Using Parameters
Lab : Enhancing a Report
Adding a Chart to a Report
Adding Parameters to a Report
Using Data Bars and Sparklines
Using a Map

11 - Managing Report Execution and Delivery

Managing Report Security
Managing Report Execution
Subscriptions and Data Alerts
Troubleshooting Reporting Services
Lab : Configuring Report Execution and Delivery
Configuring Report Execution
Implementing a Standard Subscription
Implementing a Data-Driven Subscription

12 - Delivering BI with SharePoint PerformancePoint Services

Introduction to SharePoint Server as a BI Platform
Introduction to PerformancePoint Services
PerformancePoint Data Sources and Time Intelligence
Reports, Scorecards, and Dashboards
Lab : Implementing a SharePoint Server BI Solution
Creating a SharePoint Server Site for BI
Configuring PerformancePoint Data Access
Creating PerformancePoint Reports
Creating a PerformancePoint Scorecard
Creating a PerformancePoint Dashboard

13 - Performing Predictive Analysis with Data Mining

Overview of Data Mining
Creating a Data Mining Solution
Validating a Data Mining Model
Consuming Data Mining Data
Lab : Using Data Mining to Support a Marketing Campaign
Using Table Analysis Tools
Creating a Data Mining Structure
Adding a Data Mining Model to a Data Mining Structure
Validating a Data Mining Model
Using a Data Mining Model in a Report