Create KPI List from Excel Worksheet

KPI Lists are created to indicate the Goal Vs Actual status of critical Business parameters, multiple KPI's can be added to a single KPI List so that the status of all the critical parameters are captured in a single list.

In this post we shall see on how to create a KPI List based on the data in a Published Excel Sheet

First Create an Excel Workbook with the data which you want to represent in the KPI, I have created the following sheet.

Publish KPI List to Dashboards using KPI List Web Part

KPI Lists are used to display business critical parameters, with their goals and the current status, We can use the KPI List Web Part to display KPI Lists in Dashboards. KPI List Web Parts can also be configured to display multiple KPI Lists in the same Web part.
In this post we shall see on how to display a KPI List in a dashboard using a KPI List Web Part.