PerformancePoint 2010 Designing & Implementing Scorecards and Dashboards
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 PlatformSQL 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 2010Common 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 InternalsDashboard Designer Interface
First Class Objects
Main Window
Properties
Dashboard Designer Features
Data Connections
Data SourcesMultidimensional
Tubular
Specific Sources
SSAS
Excel
SharePoint List
Time Intelligence
Visual Indicators & Key Performance Indicators
Visual IndicatorsCategorizing 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 ReportsAnalytic 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 CategoriesSSAS Template
Standard Template
Tabular Scorecards
Data Sources
Implementing Interactivity
Display Values
Using Filters
Deploying
Dashboard Details
Dashboard HierarchyDashboard Variance
Dynamic Dashboards
Dashboard Interactivity
Security
Understand SharePoint SecurityUnderstand Authentication in PPS
Secure PPS Objects