Microsoft Office PerformancePointServer 2007 Technical Training

Code: 50141
Course duration: 4 days
Price:

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

Lessons

  • Microsoft BI stack integration
  • Roadmap

Module 2: Architecture

Lessons

  • Physical structure
  • Logical structure

Module 3: Application Basics

Lessons

  • Review of Admin Console

Module 4: Models and Dimensions

Lessons

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

Module 5: Data Integration

Lessons

  • Data Integration Flow
  • Data File Details

Module 6: Business Roles/Data Security

Lessons

  • Application Security
  • Model/Dimension Security

Module 7: Forms/Reports

Lessons

  • Overview
  • Building reports
  • Mapping reports

Module 8: Process Management

Lessons

  • Building Cycles/Assignments
  • Jobs

Module 9: Rules and Calculations

Lessons

  • Creating Rules and Calculations
  • Financial Intelligence

Module 10: Intro/Architecture/Requirements

Lessons

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

Module 11: Fundamentals

Lessons

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

Module 12: Elements

Lessons

  • 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

Lessons

  • 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

Lessons

  • 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:

Course Reviews

No reviews found for this course.

Be the first to write a review