Course 50465-B: PerformancePoint 2010 Designing and Implementing Scorecards and Dashboards

Course Modality

Instructor-led training

Course Level

Intermediate

Course Time

3 Days

Course Language

English

Course Overview

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 must have:

An understanding of the benefits of business intelligence.

Intended Audience

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.

Job role: Developer

Features: none

Find a learning partner

Why The DataTech Labs ?

Self-Paced Online Video

A 360-degree learning approach that you can adapt to your learning style

A 360-degree learning

Engage and learn more with these live and highly-interactive classes alongside your peers

24/7 Teaching Assistance

24/7 Teaching Assistance Keep engaged with integrated teaching

Online Practice Labs

Projects provide you with sample work to show prospective employers.

Applied Projects

Real-world projects relevant to what you’re learning throughout the program

Learner Social Forums

A support team focused on helping you succeed alongside a peer community

Skill Covered

After completing this course, students will be able to:

Discover, design and implement KPIs
Understand the scoring methodologies used with indicators to change visual displays
Decide on how to modify a scoring methodology
Understand the role of SQL Server Analysis Services in measurement
Be able to develop proper filters for easy end-user click to detail on dashboards
Group Scorecards into Dashboards and link them together

Modify the web page hosting the Dashboards for branding
Implement Master Pages in Dashboards for consistency with company standards
Develop multiple-valued KPIs. For example This year Actual and Target and last Year Actual and Target at the same relative point in time
Implement Time Intelligence features to query such as Year-To-Date, Last 6 Months etc.
Use Excel Services and Excel Workbooks in Scorecards or as a data source
Utilize the document management capabilities of SharePoint 2010 for PerformancePoint objects for versioning, document retention and reverting
Understand team development methodologies with developing PerformancePoint to reuse existing objects or to segment projects
Use workflows to approve scorecards and dashboards
Develop Filters for Scorecards
Use Dashboard Designer
Work with views of SSAS Cubes to model data for proof of concept for KPIs
Connect into Data Sources via data Connections
Gain a generalized understanding of MDX to write basic queries
Generate Visual Reports and tie them into Dashboards
Utilize decomposition trees
Understand what the advantages of having SharePoint as the platform are
Use dynamic hierarchies in Scorecards
Secure all PerformancePoint objects
Implement User Menus in Scorecards

Get In Touch

Course Curriculum

Module 1

The Business Intelligence Stack

Lessons

SQL 2008R2 Business Intelligence Platform
SQL Analysis Services
SQL Reporting Services
Performance Management Tools
SharePoint 2010
Multidimensional Space
MDX
Data Mining
Understanding the Terminology

Lab : The Business Intelligence Stack

Module 2

PerformancePoint Services 2010

Lessons

Lab : PerformancePoint Services 2010

Module 3

Dashboards and Scorecards Overview

Lessons

What is a Dashboard?
What is a Scorecard?
Scorecards in PPS
KPI Collections
Dashboard Design Guidelines
Dashboards designed to Monitor
Dashboards designed to Analyze
Dashboards designed as Management views such as Six Sigma

Lab : Dashboards and Scorecards Overview

Module 4

MDX (Optional Module)

Lessons

Lab : MDX (Optional Module)

Module 5

Dashboard Designer

Lessons

Lab : Dashboard Designer

Module 6

Data Connections

Lessons

Lab : Data Connections

Module 7

Visual Indicators and Key Performance Indicators

Lessons

Lab : Visual Indicators and Key Performance Indicators

Module 8

Visual Reports and Filters

Lessons

Lab : Visual Reports and Filters

Module 9

Scorecards

Lessons

Lab : Scorecards

Module 10

Dashboard Details

Lessons

Dashboard Hierarchy
Dashboard Variance
Dynamic Dashboards
Dashboard Interactivity

Lab : Dashboard Details

Reviews

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.