The following is an excerpt from Business Intelligence with Microsoft PerformancePoint Server 2007, by Craig Utley. It is reprinted here with permission from McGraw-Hill; Copyright 2008. Read the book excerpt below to learn about analysis and planning with PerformancePoint Server 2007-- or download a free .pdf of the chapter to read later: "What is PerformancePoint Server 2007?."
PerformancePoint Server 2007 is a brand new project from Microsoft. However, in reality, it is three products in one, and only one of the products is truly new. PerformancePoint Server 2007 is a tool designed to support the cycle of monitoring the health of the organization, analyzing the organization's data at a detailed level, and planning for the future so that monitoring can continue as the future slides into the present and then the past.
PerformancePoint Server 2007 represents an attempt by Microsoft to bring together tools that provide companies with greatly enhanced business intelligence capabilities. Two of the pillars of PerformancePoint Server provide tools that support different types of users, such as analysts and business decision makers, while the third pillar moves beyond delivering data to the organization to supporting the planning, budgeting, and forecasting efforts of the organization. The budgeting and forecasting data can become part of the process, so that actual performance is compared to the forecasts and so that the health of the business can be monitored. Variances in performance from the plan can be easily analyzed in detail to determine the source of any variances.
What is PerformancePoint Server 2007?
Microsoft Office PerformancePoint Server 2007 is a concept with a bit of a split personality. First, it is both an application and a platform. In other words, it is an application that can be used as is, but it is also a platform because it can be extended and customized heavily. Second, there are three distinct areas of focus in the PerformancePoint Server: Monitoring, Analysis, and Planning. While there are three pillars, two of them are integrated to some degree, and in other ways, are the most separate. Monitoring and analysis are both integrated into a single tool, and in fact are both installed together, which means that they are tightly integrated; on the other hand, the analysis features in PerformancePoint Server 2007 are not as far along as originally planned, so Microsoft includes a license for a separate analytics application with the purchase of PerformancePoint Server. The planning piece of PerformancePoint uses a separate installation and a separate end-user tool from the monitoring and analysis pieces. There is little doubt that this product schizophrenia will be greatly reduced in future versions of PerformancePoint Server. For now, companies will still have access to the most powerful set of tools yet delivered to business intelligence to the organization.
Monitoring with PerformancePoint Server
PerformancePoint Server 2007 provides monitoring functionality that includes key performance indicators, scorecards, and dashboards. These dashboards are hosted in SharePoint, including either the free Windows SharePoint Services or the definitely not free Microsoft Office SharePoint Server. The monitoring functionality in PerformancePoint Server is the third iteration of technology from Microsoft, replacing Microsoft Office Business Scorecard Manager 2005. Key Performance Indicators, or KPIs, scorecards, and dashboards are covered in detail in Chapters 4 and 5 but are covered from a very high level here.
A rich-client application, Dashboard Designer, is the tool used to create KPIs, scorecards, and dashboards. A KPI is a metric that is tracked by the business to monitor the health of a particular piece of the business. For example, a company might track KPIs for sales, inventory turnover, employee head count, customer satisfaction, market share, employee training, and so forth. Rather than just being numbers, KPIs have the actual value (such as the actual sales), a target (the sales forecast), an indicator (how the actual value compares to the forecast or budget), and a trend that shows whether the KPI is trending up, trending down, or is flat.
Multiple KPIs are placed on a scorecard. A scorecard provides an overview, so in a single glance a person can see how the business or division is performing. The indicators are often graphical images such as colored circles, smiley faces, arrows, or the like, so that users can quickly grasp the meaning without having to concentrate on the numbers themselves. Aside from showing just the KPIs, a scorecard can show scores. A KPI has an actual and a target, and the better the actual compared to the target, the higher the score in most cases. This means that KPIs can be given scores and that these scores can roll up to higher level scores. This also means that different products, locations, or employees can be scored against each other for the purposes of ranking. This is no different from taking the range of grades over a semester for an entire class and ranking students based on their averages, but it provides an impartial way to rank what may be very different products or locations.
Dashboards are containers for one or more scorecards, possibly mixed with reports or other items. Dashboards may have filters that users can change to update one or more of the items on the page. For example, a filter for products would allow users to change from one product to another as well as update a scorecard and the two reports on the dashboard. Figure 2-1 shows an example of a dashboard hosting a scorecard and several reports, both as charts and grids.
One of the elements missing in the first version of the monitoring tool is the ability to click on a KPI and pass parameters to an existing application or report.
For example, imagine that a business was looking at the salary expense for a particular location and noticed a particularly low score, meaning that salaries were much higher than expected. A useful feature would allow the user to click on that KPI and then launch the company's time and attendance system, with the location and the time period being viewed automatically passed as parameters. This type of integration may be possible via customizations but it is not a functionality that is available out of the box in this first version of PerformancePoint Server.
The monitoring piece uses Dashboard Designer and works using a disconnected model. This is similar to how Visual Studio 2005 is used to create web applications. The developer can work locally on a development machine, even though the application will eventually run on a server. Visual Studio 2005 allows developers to create web applications on a development machine and test the application fully before deploying it to the server. Similarly, Dashboard Designer allows developers to work on the files on a local machine and preview them using Internet Information Server before deploying the dashboard to a server running SharePoint. This model will be examined in Chapter 5.
Analysis with PerformancePoint Server
In mid-2006, Microsoft purchased ProClarity Corporation. ProClarity was the creator of the most popular third-party analytics tool for Analysis Services (the most popular tool overall was Excel, but its analytics capabilities fell far short of ProClarity's.) ProClarity actually had several products, the primary two of which were the ProClarity Desktop Professional and the ProClarity Analytics Server. The Desktop Professional application was a Windows application while the Analytics Server was a web application that included a thin client analytics tool that mimicked almost all features of the Desktop Professional.
Soon after ProClarity's acquisition by Microsoft, PerformancePoint Server was announced as the answer to the question for what would happen to the ProClarity Products. PerformancePoint Server was presented as the blending of Business Scorecard Manager and ProClarity into one product, with the addition of a planning module.
In reality, the integration of the powerful analytics from the ProClarity platform did not happen as quickly as expected. The analytic features in PerformancePoint Server 2005 are good at what they do, but they are limited compared to a true analytic application. The analysis features that made it into PerformancePoint Server are wrapped up primarily in two reports: the Analytic Chart and the Analytic Grid. There are other ways of getting additional analysis but they rely on the Office Web Components, which require both an installation of components on the client machine and a client license. The Analytic Chart and Analytic Grid are very good at what they do, allowing users to drill down to explore additional data, as well as use filters to change some of the data, but they are basically limited to this functionality. End users cannot change the dimensions being examined in a report (for example, they can't replace products with customers on the rows). The Analytic Chart and Analytic Grid are mentioned in Chapter 5 and covered in more detail in Chapter 6. Figure 2-2 shows an example of the Analytic Chart and Analytic Grid reports.
In order to address the analytics shortfall in PerformancePoint Server, Microsoft is keeping the ProClarity product line alive for the time being. Customers who purchase a license of PerformancePoint server will also get a license for ProClarity. Customers interested in using PerformancePoint Server for analytics will almost certainly install and use the ProClarity Analytics Server, and Microsoft has added a report type in PerformancePoint Server that ties to a report, called a view in ProClarity Analytics Server.
The ProClarity tools represent true analytics applications, offering basically unlimited abilities to work with the data in Analysis Services cubes. The rich graphical capabilities of the ProClarity tools are unmatched by any other tool. The capabilities of Excel 2007 are arguably better at dealing with grid data, but the charts in ProClarity are extremely powerful and flexible.
A complete discussion of the ProClarity applications could be a book unto itself, but I discuss the basics of performing analysis with ProClarity in Chapter 6. Figure 2-3 shows an example of some of the graphical capabilities of ProClarity.
Planning with PerformancePoint Server
The planning functionality of PerformancePoint Server is completely new functionality from Microsoft. This module was developed from the ground up to meet the needs of business in performing their planning, budgeting, and forecasting.
While many examples mentioned in any BI book are financial in nature, monitoring and analytics are not necessarily focused on financials. The planning module, on the other hand, does focus on financials. As such, the primary tool for end users to work with the planning application is Excel. Another tool, called the Planning Business Modeler, will be used by some in the organization to create financial models representing the ways the organization handles its financials. Once these models are created, users will be able to use Excel to add and update data for forecasts.
One of the primary reasons for the creation of the planning module was to ease the burden of creating strategic plans, budgets, and sales forecasts. The planning module allows companies to import data from multiple, disparate systems, and consolidate that data in a central storage location. Models can then be built which encapsulate business logic and processes. Security plays a big part in the planning module, with users only allowed to see data they are granted permission to see.
All changes are tracked automatically in order to comply with laws requiring audit trails for financial information. Having a central store for data and business rules means that everyone in the business has a single source for data, which ensures accuracy and consistency. This is a great example of the "single version of the truth," which is a goal of all business intelligence. Figure 2-4 shows an example of the planning module in use.
The planning module also includes a workflow capability, so that changes made by users can go through an approval process before they are committed to the forecast or budget. This ensures that users can't make changes part way through the year that are designed to make them look better at the end of year. The planning module is covered in detail in Chapter 7.
PerformancePoint Server includes three primary applications: monitoring, analysis, and planning. Monitoring is a way of viewing the primary drivers of the business in a way that immediately communicates the health of the organization. This is accomplished through scorecards, which are a means for viewing data at a high level and getting an immediate sense for the strength or weakness of the various metrics.
The analysis functionality is covered by reports in PerformancePoint Server and analytics tools in the ProClarity applications. This use of multiple applications to achieve true analytics is necessary in this first release of PerformancePoint Server, but should be gone in future versions.
The planning module is designed to help organizations speed the process of budgeting and forecasting, while enforcing business rules across the enterprise. Security is an important component of the planning module, tracking all changes and ensuring that users only see data to that they have permissions to.
Overall, PerformancePoint Server 2007 provides a way for companies to monitor their business performance against plans, dive deep into data, and create new forecasts and plans easily. These plans can then be used in the monitoring process, and the circle is complete. The integration of these tools and the powerful dashboards that can be built make PerformancePoint Server 2007 a powerful tool for delivering business intelligence value to the organization.
More about Microsoft PerformancePoint Server 2007
- Download a free .pdf of this chapter: ""What is PerformancePoint Server 2007?
- Read another chapter from this book: "Business Intelligence with Microsoft PerformancePoint Server 2007"
- Microsoft Office PerformancePoint Server 2007 hits the street
- With PerformancePoint, Microsoft is content to play follow the leaders
- Read other excerpts from data management books in the Chapter Download Library