Microsoft Office PerformancePointServer 2007 Technical Training

Code: 50141
Course duration: 4 days

50141: Microsoft Office PerformancePointServer 2007 Technical Training (4 days)

About this Course

This four-day, instructor-led workshop provides students with the knowledge and skills to architect and build Business Intelligence (BI) solutions by using Microsoft Office PerformancePoint Server 2007. This session covers both Monitoring and Analytics and Planning. Through extensive hands-on exercises, participants will build on their base knowledge.

Audience Profile

This course is intended for experienced technical and solution architects PLUS training partners who have experience with the following technologies:

  • Microsoft Office Business Scorecard Manager 2005; OR
  • ProClarity Analytics Server; AND
  • Microsoft SQL Server Analysis Services 2000/2005

Also important is some practical experience with Microsoft Office PerformancePoint Server (CTP) releases as well as solid knowledge of Financial Management processes such as Planning, Budgeting, and Financial Reporting.

At Course Completion

After completing this course, students will be able to:

  • Describe PerformancePoint Server architecture.
  • Recognize where PerformancePoint Solutions fit into the Microsoft BI Solution stack.
  • Create end-to-end planning applications.
  • Create end-to-end M&A applications.
  • Integrate PPS applications with other BI technologies.

Course Outline

Module 1: Product Vision


  • Microsoft BI stack integration
  • Roadmap

Module 2: Architecture


  • Physical structure
  • Logical structure

Module 3: Application Basics


  • Review of Admin Console

Module 4: Models and Dimensions


  • Building Dimensional structure
  • Adding Member set/views
  • Model fundamentals

Module 5: Data Integration


  • Data Integration Flow
  • Data File Details

Module 6: Business Roles/Data Security


  • Application Security
  • Model/Dimension Security

Module 7: Forms/Reports


  • Overview
  • Building reports
  • Mapping reports

Module 8: Process Management


  • Building Cycles/Assignments
  • Jobs

Module 9: Rules and Calculations


  • Creating Rules and Calculations
  • Financial Intelligence

Module 10: Intro/Architecture/Requirements


  • Show the end result—scorecards/dashboards already exported to SharePoint
  • Roadmap Review, Review architecture, Review System Requirements
  • Scorecard Central

Module 11: Fundamentals


  • What’s New—wizards, additional data sources creation
  • SSAS, SS DB, Microsoft Office Excel, Publish
  • Create own connector

Module 12: Elements


  • Scorecard/KPI Creation
  • What’s New—wizards, indicators auto-added, KPIs auto-added, and linked
  • SSAS, SS DB, Excel Examples
  • KPI Banding
  • Modifying/Adding indicators
  • Scorecard KPI Weighting
  • Adding additional actuals/targets
  • Report views (create, navigate, parameterize)

Module 13: Dashboards


  • Creation
  • Parameter Creation
  • Add Param to dashboard zone
  • Connect params up to scorecard views and report views
  • Show conditional view display options (associated views with KPIs)
  • Publish

Module 14: Security


  • App Pool User Identity
  • Connection per user
  • Server roles
  • Security on objects

Before attending this course, students must have:

  • Technical experience with architecting BI solutions by using Microsoft SQL Server Analysis Server 2000 and 2005
  • Experience building Data Warehouses
  • Experience building Cubes
  • Experience building scorecards and dashboards
  • Financial accounting experience
  • Experience with Microsoft Windows SharePoint Services and MOSS
  • Experience with the ProClarity Analytics product line

Completed the following on-line courses:

Guaranteed to Run

2018-03-19 09:00 to 2018-03-23 17:00
Attend Online
2018-03-19 09:00 to 2018-03-24 17:00
NYC-23rd Street (Virtual Instructor-Led)
2018-03-19 09:00 to 2018-03-24 17:00
Mid-Town New York City (Virtual Instructor-Led)
2018-03-14 09:00 to 2018-03-16 17:00
Fort Lauderdale, Florida (Virtual Instructor-Led)
2018-03-07 09:00 to 2018-03-09 17:00
Fort Lauderdale, Florida (Virtual Instructor-Led)
2018-03-07 09:00 to 2018-03-09 17:00
Northern New Jersey (Virtual Instructor-Led)

Course Reviews

No reviews found for this course.

Be the first to write a review