CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

ATPPS07 - PerformancePoint Server 2007

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

This three day course is a instructor-led tour of Microsoft PerformancePoint Server 2007. The purpose of the course is to provide students with general and detailed information on the architecture and utilization of PerformancePoint Server to monitor and analyze key business metrics as well as plan and model business metrics.

Click here for a printer-friendly version of this page

Prerequisites

During the three days of class through lecture and hands-on exercises students will be familiarized with a comprehensive view of PerformancePoint system architecture and learn how to build business models and monitor and analyze key business metrics with PerformancePoint dashboards and scorecards.
Students should have previously taken LRS-SSAS or meet the following prerequisites:

Familiarity with the Microsoft Windows operating system

Familiarity with Microsoft Excel

Have a comprehensive understanding of Microsoft SQL Server 2005 and multi-dimensional data structures and OLAP principals

Detailed Class Syllabus

Chapter 1. The Case for Business Intelligence
What is Business Intelligence?

The Consumers of Business Intelligence

Business Decision Makers

Knowledge Workers

Analysts

Line Workers

Chapter 2. Introducing PerformancePoint Server 2007
What is PerformancePoint Server 2007

Monitoring with PerformancePoint Server

Analysis with PerformancePoint Server

Planning with PerformancePoint Server

Chapter 3. Data Warehousing and Business Intelligence
Designing to Solve the Problem

Dimensions and Dimension Tables

Fact Tables

Extracting, Transforming and Loading Data

ETL Using SQL Server Integration Services

Data Quality

Building Cubes

Steps to Cube Design

Cube Deployment and Processing

Delivering Data to Consumers

Chapter 4. Scorecards and Key Performance Indicators
Key Performance Indicators

KPIs and Measures

Deciding What KPIs to Track

Example KPIs

Scorecards and Dashboards

Balanced Scorecards

Business Scorecards

Strategy Maps

Chapter 5. Monitoring in PerformancePoint Server
Data Sources and Scorecards

Creating Data Sources

Creating a Scorecard

Creating and Modifying KPIs

KPIs with Multiple Targets

Adding Multiple KPIs at Once

Working with Objectives

Aggregations and Trends

Indicators

Reports and Strategy Maps

Creating an Analytic Chart Report

Creating a Trend Analysis Report

Strategy Maps

Dashboards – Putting it All Together

Creating a Dashboard

Adding Filters to the Dashboard

Chapter 6. Analysis with PerformancePoint Server and ProClarity
Analysis with PerformancePoint Server

Analytic Charts

Analytic Grids

Analysis with ProClarity

The ProClarity Professional Client

The ProClarity Standard Client

Chapter 7. Planning Module in PerformancePoint Server
Planning Administration Console
Planning Business Modeler

Dimensions

Models

Forms and Reports

Process Management

Security and Roles

Associations

PerformancePoint Add-in for Excel

Creating Reports and Forms

Submitting Plan Data

Chapter 8. PerformancePoint Deployment and Security
Deploying PerformancePoint Server

Installing the Monitoring Server

Installing the Planning Server

Security Considerations for PerformancePoint Server

Internet Information Services Security

Secure Sockets Layer

Kerberos and Delegation

Chapter 9. Analysis with Excel 2007
Performing Analysis with Excel 2007

Using the PivotTable

Using the PivotChart

Chapter 10. SQL Server Reporting Services

Creating Reports with Reporting Services

Accessing Cubes with Reporting Services

Accessing Relational Data