BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
You can create key performance indicators (KPIs) within Analysis Services Tabular, but there a couple of foibles that you need to be aware of, as shown by this blog.
- Key Performance Indicators (KPIs) (this blog)
- Creating relative KPIS in SSAS Tabular
- Absolute KPIs in SSAS Tabular
Posted by Andy Brown on 28 January 2016
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Key Performance Indicators (KPIs)
KPIs are a good idea, with some serious implementation issues (at least in my experience). Here's what they look like:
Here our aim is that this period's sales should be at least as big as last year's. The red circles show that we're failing completely in April, July and December, while the yellow ones shows that we're failing a bit in October and November.
The parts of a KPI
A KPI has 3 main components:
|Value||The thing we're measuring.|
|Goal||What we would like it to equal.|
|Status||How well we're doing against this target.|
Note that Excel pivot tables imply that there is a fourth component called Trend, but you can't set this in SSAS Tabular.
The icon sets available - in theory
In theory you can choose from the following range of icons for your KPI display:
The palette of icons theoretically available.
In practice it seems that if you're using Excel 2013 at any rate, the only set you'll ever get is the one shown on the left.
Can this really be true? I've found a couple of others sites reporting the same problem. I've left a question on StackOverflow and no one has contradicted me. It really does appear that this is a bug!
OK - now I've got my gripes about KPIs in SSAS Tabular out of the way, let's look at how they work!