Twitter Updates

    follow me on Twitter

    Friday, August 12, 2011

    PowerPivot Nuggets - Part 10 - KPIs

    KPIs are another Analysis Services concept coming to PowerPivot. Creating KPIs is pretty straight forward.

    In the example below I have table with Sales and Costs. Let's say we want to have a 5% margin.

    KPIs in PowerPivot are based on a meusure. So, first thing to do is create a measure to calculate the margin.

    Step 2 is setting the KPI target values. Target values can again be based on a measure or as in this simple example on a fixed value.

    Step 3 is setting the tresholds and finally we choose an icon style.

    And that's it, our KPI is ready to use!

    No comments: