09/06/2022 - 09/09/2022
10:00 AM - 06:00 PM
Online Virtual Class
USD $2,395.00
Enroll
09/19/2022 - 09/22/2022
10:00 AM - 06:00 PM
Online Virtual Class
USD $2,395.00
Enroll
10/24/2022 - 10/27/2022
10:00 AM - 06:00 PM
Online Virtual Class
USD $2,395.00
Enroll

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