Training

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

439 University Av
Suite 820
Toronto, ON
M5G 1Y8

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

 

Home > Training > Microsoft > Sharepoint (MOSS & WSS) >

50465 PerformancePoint 2010 Designing & Implementing Scorecards & Dashboards Training and Courseware

Quick Enroll

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.

Audience

Power Users, Developers and IT Professionals

Prerequisites

An understanding of the benefits of business intelligence.

Duration

4 days

Course Outline

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
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
Outline Course Outline

Buy on-site and customized class

Attend a public class

05/28/2012 - Ottawa
$2,100.00 Enroll

06/04/2012 - Calgary
$2,100.00 Enroll

06/04/2012 - Ottawa
$2,100.00 Enroll

07/09/2012 - Montreal
$2,100.00 Enroll

07/23/2012 - Toronto
$2,100.00 Enroll

07/23/2012 - Vancouver
$2,100.00 Enroll

08/20/2012 - Vancouver
$2,100.00 Enroll

08/27/2012 - Ottawa
$2,100.00 Enroll

09/10/2012 - Montreal
$2,100.00 Enroll

09/24/2012 - Toronto
$2,100.00 Enroll

09/24/2012 - Calgary
$2,100.00 Enroll

10/01/2012 - Toronto
$2,100.00 Enroll

10/01/2012 - Ottawa
$2,100.00 Enroll

10/15/2012 - Vancouver
$2,100.00 Enroll

10/22/2012 - Calgary
$2,100.00 Enroll

10/29/2012 - Montreal
$2,100.00 Enroll

*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.