O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating and using Key Performance Indicators

Key Performance Indicators (KPIs) allow the model to implement a logic layer, so that a value can be monitored according to a rule. The outcome of the rule is a simple set of results that indicates how the value is comparing to the expectations, and usually equates to one of the three simple conditions: bad, moderate, or good.

By summarizing logic into the model in this way, the KPI improves model usability as the user is not required to interpret the value in the context of a business situation (or some layer of logic that is applied to the values); this is all managed by the KPI. Furthermore, since the KPI is represented by a state (for example, bad, moderate, or good), the KPI can cover boundary ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required