Microsoft® SharePoint® Server 2010 Bible

Chapter 16. Using Status Lists to Implement KPIs

IN THIS CHAPTER

• Defining Key Performance Indicators

• Implementing Status List KPIs from SharePoint lists

• Implementing Status List KPIs from Excel

• Implementing Status List KPIs from Analysis Services

• Implementing Status List KPIs manually

Status Lists help display key performance information for your organization in a manner that drives actions. Key Performance Indicators (KPIs) are configured to represent the progress of the organization or team in a meaningful way so that it focuses the team on the right actions and goals. To do this, KPIs aggregate data that resides in locations throughout the company, providing a view of trend information from that data source. Multiple indicators are combined in a single list so that users see at a glance the high-level information that they need.

Defining the appropriate indicators for your organization can be a big job to get your head around. This chapter goes through the steps to define your KPIs and combine them for your audiences. Then we delve into the specifics of creating KPIs for each possible data source, SharePoint lists, Excel worksheets, SQL Server Analysis Services, and manual KPIs. Throughout these steps, we provide a lot of examples to help you envision how to turn the data in your organization into knowledge that drives action.

Defining Your Key Performance Indicators

Your Key Performance Indicators follow the goals of your organization. Because KPIs are very popular for managing business ...