Audience
Power Users, Developers and IT Professionals
Prerequisites
An understanding of the benefits of business intelligence.
Duration
4 days
Outline for 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