Key Performance Indicators (KPIs) in MOSS 2007
Key Performance Indicators (KPIs)
A Key Performance Indicator (KPI) is a visual signal that tells us the amount of progress made towards a goal. In this article lets see how to create and display KPIs by using Microsoft Office SharePoint Server 2007 KPI list.
KPIs are valuable resources to evaluate progress against measurable goals. To create and publish KPIs, there is a four step procedure.
- Create a KPI list
- Add the KPI to the list
- Add a Web Part to a Web page
- Link the KPI list to the Web Part.
First of all we need to choose a KPI Type:
Using data in SharePoint lists
When SharePoint lists contain items that you can count, items that are part of a workflow, or items that contain dates, you can use a KPI to track how long the issues or tasks have been open, how many are open, and what percentage of a task is complete.
Using data in Microsoft Office Excel workbooks
You can set up a KPI in an Excel workbook and link to the KPI from Office SharePoint Server 2007. As the data in the workbook changes, the KPI is automatically updated.
Using data from Microsoft SQL Server 2005 Analysis Services
Office SharePoint Server 2007 can use KPIs from Analysis Services, a component of Microsoft SQL Server 2005. A systems administrator or database analyst usually sets up these KPIs and registers the data connection with Office SharePoint Server. Then, anyone with the appropriate permissions can access the database and link to the Analysis Services KPIs.
Using manually entered information
In situations where there is no formal system set up or you have a one-time project to track, you can use this KPI and enter the criteria manually. This KPI is useful for displaying information that is communicated in e-mail or some other nonstructured system.
Create a KPI list:
You can create KPI lists in the Reports Library of the Reports Center in a team or organization site, so that other people easily can find them.
- In the site where you want to create the KPI list, on the default page of the Report Center, click Site Actions, and then select View All Site Content. Under the All Site Content heading, click Create.
- On the Create page, under Custom Lists, click KPI List.
- Type a name and an optional description for the KPI list.
- Click OK.
You now have a KPI list to which you can add one or more KPI types.
Add a KPI to the KPI list
1.On the KPI list toolbar, click the arrow next to New.
2. Select “Indicator using data in SharePoint list” KPI type.
3. On the New Indicator page, do the following:
- In the Name and Description boxes, type a name and optional description for the indicator.
- In the Comments box, type text to help people who are viewing the KPI understand what it represents.
- Under SharePoint List and View, in the List URL box, enter the URL of the list or library.
- In View, select the view that contains the items you want to use in the KPI.
- Under Value Calculation, select one of the following ways to calculate the goal of the KPI:
- Number of list items: A count of the total number of items in the list.
- Percentage of list items: A calculation that compares the value of a content type within a column or up to five columns in the list.
- Calculation using all list items in the view: A computation of Total, Average, Maximum, or Minimum of a numerical column in the list. Note The Calucaltion using all list items in the view option is only available if your list includes a numerical field.
6. In the Status Icon section, under Status Icon Rules, in the Better values are list, select higher or lower to indicate which range of numbers will be green.
7. Type the values for the status indicators in the boxes. For example, to track the minimum percentage complete for a set of tasks, you can set the green indicator at the goal value and the warning value to be one less than the goal value. In that case, if you want to see when the minimum percentage complete drops below 25 percent, you set the green indicator to 25 and the yellow indicator to 24.
After you add all of the KPIs that you want to the KPI list, you can publish them on a Web page by using one of two KPI Web Parts.
Publish the KPI on a Web page
After you add one or more KPI types to the KPI list, you can display the KPI list on My Site, a team site, or any other SharePoint page. In addition, the KPI list is available for use by anyone in your organization who has permissions to access it. You can use one or all of the KPIs that appear on the list. To display the KPIs, you edit the Web page where you want to display the KPI list and add a KPI Web Part. To display the entire KPI list, use the KPI List Web Part. To show only one of the KPIs from the list, use the KPI Details Web Part.
Add a Web Part to a page
1. On the page where you want to add the KPI, click Site Actions, and then select Edit Page.
2. In the zone in which you want to add the KPI, click Add a Web Part.
3. In the Add Web Parts dialog box, in the All Web Parts section, under Dashboard, do one of the following.
- To insert the entire KPI list, select Key Performance Indicators.
- To choose one KPI from the KPI list, select KPI Details.
4. Click Add.
Link the KPI list to the Web Part
1. In the Web Part, click Open the tool pane.
2. In the tool pane, under Indicator List, navigate to and double-click the KPI list that you created in the previous set of procedures. The list may be in the Report Center of the site.
3. Select one of the KPIs in the list. (If you selected the KPI List, the entire list is displayed.)
4. Click OK.
Hope this helps–