KPI Report with Reporting Services 2008

Reporting Services 2008 brought many enhancements for data visualization. The queen is Gauge, which is ideal tool to create scorecard and KPI. Imagine the report popping up in front of manager with colourful and fancy indicators like this:

thermo1

Gauge is only one among many other things. Charting is more fun than ever, with many 3D effects and customizable areas. I also like new feature such as calculated series that deliver moving average report in minutes. No more complex expression to calculate median or moving average data.

Gauge also comes with many type such as radial type with speedometer style. I can display sales indicator and turn the pointer to red, yellow, or green like this:

gauge1

I did demo and discussion about this topic in Singapore SQL UG meeting on June 25, 2009. As I promised to upload my slide deck, you can grab it here:

Of course I release the source code too for deeper exploration. Apologize that I don’t have enough passion to tidy up the reports for best appearance. It is available in my skydrive:

All reports need AdventureWorks2008 and AdventureWorks2008DW sample, available to download from CodePlex.

Below are some pictures from the meeting:

SQLUG-25Jun 2009-06-25 006

SQLUG-25Jun 2009-06-25 009

  4 comments for “KPI Report with Reporting Services 2008

  1. June 29, 2009 at 2:25 AM

    Wah manstab! bos, post di sqlserver-indo juga yah :)

  2. April 5, 2010 at 2:19 AM

    Is 3D effects Gauge free with SQL Sever 2008 and Can Integrate with SharePoint 2007 /2010

  3. MCA
    June 7, 2010 at 7:36 AM

    hi faizal
    http://faizal-comeacross.blogspot.com/

    It’s free and works well in SharePoint 2007.

Leave a Reply