PerformancePoint 2010 Designing and Implementing Scorecards and Dashboards

Connect into a SQL Server Analysis Services Cube

Use SQL Server Management Studio

Explore SharePoint 2010

Integration with SharePoint Server 2010

Common Service Application Framework

New PerformancePoint Features

Storage Security

Time Intelligence and Dynamic Filters

Linking of Web Parts

KPI Details Report

Retired Features

Use SharePoint to create a site collection

Configure Central Administration for PerformancePoint Services

Create and Explore a PerformancePoint Business Intelligence Center

What is a Dashboard?

What is a Scorecard?

Scorecards in PPS

KPI Collections

Dashboard Design Guidelines

Dashboards designed to Monitor

Dashboards designed to Analyze

Dashboards designed as Management views such as Six Sigma

Paper lab

Design each of the three categories of dashboards

Group Review

Design your company dashboard

What is MDX?

MDX Query Editor

Select Statement

Key Concepts

Sets

Functions

Time Intelligence

Understand the Cell

Write a Tuple

MDX Sets

Write a SELECT statement

Write a Function

Implement Time

Dashboard Designer Internals

Dashboard Designer Interface

First Class Objects

Main Window

Properties

Dashboard Designer Features

Create a Data Connection

Create a Basic Dashboard

Deploy the Dashboard

Explore the Dashboard in PPS

Data Sources

Multidimensional

Tabular

Specific Sources

SSAS

Excel

SharePoint List

Time Intelligence

Create a new Business Intelligence site for lab as a sub site

Create a SQL Server Analysis Services Connection and use it as source

Create a Data Connection using Excel Services

Create a Data Source using Import Workbook

Connect into a tabular SharePoint list as a Data Source

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

Best Practices

Create a custom Indicator

Create several KPIs

Create a basic Scorecard to host your KPIs

Utilize a cube as a data source

Create an objective KPI

Create a multi-valued KPI

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

Create an Analytic Grid

Create a Member Selection Filter

Create an Analytic Chart

Create a Strategy Map

Create a Time Intelligence Filter

Use Time Intelligence in a Report

Three Categories

SSAS Template

Standard Template

Tabular Scorecards

Data Sources

Implementing Interactivity

Display values

Using Filters

Deploying

Create a KPI for use in lab

Add a dimension filter

Wire up filters

Compare the effects of filtering

Change Scorecard Settings

Dashboard Hierarchy

Dashboard Variance

Dynamic Dashboards

Dashboard Interactivity

Develop multiple Dashboards

Change Deployed Dashboards

Provide interactive Help for your Dashboards

Monitor Dashboard Utilization

Control Dashboard Updates

Additional Reading

To help you prepare for this class, review the following resources:

Delivering Business Intelligence with Microsoft SQL Server

CWL course 50263D Introduction to Microsoft Business Intelligence