Performance Point 2010 Designing and Implementing Scorecards and Dashboards

Session Detail:    Classroom 3 Day

This instructor-led course provides students with the necessary knowledge to develop Scorecards and Dashboards using PerformancePoint 2010 in their own work environment. The 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.

Prerequisites

Before attending this course, students should have:

  • An understanding of the benefits of business intelligence.

Who Can Benefit

This course is intended for Power Users, Developers and IT Professionals that will be involved with the design, development and maintenance of actionable performance measurements as displayed in a scorecard and dashboard.

Session Outline

Class Outline

Module 1: The Business Intelligence StackLessons

  • Lesson 1: SQL 2008R2 Business Intelligence Platform
  • Lesson 2: SQL Analysis Services
  • Lesson 3: SQL Reporting Services
  • Lesson 4: Performance Management Tools
  • Lesson 5: SharePoint 2010
  • Lesson 6: Multidimensional Space
  • Lesson 7: MDX
  • Lesson 8: Data Mining
  • Lesson 9: Understanding the Terminology

Module 2: PerformancePoint Services 2010Lessons

  • Lesson 1: Integration with SharePoint Server 2010
  • Lesson 2: Common Service Application Framework
  • Lesson 3: New PerformancePoint Features
  • Lesson 4: Storage Security
  • Lesson 5: Time Intelligence and Dynamic Filters
  • Lesson 6: Linking of Web Parts
  • Lesson 7: KPI Details Report
  • Lesson 8: Retired Features

Module 3: Dashboards and Scorecards OverviewLessons

  • Lesson 1: What is a Dashboard?
  • Lesson 2: What is a Scorecard?
  • Lesson 3: Scorecards in PPS
  • Lesson 4: KPI Collections
  • Lesson 5: Dashboard Design Guidelines
  • Lesson 6: Dashboards designed to Monitor
  • Lesson 7: Dashboards designed to Analyze
  • Lesson 8: Dashboards designed as Management views such as Six Sigma

Module 4: MDX

  • Lesson 1: What is MDX?
  • Lesson 2: MDX Query Editor
  • Lesson 3: Select Statement
  • Lesson 4: Key Concepts
  • Lesson 5: Sets
  • Lesson 6: Functions
  • Lesson 7: Time Intelligence

Module 5: Dashboard DesignerLessons

  • Lesson 1: Dashboard Designer Internals
  • Lesson 2: Dashboard Designer Interface
  • Lesson 3: First-Class Objects
  • Lesson 4: Main Window
  • Lesson 5: Properties
  • Lesson 6: Dashboard Designer Features

Module 6: Data ConnectionsLessons

  • Lesson 1: Data Sources
  • Lesson 2: Multidimensional
  • Lesson 3: Tabular
  • Lesson 4: Specific Sources
  • Lesson 5: SSAS
  • Lesson 6: Excel
  • Lesson 7: SharePoint List
  • Lesson 8: Time Intelligence

Module 7: Visual Indicators and Key Performance IndicatorsLessons

  • Lesson 1: Visual Indicators
  • Lesson 2: Categorizing Indicators
  • Lesson 3: Performance Measures
  • Lesson 4: KPI Characteristics
  • Lesson 5: KPI Details
  • Lesson 6: KPI Templates
  • Lesson 7: Formatting Numbers
  • Lesson 8: Data Mappings
  • Lesson 9: Calculation Metrics
  • Lesson 10: Scoring Patterns
  • Lesson 11: Banding Methods
  • Lesson 12: KPI Details Report
  • Lesson 13: Best Practices

Module 8: Visual Reports and FiltersLessons

  • Lesson 1: Types of Reports
  • Lesson 2: Analytic Chart
  • Lesson 3: Analytic Grid
  • Lesson 4: Excel Services
  • Lesson 5: ProClarity Analytics
  • Lesson 6: SQL Server Reporting Services
  • Lesson 7: Filters
  • Lesson 8: Filtering
  • Lesson 9: Provider and Consumer
  • Lesson 10: Member Selection
  • Lesson 11: Named Set
  • Lesson 12: STPS to MDX
  • Lesson 13: Post Formula

Module 9: ScorecardsLessons

  • Lesson 1: Three Categories
  • Lesson 2: SSAS Template
  • Lesson 3: Standard Template
  • Lesson 4: Tabular Scorecards
  • Lesson 5: Data Sources
  • Lesson 6: Implementing Interactivity
  • Lesson 7: Display values
  • Lesson 8: Using Filters
  • Lesson 9: Deploying

Module 10: Dashboard DetailsLessons

  • Lesson 1: Dashboard Hierarchy
  • Lesson 2: Dashboard Variance
  • Lesson 3: Dynamic Dashboards
  • Lesson 4: Dashboard Interactivity

Need to train your team?

All of our sessions can be customized to meet your team’s specific needs. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

Performance Point 2010 Designing and Implementing Scorecards and Dashboards

3 Day
Classroom

$2,295.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now