Jump to content

Microsoft Office PerformancePoint Server

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by 38.117.185.138 (talk) at 14:40, 23 June 2010. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Microsoft Office PerformancePoint Server
Developer(s)Microsoft
Stable release
1.0 SP2 / 2008
Operating systemMicrosoft Windows
TypeEnterprise Performance Management
LicenseProprietary EULA
Website[1]

Microsoft Office PerformancePoint Server was a software product from Microsoft for the business intelligence sector. Version 1.0 was released in November 2007. Development on PerformancePoint was discontinued in April 2009 [1] Like most Microsoft products, PerformancePoint Server 2007 is fully integrated with other Microsoft Office products including Excel, Visio, SQL Server, and SharePoint Server. It is also the successor to the scorecard capabilities of Microsoft Office Business Scorecard Manager and the monitoring and analytic capabilities of recently acquired ProClarity. PerformancePoint Server also provides a planning and budgeting component which is directly integrated with Microsoft Excel and SQL Server Analysis Services. This integration now allows Performance point to join the dis-jointed systems companys use today inorder to keep information accurate within all of their systems. This would include the views of Project financials with Schedule performance with integration of EPM 'Dashboards' into the SharePoint based Performance Point. Since Performance Point uses 'data cubes' to manage the information being collected you can make connections into existing cubes or schedule data transfers from existing backoffice systems into these data cubes to easily represent the same information within more advanced and informative 'Value' added dashboards

As of 2007, Business intelligence (BI), also known as Business performance management (BPM) or Corporate performance management (CPM) is a rapidly growing market owing to the ever-increasing amount of data collected by businesses about their customers. Wal-Mart, for example, has collected over 460 Terabytes of data about its customers' buying habits, according to a New York Times article in 2004.[2] Enabling companies to make sense of that level of data collection is the key benefit of datamining and the development of data farms and data cubes (almost all BI systems use datacubes in some way to produce a mix of quantifiable but disjointed information to produce a more qualitative view of the current environment, not just history). Microsoft isn't the only player in this emergent market though, other include: Analance, MicroStrategy, Information Builders,Oracle, Business Objects, Hyperion, Cognos, SAS, Ab-initio, Informatica and Pentaho.

History

Although this version 1.0 product was not officially released until November 2007, Microsoft has been offering Community Technology Preview releases since mid-2006. A recent analysis by Gartner, Inc. [3]predicts that interest will be strongest among companies that are looking to move up from Microsoft's earlier BI offerings including Excel and SQL Server, which were not quite feature-rich enough to allow Microsoft to compete with the other enterprise-level vendors in this market segment. The acquisition of ProClarity Corporation in 2006 has enabled Microsoft to add deep analytics for reports created by its PerformancePoint Monitoring Server.

The planning component of PerformancePoint Server 2007 is to be discontinued April 1, 2009.

Microsoft will discontinue PerformancePoint Server as an independent product and is folding its Dashboard, Scorecard and Analytic Reporting capabilities into SharePoint Server, signaling a significant change in the company's business intelligence software strategy. The technology will live on as PerformancePoint Services and is projected to be very disruptive in the marketplace Source: [2]

The Monitoring Server Operation

The Monitoring and Analytics features, which include Dashboards, Scorecards, KPIs (Key Performance Indicators), Reports, Filters, and Strategy Maps, are delivered via a Monitoring Server, which includes two client user interfaces: Dashboard Designer and SharePoint Web Parts. Dashboard Designer is downloaded from Monitoring Server, and enables business analysts or IT Administrators to:

  • create data source connections
  • create views that use those data connections
  • assemble the views in a dashboard
  • deploy the dashboard to Microsoft Office SharePoint Server 2007 or Windows SharePoint Services.

Dashboard Designer saves content and security information to a SQL Server 2005 database that is managed through Monitoring Server. Data source connections, such as OLAP cubes or relational tables, are also made through Monitoring Server. Reports based on these data source connections are run and updated through Monitoring Server, however some reports, such as PivotTables and PivotCharts, have independent connections to their source data (queries for these reports are not processed by Monitoring Server.)

After a dashboard has been published to the Monitoring System Database, it can be deployed to Microsoft Office SharePoint Server 2007 or Windows SharePoint Services. HTML pages that represents the dashboard content are stored in a document library and can be opened in a browser. When dashboards are opened in a browser, Monitoring Server updates the data in the views by connecting back to the original data source and retrieving the most current data.

PerformancePoint Monitoring Server comes with an API that allows developers to add extensions to the Dashboard Designer, such as custom reports, custom data source providers, custom wizards, and user interface extensions.

The Planning Server Operation

The PerformancePoint Planning Server supports a variety of management processes, which include the ability to define, modify, and maintain logical business models integrated with business rules, workflows, and enterprise data.

Additionally, through its support of Generally Accepted Accounting Principles (GAAP), Planning Server enables business users to publish live reports from Excel to SQL Server 2005 Reporting Services and SharePoint Services.

Planning Server is built on a SQL Server stack, with extensive use of Excel for line-of-business reporting and analysis.

Management Reporter

Management Reporter is the 4th component of PPS, Planning, Monitoring and Analysis being the first 3. This component is specifically designed to perform Financial Reporting and can read the PPS Planning Financial Models directly. A development kit is also available to allow this component to report off other repositories.

References

  1. ^ http://www.directionsonmicrosoft.com/news-a-analysis/45-february-2009/373-performancepoint-server-discontinued.html
  2. ^ The New York Times > Business > Your Money > What Wal-Mart Knows About Customers' Habits
  3. ^ The Impact of Microsoft Office PerformancePoint Server 2007 in CPM

Blogs about PerformancePoint Server 2007

  • Data Puzzle [8]
  • Intelligent Insight on PerformancePoint [9]
  • PerformancePoint Insider [10]
  • The Microsoft PerformancePoint Team Blog [11]
  • The Adatis PerformancePoint Team Blog [12]
  • PerformancePointing [13]
  • PerformancePoint Consulting [14]


Retrieved from "https://en.wikipedia.org/w/index.php?title=Microsoft_Office_PerformancePoint_Server&oldid=369743648"