Performance Point Server 2007 and Business Intelligence

Course #	PPI
Course Dates	Request a Date
Course Description	This 3-day instructor-led course provides students with the knowledge and skills to implement Microsoft Performance Point Server 2007 and understand the role of Performance Point in the Microsoft Business Intelligence Stack. The course introduces the students to SQL 2008 Analysis Services, Integration Services, Reporting Services, Report Builder 2.0, SharePoint 2007 Integration, Performance Point Monitoring, Performance Point Analytics and Performance Point Planning.
Course Categories	Microsoft, Business Intelligence , SharePoint, SharePoint 2007
Course Schedule Info	3 days, 8:30 - 4:30
Course Objectives	Describe the Microsoft Business Intelligence stack Create a Data Mart using Business Intelligence Studio Create Integration Services project and load a Data Mart Model Dimensions, Measures and Cubes Create a Report using Report Builder 2.0 Load and Manage Reports with SharePoint Understand and Create a Shared Service Provider in SharePoint Design Dashboards for Executives Design Operational Dashboards Design Strategy Maps Design and implement Business rules Work with the Performance Point Suite of tools Implement a Monitoring Analysis and Planning Structure With Performance Point Secure the Structures
Who Should Attend?	This course is intended for Business Managers, Project Managers, Team Leads, DBAs, Developers and Business Intelligence Professionals seeking an understanding of Performance Point Server its architecture, supporting structures, implementation and design.
Course Prerequisites	Before attending this course, students should have: . A working knowledge of RDBMS . A working knowledge of Business Intelligence Studio . A working knowledge of Excel and the Office Ribbon . Understanding of the goals of Business Intelligence
Course Length	3 days
Course Cost	$1,350.00
Associated Exam Number	There is no exam associated with this course
Detailed Course Module	Module 1 Overview of the Microsoft Business Intelligence Stack SQL Server 2008 SQL Server Integration Services SQL Server Analysis Services SQL Server Reporting Services SharePoint 2007 Integration Report Center Excel Services Excel Calculation Services Excel Web Services Performance Point Server Lab 1: Microsoft Business Intelligence Stack Create A SharePoint Report Center Create A Shared Service Provider Module 2 SQL Server Integration Services Business Intelligence Development Studio Overview of SSIS Business Intelligence Components Extract Transform Load Extract from multiple sources Transforming Data Load Process Lab 2: Stack SQL Server Integration services Create A SSIS Package Extract Transform Load Module 3 SQL Server Analysis Server Cubes Facts and Dimensions Schemas Calculated Members MDX Lab 3 SQL Server Analysis Server Create A SSAS Package Cubes Dimensions Partitions Calculated Members Deploy and Browse Module 4 SharePoint. Excel and Performance Point Data Connections Configuration Publishing to Excel Services SharePoint KPI Lists Lab 4 SharePoint. Excel and Performance Point Create a Trusted Location Create a Data Connection Publish an Excel Workbook Module 5 Performance Point Server Overview Management Strategy Monitoring Analyze Planning Performance Point Server Fundamentals Personal BI Team BI Enterprise BI Architecture Module 6 Performance Point Monitoring and Analyzing Key Elements Data Sources Indicators Indentifying Key KPIs Lab 6 Performance Point Monitoring and Analyzing Add Indicators Add KPI’s from Multiple Sources Module 7 Balanced Scorecards Designing Strategy Map Selecting Metrics Setting Targets Deploying Lab 7 Balanced Scorecards Design A Strategy Map Select Metrics for the Map Set Targets Deploy the Map Module 8 Reports Types End Points Report Definition Language Report Builder 2.0 Publishing to SharePoint Subscriptions Using Web Parts Lab 8 Reports Create a Report in BIDS Create a Report Model Create a Report in Report Builder 2.0 Deploy Reports Expose Reports in a Web Part Create a Subscription Module 9 Dashboards Creating Executive Dashboards Creating Operational Dashboard Rules of Design Graphical Elements Layout Filters Links Deploying to SharePoint Lab 9 Dashboards Create an Executive Dashboard Create an Operational Dashboard Deploy Module 10 Performance Point Planning Installation of the Planning Tools Installing Planning Business Modeler Planning Administrative Console Configuration Creating Model Sites Lab 10 Performance Point Planning Create A Model Site Create a Sub site Module 11 Business Models Building a Business Model Models Workspace Tasks and Actions Models Sub sites Integrating Business Data Lab 11 Business Models Create a Model Workspace Use Tasks and Actions Create a Sub Site Integrate Business Data Module 12 Business Rules Module 4 SharePoint. Excel and Performance Point Understanding Business rules in Performance Point Server PP Expression Language Applying Business Logic to Models Validating Rules Deploying Rules Lab 12 Business Rules Use Performance Point Expression Language Implement Business Logic Validate Rules Deploy Rules Module 13 Security Role Based Security Data Source Security SharePoint Security Securable Items Trimmed views Security Infrastructure Extending Web Applications Active Directory Integration Securing Business Models Lab 13 Security Explore the Security Model
Course Attachment	N/A

Return to the main courses page...