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:
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:
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:
hendrik:
Wah manstab! bos, post di sqlserver-indo juga yah
June 29, 2009, 2:25 AMChoirulAmri.org » Blog Archive » Presenting Trend with Reporting Services:
[...] posted KPI report in previous entry, something that really cool in SSRS 2008. There is another method to display a trend without much [...]
August 23, 2009, 6:43 PM