Microsoft Office PerformancePoint Server: Difference between revisions
Alexrexpvt (talk | contribs) →History: rm six year old unencyclopedic prediction that's now irrelevant |
Alexrexpvt (talk | contribs) →History: future → simple past (now discontinued); rm PR-speak; rm prediction |
||
| Line 24: | Line 24: | ||
Although the version 1 product was not officially released until November 2007, Microsoft had been offering [[Community Technology Preview]] releases since mid-2006. The acquisition of [[ProClarity Corporation]] in 2006 has enabled Microsoft to add deep analytics for reports created by its PerformancePoint Monitoring Server. |
Although the version 1 product was not officially released until November 2007, Microsoft had been offering [[Community Technology Preview]] releases since mid-2006. The acquisition of [[ProClarity Corporation]] in 2006 has enabled Microsoft to add deep analytics for reports created by its PerformancePoint Monitoring Server. |
||
Microsoft |
Microsoft discontinued PerformancePoint Server as an independent product and folded its Dashboard, Scorecard and Analytic Reporting capabilities into SharePoint Server, signaling a significant change in the company's business intelligence software strategy. The technology lived on as "PerformancePoint Services".<ref>{{cite web |url=http://www.informationweek.com/news/business_intelligence/analytics/showArticle.jhtml?articleID=212902915&subSection=Business+Intelligence |title=Microsoft Makes Sweeping Changes To BI Software Strategy |date=January 27, 2009 |last=Weier |first=Mary Hayes |work=[[InformationWeek]]}}</ref> |
||
==Monitoring Server Operation== |
==Monitoring Server Operation== |
||
Revision as of 08:54, 11 January 2013
 | This article contains content that is written like an advertisement. (November 2007) |
| Developer(s) | Microsoft |
|---|---|
| Initial release | November 2007 |
| Stable release | 1.0 SP2
/ 2008 |
| Operating system | Microsoft Windows |
| Type | Enterprise Performance Management |
| License | Proprietary EULA |
| Website | www.microsoft.com/business/performancepoint |
Microsoft Office PerformancePoint Server was a software product from Microsoft for the business intelligence sector. Development on PerformancePoint was discontinued in April 2009.[1] The dashboard, scorecard, and analytics components of PerformancePoint have been incorporated into Sharepoint Server 2010.
PerformancePoint Server 2007 integrated with other Microsoft Office products including Excel, Visio, SQL Server, and SharePoint Server. It was 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 provided a planning and budgeting component which was directly integrated with Excel and SQL Server Analysis Services. PerformancePoint gathered data from disjointed systems in order to keep overall accurate information. This includes the views of Project financials with Schedule performance with integration of EPM 'Dashboards' into the SharePoint-based PerformancePoint. Since PerformancePoint 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.
Microsoft is only one of a number of vendors in this emerging business intelligence market; others include: Panorama Software, MicroStrategy, Information Builders, Oracle, Business Objects (acquired by SAP in 2007), Hyperion (acquired by Oracle in 2007), Cognos (acquired by IBM in 2008), SAS, InetSoft, Informatica, QlikTech, Strategy Companion, Tableau Software, LogiXML and Pentaho.
History
Although the version 1 product was not officially released until November 2007, Microsoft had been offering Community Technology Preview releases since mid-2006. The acquisition of ProClarity Corporation in 2006 has enabled Microsoft to add deep analytics for reports created by its PerformancePoint Monitoring Server.
Microsoft discontinued PerformancePoint Server as an independent product and folded its Dashboard, Scorecard and Analytic Reporting capabilities into SharePoint Server, signaling a significant change in the company's business intelligence software strategy. The technology lived on as "PerformancePoint Services".[2]
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 represent the dashboard content are stored in a document library and can be viewed 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.
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 fourth component of PPS (Planning, Monitoring and Analysis being the first three). 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 of other repositories.
References
- ^ [1][dead link]
- ^ Weier, Mary Hayes (January 27, 2009). "Microsoft Makes Sweeping Changes To BI Software Strategy". InformationWeek.
External links
- How to Use/Configure Performance Point service on SharePoint 2010 [2]
- The official Microsoft Office PerformancePoint Server 2007 Web site [3]
- Help for PerformancePoint Server 2007 [4]
- PerformancePoint Server 2007 Developer Portal [5]
- Microsoft Office PerformancePoint Server 2007 and Integrated Business Planning [6][dead link]
- ITWorx Government Performance Management [7][dead link]
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]
