SharePoint KPIs Part 2 - Creating a basic SharePoint KPI from scratch
Written By: Rahul Mehta -- 1/25/2011 --
(13) comments --
Categories: Design, MOSS 2007
How do I create a basic KPI from scratch in MOSS 2007? Read on...
Every enterprise needs to measure business and employee performance. One
method is to use Key Performance Indicators (KPIs). SharePoint provides KPI Lists
where one can measure performance by setting a goal, actual and warning values.
In our scenario, we will measure product sales of an employee. So let's start by creating
a KPI List.
Go to Site Actions-> Create -> KPI List. Provide a name and click OK. Go to
the KPI List which you just created. Click on New and select "Indicator using manually entered information".
A page will appear where we need to enter the KPI name, sales goal value, sales target value and sales warning value manually.
(Click the graphic to pop up a full size image.)
The benefit of using such an approach is that the data will reside directly in
the KPI list where one can manually change the data from within SharePoint itself. So provide the data as shown in
the image below.
After entering the information, press OK and you will see that a KPI will be created in
the KPI List with an indicator showing a Green status - which describes either
the actual value has met or exceeded the goal.
We have entered a few more records with a combination of employees met goals, employees in warning level and employees that are below warning level of target.
- Use a KPI List to manually create a KPI list that could be displayed on a dashboard.
- Use a KPI List to fetch data from SharePoint lists or other external data sources like
an Excel sheet.
- Return to
MSSharepointTips to read about other topics and ideas.
- Check out MSSQLTips.com for great
information about Microsoft SQL Server.