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:
- Completed the two-day, instructor-led M&A training or viewed the online course—available in October at http://www.microsoft.com/business/performancepoint/resources/training.aspx (modules 1 and 2 at a minimum)
- Completed the three-day, instructor-led Planning training or viewed of the online course—available in October at http://www.microsoft.com/business/performancepoint/resources/training.aspx (modules 1 and 2 at a minimum)
- UsingCore Features of Microsoft's Business Intelligence Products
- UsingAdvanced Features of Microsoft's Business Intelligence Products
- Introduction to Microsoft's Business Intelligence Products
- SQL Server 2005 Analysis Services