Outline of PerformancePoint 2010 Designing & Implementing Scorecards & Dashboards Training

1. The Business Intelligence Stack

• SQL 2008R2 Business Intelligence Platform
• SQL Analysis Services
• SQL Reporting Services
• Performance Management Tools
• SharePoint 2010
• Multidimensional Space
• MDX
• Data Mining
• Understanding the Terminology

2. The PerformancePoint 2010

• Integration with SharePoint Server 2010
• Common Service Application Framework
• New PerformancePoint Features
• Storage Security
• Time Intelligence & Dynamic Filters
• Linking of Web Parts
• KPI Details Report
• Retired Features

3. Dashboards and Scorecards

• What is Dashboard?
• What is Scorecard?
• Scorecards in PPS
• KPI Collections
• Dashboard Design Guidelines
• Dashboards designed to Monitor
• Dashboards designed to Analyze
• Dashboards designed as Management Views

4. MDX

• What is MDX?
• MDX Query Editor
• Select Statement
• Key Concepts
• Sets
• Functions
• Time Intelligence

5. Dashboard Designer

• Dashboard Designer Internals
• Dashboard Designer Interface
• First Class Objects
• Main Window
• Properties
• Dashboard Designer Features

6. Data Connections

• Data Sources
• Multidimensional
• Tubular
• Specific Sources
• SSAS
• Excel
• SharePoint List
• Time Intelligence

7. Visual Indicators & Key Performance Indicators

• Visual Indicators
• Categorizing Indicators
• Performance Measures
• KPI Characteristics
• KPI Details
• KPI Templates
• Formatting Numbers
• Data Mappings
• Calculation Metrics
• Scoring Patterns
• Banding Methods
• KPI Details Report

8. Visual Reports & Filters

• Types of Reports
• Analytic Chart
• Analytic Grid
• Excel Services
• ProClarity Analytics
• SQL Server Reporting Services
• Filters
• Filtering
• Provider and Consumer
• Member Selection
• Named Set
• STPS to MDX
• Post Formula

9. Scorecards

• Three Categories
• SSAS Template
• Standard Template
• Tabular Scorecards
• Data Sources
• Implementing Interactivity
• Display Values
• Using Filters
• Deploying

10. Dashboard Details

• Dashboard Hierarchy
• Dashboard Variance
• Dynamic Dashboards
• Dashboard Interactivity

11. Security

• Understand SharePoint Security
• Understand Authentication in PPS
• Secure PPS Objects