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.
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 M&A applications
• Integrate PPS applications with other BI technologies
• Sit the Microsoft Exam 70-556: TS: Microsoft Office PerformancePoint Server 2007, Applications
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
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.
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 online PP002 course: Planning Series I in Microsoft Office PerformancePoint Server 2007
• Completed the online 6840: course Designing Microsoft Office PerformancePoint Monitoring Server 2007
• Using Core Features of Microsoft's Business Intelligence Products
• Using Advanced Features of Microsoft's Business Intelligence Products
• Introduction to Microsoft's Business Intelligence Products
• SQL Server 2005 Analysis Services
