Saturday, October 21, 2017

Key Performance Indicator or simply KPI

You are driving. You are checking your speed in speedometer. Similarly there is a digital dashboard which to determine the business intelligence behind an organization.
Key Performance Indicators (KPIs) are highly summarized measures designed to quickly relay the status of that measure. They usually reflect the most vital aspects of the organization. KPIs are often presented as a graphical icon, such as a traffic light or a gauge, designed to convey the indicator’s status at a glance.
In SQL Server Analysis Services, a KPI can reflect five different status levels:
c Very Good
c Good
c Fair
c Bad
c Very Bad
Numeric values: 1 for Very Good, 0.5 for Good, 0 for Fair, −0.5 for Bad, and −1 for Very Bad

Creation of KPI using Cube Design Tab

Name: A unique name for the KPI.
Associated Measure Group :The measure group being used to calculate the
values for the KPI. It can be single measure group in the cube or all measure groups.
Value Expression: An MDX expression used to calculate the current value of the
KPI.
Goal Expression: An MDX expression used to express the current goal for the
KPI.
Status Indicator: The graphical representation to be used with this KPI.
Status Expression: An MDX expression used to translate the current value of
the KPI into a graphic representation.

No comments:

Post a Comment

GEN AI

  Stay Tuned....