Course Search:
Request more details:


Print Page

PerformancePoint 2010 Designing & Implementing Scorecards and Dashboards

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.
  • Cost: Price on application
  • Duration: 4 Days
  • This course is not available as part of our public schedule but can be provided on a customised client specific basis.
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


Dublin: 01 6627700 - Cork: 021 4319010 - Limerick: 061 311982

© Professional Training Solutions Limited 1996-2012
CRO No. 252390 - Unit 22, Westland Square, Pearse Street, Dublin 2, Ireland.