Home > Articles

SharePoint 2010 PerformancePoint: Integrated Performance

This chapter introduces business intelligence (BI) as a discipline and discusses how business management and performance management strategies work hand in hand in BI solutions. With this knowledge you can start exploring how PPS can help you build a BI solution.
This chapter is from the book

This chapter introduces business intelligence (BI) as a discipline and discusses how business management and performance management strategies work hand in hand in BI solutions. You learn about the different decision types that occur across all levels of an organization and how BI products have evolved to their present capacity in which they can enable business decisions across all levels of an organization.

Business Intelligence as a Discipline

In any organization, decisions happen daily at every level, from the person working at the front desk to the most senior executive in the corner office. And for every person in an organization, making sound and timely decisions depends on access to good and reliable information. At its best, BI exists where decisions and information converge (see Figure 1.1).

Figure 1.1

Figure 1.1 Fundamentally, business intelligence is about decisions and information.

The type of information needed for a decision varies depending on the decision required. The decisions themselves vary depending on who is making the decision, how much time there is to make the decision, and how much of an impact the decision may have on the organization as a whole. There are three different decision types referred to in the BI world:

  • Strategic
  • Tactical
  • Operational

Strategic decisions are typically made by senior management and generally impact the company as a whole. Only a few of these decisions are made during the year, and they often involve long-range planning from 1 to 3 years at the executive level. Strategic decisions might be centered on questions such as the following:

  • Should we start a new product line?
  • Should we open regional offices in Europe or the Middle East?
  • Should we close our plants in the Midwest?

Tactical decisions are usually made more often than strategic decisions and have less of an impact on the company as a whole. They involve planning on a quarterly or semi-annual basis and might be centered on questions such as the following:

  • How can we adjust the budget for the Chicago office to meet projections this quarter?
  • Do we need to increase our sales staff for the upcoming holiday season this year?
  • How can we increase production in the overseas plant to meet demand next quarter?

Operational decisions are made most often, and on a daily basis, by all types of employees, at all the various levels in the organization. These are like the decisions that keep the assembly plant running every shift and might be centered on questions such as the following:

  • Do we need to add a team to the night shift to pack the orders that need to go out tomorrow morning?
  • Who is available to replace Jane on her shift tonight?
  • Do we need to change the supplier for our store?

Consider an example based on the case study of an organization called Apples and Oranges Productions detailed in Chapter 3, "Case Study: Managing What You Measure." The executive team of Apples and Oranges Productions, a fictitious production company with TV and film divisions, decides to grow the organization. Strategic questions might be centered on the following:

  • How can we grow our organization?
  • Which division is best positioned for growth?

The executive team decides to grow the organization by expanding into new markets and that compared to the Film division, the TV division is best positioned right now for this expansion. The decision to expand the TV division into new markets is an example of a decision taken at the highest level of the organization that will impact the company as a whole and will be evaluated and implemented over the long term. The executive team arrived at this decision by looking at industry performance, overall company revenue, and overall strengths and weaknesses. The decision defines a direction for Apples and Oranges for the next 2 years and will have an impact on the company as a whole as resources, financial and human, are turned toward realizing the goal of expanding the TV division into new markets.

Following up on this strategic direction, the management team of the TV division looks at what they need to do to realize this strategic goal. At this level, the TV division makes tactical decisions centered on these types of questions:

  • Which of our shows is best positioned for expansion into new markets?
  • How can we increase viewership for our best shows?

Looking at current viewership and advertising revenue, they decide that a show called The Green Orange that is currently in the top 10 television markets is best positioned for expansion. This is an example of a tactical decision. It is a decision taken at a lower level in the organization with the objective of enabling the strategic decisions communicated to the company. Other examples of tactical decisions at this level would be the decision to increase guest appearances on the show or to increase the presence of a particularly popular character based on viewership data.

Operational decisions for The Green Orange occur on the set and are centered on these types of questions:

  • How do we increase viewership for The Green Orange?
  • What can we do to make the show as appealing as possible to our viewership?
  • What can we do to make the characters as appealing as possible to our viewership?

The set designer makes decisions about the appropriate architecture and furnishings for the show. The costume designer makes decisions about how to dress the characters. The writers make decisions about story lines and scripts. The actors decide how to interpret their lines. These are operational decisions made by a wide variety of Apples and Oranges employees, and all are geared toward producing the best possible episodes to realize operational, tactical, and strategic goals.

Information is required for each of these types of decisions. With BI, an organization can provide a continuous flow of information to business decision makers at all levels of the organization to answer questions such as the following:

  • What has happened?
  • What is happening?
  • Why?
  • What will happen?
  • What do we want to have happen?

(From http://technet.microsoft.com/en-us/library/cc811595(office.12).aspx)

BI is where information and decisions converge to provide answers to these questions.

Organizations have been making business decisions from data ever since the first computer was introduced into the workplace, and in the past five years, BI products and understanding has evolved exponentially. In particular, the capacity to transform data into information has evolved. It is important to note that data and information differ in the following way:

  • Data equals raw numbers.
  • Information is repurposed data presented in a format that helps human beings make better decisions.

Various products have facilitated the evolution of data into information. Let's consider Microsoft products specifically: People have been making decisions from data since Excel was introduced to the desktop. Microsoft has offered an OLAP solution since SQL Server 7.0 and OLAP Services, which later evolved into Analysis Services with the release of SQL Server 2000. This was further enhanced by a line of BI-specific products. Again at Microsoft in particular, the Business Scorecard Manager, one of the first products in the BI line, embraced the idea of key performance indicators (KPIs) and scorecards as measures of business performance to enable better decisions. The next iteration of the product, PerformancePoint Server, extended the use of dashboards as visual decision-making support systems, and further expanded the analytic capabilities of the BI tools through the integration of ProClarity. With the most recent integration of PerformancePoint Services into SharePoint 2010, the next step in the evolution makes reliable information accessible throughout the organization in a secure, flexible, and readily available format integrated into daily activities and tools.

With this more unified and familiar structure, people in organizations have the support they need to make decisions and track the impact of their decisions quickly and with ease. This does not mean that people will always make predictable decisions dictated by data. It is important to remember that people make business decisions and that this can involve impulsive and intuitive behaviors. Think of how often on a personal level you might have gone against the facts at hand. For example, every month, Sam allocates money from his paycheck to pay the bills. This month he sees that he has additional money in hand. Following the strategic plan he laid out with his accountant, he knows he should invest this money in his retirement account. Instead Sam decides on impulse to buy tickets for a Broadway show and enjoy a night on the town with friends. This is the human factor. As long as BI involves people making decisions, the human factor will remain as an unpredictable (and sometimes surprising and profitable) aspect of the BI discipline.

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information

To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.


Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.


If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information

Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.


This site is not directed to children under the age of 13.


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information

If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information

Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents

California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure

Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact

Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice

We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020