In this module, students will learn about PerformancePoint Server 2007 role in Microsoft’s Business Intelligence stack.
- Microsoft BI stack integration
- PerformancePoint architecture
- Review PerformancePoint components
- System requirements and deployment topologies
This module will focus on Excel services components introduced in SharePoint 2007. Excel services allows centralized storage and publishing using SharePoint.
- Excel Services architecture
- Configuring Excel Services
- Working with Excel Web Access
- Extending Excel Services
This module will cover key aspects involved in developing business solutions using PerformancePoint Sever 2007. Students will learn about connecting to a variety of data sources using Dashboard Designer.
- Overview of Dashboard Designer
- Dashboard Designer features and development process
- Configure and deploy Analysis Services Data source
- Configure and deploy Excel Services, Excel Data source
- Working with Time Intelligence
Key Performance Indicators (KPIs) are very helpful in measuring business objectives. When used in scorecards, corporate executives can check the health of the organization at a glance. In this module, students will learn how to build KPI from various sources, use indicators to visually display status. Using the KPI and indicators, students will build scorecards.
- Building KPI from various data sources like Analysis Services or Excel Services
- Understanding the metrics and creating new metrics
- KPI banding
- Building custom indicators
- Using Objectives to group related KPI
- Building scorecard using KPIs , indicators and objectives
Reporting services is a key component of the Microsoft BI stack for delivering enterprise level BI solutions. Integration of reporting services with SharePoint 2007 leverages the SharePoint framework. This module will delve into various aspects of Reporting Services from installation to delivering reports.
- Reporting Services architecture
- Reporting Services and SharePoint integration
- Building report models for business users
- Using report models to author reports and integrate with SharePoint
- Advanced configuration options for reports
This module will focus on building reports from various data sources such as Excel Services, Reporting Services and other data sources as dashboard report elements.
- Overview of report types
- Building and deploying report using Excel Services
- Building analytical reports using analytics grid and analytics chart reports
- Building reports using Excel Services, Reporting Services.
Students will learn how to build PerformancePoint Server 2007 dashboards and how to integrate various elements like reports and scorecards to deliver business solutions using SharePoint 2007.
- Building dashboards
- Working with zones and zone settings
- Building filters
- Connecting various dashboard elements like scorecards, reports and filters
- Publishing dashboards to SharePoint
This section will cover an overview of security with different implementation scenarios that affect dashboard rendering to business users.
- Security overview
- User identity
- Connection per user
- Server roles
- Object security
Students will work with the ProClarity suite of components to deliver solutions based on cubes created with Microsoft Analysis Services.
- Overview of ProClarity and various components
- Integration with PerformacePoint
- ProClarity Analytical Server installation
In this module students will learn how to use ProClarity Professional as an authoring tool to build reports connecting to cube and publish their reports to ProClarity Server.
- Overview of ProClarity Professional
- Navigation
- Connecting to the cube and viewing data
- Building and publishing views
- Customizing views by creating members, sets, measures
This module will cover building proClarity report using PerformancePoint Dashboard designer and integrating with other performancePoint elements on the dashboard.
- Building PerformancePoint reports using ProClarity published book
- Integrating the report on the dashboard with other elements
- Publishing report to SharePoint