PerformancePoint 2010 Designing & Implementing Scorecards and Dashboards

This course has been superseded

Try searching for alternatives

Course Description

This four day course covers design theory, different types of dashboards, planning, deployment and security. Each of the first class objects such as Indicators, KPIs, Filters, Data Sources, and interconnecting them into scorecards and combining scorecards into dashboards is covered in depth. In addition peripheral knowledge that greatly enhances the design experience is provided including an overview of the Microsoft Business Intelligence stack, basic understanding of the hosting services for PerformancePoint 2010 which is SharePoint 2010, MDX queries and SQL Server Analysis Services.
4 Days
Contact us for pricing
 

Prerequisites

An understanding of the benefits of business intelligence.

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

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

Dashboards and Scorecards

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

MDX

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

Dashboard Designer

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

Data Connections

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

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

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

Scorecards

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

Dashboard Details

Dashboard Hierarchy
Dashboard Variance
Dynamic Dashboards
Dashboard Interactivity

Security

Understand SharePoint Security
Understand Authentication in PPS
Secure PPS Objects