562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
How to create absolute and relative KPIs in SSAS Tabular Part one of a three-part series of blogs |
---|
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.
This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources. |
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.
A KPI has 3 main components:
Component | Notes |
---|---|
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.
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!
Parts of this blog |
---|
|
Some other pages relevant to the above blogs include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2023. All Rights Reserved.