Skip to main content

Key Performance Indicators - KPI List and Web Parts - review

In MOSS 2007 we have an interesting feature - Key Performance Indicators (KPI) List and Web Part. I have done some research around that matter.

First I would like to show how to create KPI list with several indicators and then I would like to share some ideas for real life.

KPI List

When the KPI List is created we can add new indicators to that list.

First will be manual indicator:

This type of indicator is very simple and almost useless for real scenarios:


It is for scenarios like "we just want to display some KPI".

Next will be indicator based on SharePoint list:


We specify the name, SharePoint list, view of the list and what we are going to count as an indicator:

When we save it we can see the details view of that indicator:


This option is for scenarios like "number of project tasks completed", "number of issues", "amount of expenses claimed" etc. The limitation of that indicator is that we need to create a view on the list for each indicator otherwise there is no way to set up a criteria for list items.

Next indicator type is Excel Workbook indicator:


In order to create this type of indicator we have to upload an Excel 2007 workbook with indicators to the Excel Services trusted location. Initially I had the following Excel document:

I pointed to that document in the indicator settings:



Then I selected appropriate workbook cells to use as the goal for the KPI:


When I tried to save the indicator I got an error "Goal must be either a number or a valid cell adress":



I added another cell into the workbook and then put that cell as the goal for amber light:


So I have got an indicator based on Excel workbook.
This option is more advanced in comparison to the SharePoint list and manual one. The limitation of that indicator is that we need Excel 2007 and Excel Services in order to use it. It is also just a proxy display for Excel data.

I'm not going to cover the indicator based on SQL Server 2005 Analysis Services, but the idea is the same as with Excel Workbook indicator.

KPI Web Parts aka Dashboards

Then I added two Web parts displaying my indicators:





Resolution

Though it is useful out-of-the-box feature of MOSS 2007 there are some serious limitations and disadvantages:

1. It's only available as a part of MOSS 2007 and not WSS 3.0
2. Excel workbook indicator needs Excel 2007 and Analysis Services indicator needs SQL Server 2005 Analysis Services
3. There is no way to customize look and feel i.e. change the indicator images
4. There is no way to define indicator algorythm and source information criteria
5. We need to create a separate list (KPI List) to store information about our data to be able to display a set of indicators about our data. I think it would be easier to have just configurable dashboards rather than indicators lists + dashboards

Next Step
Custom KPI Dashboard which will be available for WSS and which will indicate using data from Dynamics CRM using XSLT for output.

Stay tuned for more articles from Wylde Solutions.

If you have any questions in regard to implementing KPIs and other Business Intelligence features for your company or you need assistance contact us now for a consultation.

UPDATED:

Wylde Solutions released VG Custom KPI View Web Part. This is a Web part that allows you to display key performance indicators using custom images.

Information about the Web part is located at the following link: VG Custom KPI View Web Part

If you have any enquiries please follow link above for contact information.

UPDATED:

I have published a post Key Performance Indicators - Create KPI List and indicator programmatically.
Please check.

Comments

  1. Slava, preved!

    Derzhis' bodryachkom!

    Sergey Frolov

    ReplyDelete
  2. Hi,
    The link to the VG Custom KPI View is broken. Could you please send me the new link if this web part is still available?

    Thanks,
    Tiziana Rosafio

    ReplyDelete
  3. Hi Tiziana,

    The link is now fixed. You can get the overview of the Web Part here: http://wyldesolutions.com/Products/WebParts/VGCustomKPIViewWebPart/Wylde%20Solutions%20-%20VG%20Custom%20KPI%20View%20Web%20Part.pdf

    If you are interested further or have any other queries, please send us an email with details to sales@wyldesolutions.com

    Thank you.

    Best wishes,
    Slava Gorbunov

    ReplyDelete

Post a Comment

Popular posts from this blog

Setting up External Content Type for SQL Server database using SQL Server authentication - SharePoint 2010 Foundation

This post is a follow up on the issues that I have got setting up External Content Type (ECT) on SharePoint 2010 Foundation that was going to connect to remote SQL Server database for information. I cannot use my SharePoint user accounts to access SQL Server.

According to the information I have discovered ECT and Business Connectivity Services are available in the SharePoint 2010 Foundation, but there are some issues if you want to use authentication methods in your external connections that are different from Windows Identity or Current User Identity. This is because there is no Secure Store Service in SharePoint 2010 Foundation which serves as an impersonation hub and is only available in SharePoint 2010 Server edition.
The issues are coming from the fact that you can actually create ECT in SharePoint Designer 2010 providing just Secure Store ID and system would ask you for credentials and here you go, but when you try to use your ECT in External Lists or as a lookup columns you wou…

SharePoint 2013 - Setting Up External Content Type

There were earlier posts where we discussed External Content Types setup for SharePoint 2010:

Setting up External Content Type for SQL Server database using SQL Server authentication - SharePoint 2010 Foundation

External Content Types - Reload - Setting up for SQL Server database using SQL Server authentication - SharePoint 2010 Server

This one is about creating connection to the custom SQL Server database (External System) in SharePoint 2013.

1. Create Secure Store Service Target Application

1.1. Go to Central Administration -> Manage Service Applications -> Secure Store Service Application. Click "Generate New Key" if required:


1.2. Provide Pass Phrase:

1.3. Create "New" to create new Target Application:


1.4. Provide the name and other parameters and click "Next":

Note: It's good idea to specify "Group" for Target Application Type. In that case you would be able to manage access to the external data using Active Directory groups rather …

SharePoint 2010 Search Issue - FQDN Crawl

I have recently set up a standalone SharePoint 2010 environment.

The Web application was created with host header and the site collection is accessible from the client machines, but not internally. That was because of using FQDN to access the Web site.

The error when I tried to access site internally was similar to the one described here:

You receive error 401.1 when you browse a Web site that uses Integrated Authentication and is hosted on IIS 5.1 or a later version

And the search returned the following error in the Event Log:

"The start address cannot be crawled.

Context: Application 'Search_Service_Application', Catalog 'Portal_Content'

Details: This item could not be crawled because the crawler could not connect to the repository."

One of the suggestions was to disable the loopback check, but that would compromise the Web server.

So what I have done was:

1. Added a binding to my IIS Web site for a different port. Let's say my Web server name is win-v7m…