I want my report not only to display the right information for me and my team but I also want it to light up like a christmas tree.. yeah baby!!!
In PowerPivot Denali it is possible to create your own KPI’s. Using the Adventureworks database (which you can download here) I made a report with two measures on it;
- Sales amount
- Sales amount previous year
Sales amount is a simple SUM on the fact table. Sales amount previous year is a measure I made, the formula is;
=CALCULATE(SUM(FactInternetSales[SalesAmount]), PARALLELPERIOD(DimDate[FullDateAlternateKey], -1, YEAR))
Easy as pie, isnt it? Next thing I did was create a KPI from within Excel:
Note that both of the measures used by this KPI are explicitly known as measures in PowerPivot:
And the result is… christmas lights!!!
Ok not very intimidating but imagine lots of lights and actual meaningfull information 😉
Pick your flavour
Your information can be analysed using the PowerPivot tabular interface (one on the left) or the Multi-dimensional interface. I personally prefer the multi-dimensional interface (one on the right):