Microsoft Office Tutorials and References
In Depth Information
Microsoft Office SharePoint Server
Key Performance Indicator Lists and Parts
Key performance indicators (KPIs) provide the basis for tracking key measurements in an organization.
In addition to the actual values being tracked, KPIs include goals and trends. Many BI systems enable
tracking KPIs on dashboards, as part of lists, in reports, or as part of more complex score carding
applications. Office SharePoint Server provides basic functionality for displaying KPIs in dashboards using
the KPI web part, or as part of KPI lists, as shown in Figure 1-9.
KPI lists contain KPIs and can present them visually. The KPIs can be contained in a flat list and be
grouped hierarchically. The status, goals, and trends for the KPI can be sourced from values in a SQL
Server Analysis Services 2005 cube, in an Excel workbook, or in a SharePoint list, and simply entered
into the KPI.
These different KPI types can all exist in the same list, providing a great aggregation and view across
multiple data sources.
The KPI web part displays the value and additional information for a single KPI. Users can get to these
parts either by clicking on a KPI in the list, or by placing the KPI part directly on a dashboard.
A dashboard is an aggregation of related data and content in the form of reports, tables, and charts.
These are presented on the same page, and provide an aggregate, contextualized view. For example,