Microsoft Office PerformancePoint Server 2007

Microsoft Office PerformancePoint Server 2007 - one of the tools of the Microsoft Business Intelligence platform allowing the companies to optimize performance thanks to implementation of monitoring, the analysis and planning of a business activity using single integrated solution.

Automation of process of approval of data is necessary not only for ensuring input of correct data, but also for observance of fixed terms and responsible persons for accomplishment of a task. Process of approval of data according to all regulations allows to run Microsoft Office application of PerformancePoint Server 2007.

The distributed solution for preparation of budgets, planning and forecasting. The client place of the end user is usual Excel with special expansion which allows:

• be connected to a remote server,
• enter data only into the cells permitted for this user,
• save data on the server,
• transfer the prepared budget to the removed controller to check,
• build reports for display of the data permitted on the server,
• the offline mode allows to continue work without having connection to Network.

For the organization of your individual planning process in a set the special PerformancePoint Planning Business Modeler program which allows is delivered:

• to be connected far off to the server,
• define any analysts,
• set any hierarchies the analyst,
• define different quantity of models,
• create any transformation rules and consolidations of data,
• define roles of users, manage data access up to a cell,
• manage data preparation process,
• define rules of integration with other information systems.

Microsoft Office PerformancePoint Server 2007 has the preset logic which can be used in your purposes, without being engaged in creation of the solution "from scratch".

Technically, Microsoft Office PerformancePoint Server 2007 relies on SQL Server of 2005 (SP2 above) and services Analysis Services, Integration Services and Reporting Services that simplifies integration with any systems, and allows to publish easily any analytical reports on the web portal.

Microsoft Office PerformancePoint Server 2007 is the single integrated solution allowing the companies to control efficiency of business processes and more reasonably to accept business solutions thanks to powerful tools of monitoring, the analysis and planning of a business activity.

Microsoft Office PerformancePoint Server 2007 makes available the modern tools which are an integral part of BPM (Business performance management):

• Balanced scorecards (Balanced ScoreCard, KPI),
• Analytical dashboards (Dashboards),
• Means of financial and operational planning,
• Simulars
• Multidimensional data analysis (OLAP)
• Construction tools of the consolidated corporate financial statements for the companies with complex structure of property and management
• Integration tools with different sources are given

Microsoft Office PerformancePoint Server 2007 will help you to estimate after determination of strategic objectives efficiency of the activity in relation to these purposes and to manage process of achievement of goals.

The employees of most departments covering practically all business functions of the company can be users of the application: management, finance, marketing, sales, HR.

Monitoring, corporate financial and management reporting

Capability monitor changes, problems and opportunities in real time is a key component of conducting successful business.

Fig. 1. Monitoring panel (plan fact)

Microsoft Office PerformancePoint Server 2007 provides means of new generation of Business Performance Management for determination of key performance indicators (KPI) and creation of the balanced scorecard (Balanced ScoreCard). Powerful tools of visualization, a user-friendly interface and a working environment of Microsoft Office applications well familiar to all give the chance to users of Microsoft Office PerformancePoint Server 2007 easily and to quickly build, personalize and use the systems of indicators for business performance monitoring.

The built-in rules of consolidation allow to prepare corporate financial statements according to structure of property and management. Rules of reconciliation and an exception of the internal turnovers considerably accelerate process of creation of the consolidated corporate reporting.

Means of multidimensional data analysis give ample opportunities for obtaining managerial reports in any cuts.

Analysis. Business users, as a rule, rely on IT experts regarding providing data business - analytics (BI) which are required for them for decision making.

Interactive visualization tools and analysts of Microsoft Office PerformancePoint Server 2007 allow to detect optimal methods of a research of data without involvement of IT services, to analyze and exchange data, operating with business terms in the intuitive environment.

Fig. 2. Decomposition tree.

Multifunction analytical means of Microsoft Office PerformancePoint Server 2007 will help users to define quickly the trends, favorable opportunities and even threats hidden after large volumes of data.

Planning, budgeting

Planning of Microsoft Office PerformancePoint Server 2007 is based on analytical models for each business area with precise measurement of resources and results. The assumptions and business objectives are an integral part of a system. The analysis "That-if" allows to define possible alternatives and the best options.

The planning cycle includes in Microsoft Office PerformancePoint Server 2007 stages of input, check, the approval of data. Notifications on start of the next stage of planning come to responsibles by e-mail. Information input happens in the MS Excel environment, usual for all.

Superstructure of PerformancePoint Server 2007 for Excel

Fig. 3. A superstructure of PerformancePoint Server 2007 for Excel

Process performance of planning and budgeting in Microsoft Office PerformancePoint Server 2007 is reached thanks to:

• To the safe, integrated server platform for access to data sources, containing key information for decision support and drawing up business models.
• To simple applications in use for creation of models and testing of scenarios. Entry forms, mechanisms of calculations of business rules, means of check of hypotheses appear in a familiar environment of the MS Office environment.
• To the means of communications and joint work of users allowing to optimize a budget making cycle from import of commodity reference books before receiving mailing about risk of non-compliance with the budget.

The question of effective planning and budgeting for the enterprise has high relevance now. However many heads of the companies are rather afraid of new products as their implementation can demand a large number of time and money.

Microsoft Office PerformancePoint Server gives an opportunity to carry out planning and budgeting, at the same time all components for implementation of the analysis is directly integrated from the MS Excel and SQL Servers Analysis Services usual already for all employees of the company. Functionality of a product allows to integrate data from the separate systems into a common information space.

Planning process in MS PerformancePoint Server is performed using Planning Administration Console (the planning administration console) and Planning Business Modeler (the application for business planning modeling).

The system of input and approval of data is most relevant for the enterprises with a difficult hierarchical management system and control which part the set of divisions and branches is. Microsoft Office PerformancePoint Server 2007 is the application which allows to automate data entry process, to provide operational approval according to structure of the organization, guaranteeing at the same time reliable storage and security of information.

For ensuring differentiation of access rights on a read and write of data business roles are created.

The information access is limited using inline tunings for a business role, as well as for specific users. Using ample opportunities of setup of the Microsoft Office PerformancePoint Server 2007 tools it is possible to grant to a user group the rights only to reading in a certain model.

Visually the BI Expert company tells about process of approval

External links

• It is possible to learn about process of approval of data with the help of Microsoft Office PerformancePoint Server 2007 here in more detail