{"id":232,"date":"2012-11-06T15:13:39","date_gmt":"2012-11-06T15:13:39","guid":{"rendered":"http:\/\/www.sqlfreelancer.com\/blog\/?p=232"},"modified":"2014-03-06T15:20:27","modified_gmt":"2014-03-06T15:20:27","slug":"creating-a-sharepoint-key-performance-indicator-kpi","status":"publish","type":"post","link":"https:\/\/www.sqlfreelancer.com\/blog\/creating-a-sharepoint-key-performance-indicator-kpi\/","title":{"rendered":"Creating a SharePoint Key Performance Indicator (KPI)"},"content":{"rendered":"

A KPI (Key Performance Indicator) is a graphical representation that displays progress against a predefined measure or business goal. KPIs make it easier for end users to evaluate the amount of progress without reading a bunch of data.<\/p>\n

We will use the sample data (see below) I used in the previous post<\/a> to create our KPI (this data is static since we imported it into Sharepoint as a separate list, so it will not report real time data)<\/p>\n

Let’s say, for example, our DBA Manager wants to upgrade all the SQL Servers to at least SQL Server 2008 R2 and wants to know how many SQL Servers are not compliant. This is a good scenario for using a KPI to display this data.<\/p>\n

\"SQL<\/a><\/p>\n

\n

Creating the KPI<\/h3>\n

In Sharepoint, browse to the page where you want the KPI displayed and go to Site Actions > Create:<\/p>\n

\"SQL<\/a>
\nCustom Lists > KPI List:<\/p>\n

\"SQL<\/a>
\nFor this example, I’ll create a list called SQL Versions KPI:
\n\"SQL<\/a>
\nOnce, the KPI list is created you should see a blank list. To add a KPI, click New > Indicator using data in Sharepoint list (you can also use other data sources for KPI’s):<\/p>\n

\"SQL<\/a>
\nFirst, give the KPI a name:<\/p>\n

\"SQL<\/a>
\nClick here to view the rest of this post.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

A KPI (Key Performance Indicator) is a graphical representation that displays progress against a predefined measure or business goal. KPIs make it easier for end users to evaluate the amount of progress without reading a bunch of data. We will use the sample data (see below) I used in the previous post to create our […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30,48],"tags":[35,106,55,108],"class_list":["post-232","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","category-sharepoint","tag-bi","tag-business-intelligence","tag-kpi","tag-sharepoint"],"_links":{"self":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/comments?post=232"}],"version-history":[{"count":3,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/232\/revisions"}],"predecessor-version":[{"id":241,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/232\/revisions\/241"}],"wp:attachment":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/media?parent=232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/categories?post=232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/tags?post=232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}