KPI

KPI

Overview

In SQL Server Analysis Services (SSAS), a key performance indicator (KPI) is a metric that a business uses to measure its success and progress. The metric is compared against a goal to determine its position relative to that goal and its velocity (trend). For example, a business might identify "Monthly Profit" as a KPI. The business establishes monthly goals for profit, and then compares the actual monthly profit to those goals to see if they met, exceeded, or fell short of their goal, and whether their profit is increasing, decreasing, or staying the same.

In Analysis Services, KPIs are objects in a cube and they define expressions that Analysis Services uses to get the value, goal, status, and trend for the KPI. Analysis Services KPIs also specify images that helps users grasp the status and trend of the KPI.

Example of KPIs showing value and goal columns, and graphical status and trend indicators


See Also

 


Other Languages

This article is also available in the following languages:

Brazilian Portuguese (pt-BR)

Leave a Comment
  • Please add 2 and 7 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Richard Mueller edited Revision 10. Comment: Removed (en-US) from title, added tag

  • Fernando Lugão Veltem edited Revision 4. Comment: added portuguese version

  • Matt Burr MSFT edited Original. Comment: Added a link to SQL BOL tutorial on creating a KPI. I'll start doing that more often where it makes sense.

Page 1 of 1 (3 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Matt Burr MSFT edited Original. Comment: Added a link to SQL BOL tutorial on creating a KPI. I'll start doing that more often where it makes sense.

  • Fernando Lugão Veltem edited Revision 4. Comment: added portuguese version

  • Richard Mueller edited Revision 10. Comment: Removed (en-US) from title, added tag

  • Nice post

  • gracias

Page 1 of 1 (5 items)