The release of SQL Server Reporting Services 2008 R2 was accompanied with much fanfare regarding the new gauges that were available. This blog will look at different ways of implementing KPIs that do not require the gauges or indicators that are available. The reason for this is that, by default, the SSRS Indicator gauges do… Continue reading SSRS Red-Yellow-Green Indicators: An Alternative Approach?
Data visualisation can be defined as the representation of data graphically in order to reveal the 'stories' within the data. However, it is important to ensure that the data is properly in place before starting. It’s easy to get sidetracked with the selection of data visualisation itself for example - a sparkline? a trellis chart? This… Continue reading Data Fundamentals in Data Visualisation: lesson from the history of astronomy
Stephen Few blogged recently about Business Intelligence hitting a ‘wall’; if you haven’t read this post, I strongly recommend that you read it. I have enjoyed many of Few’s blogs over the years, and this particular blog was very insightful. It focuses on the dissonance between ‘old’ business intelligence and ‘new’ business intelligence. ‘Old’ business… Continue reading Knocking down Stephen Few’s Business Intelligence Wall?
Given that comparison is a starting point to any investigation of the data, it is important to ensure that people are not blindly going through SSRS chart wizards, believing the representation to be correct. As this illustration shows, it is important to double-check that the SSRS mechanisms are being correctly deployed to produce the correct… Continue reading Facilitating Comparison with Sparklines
I am presenting at the SQLPass '24Hop' 'Women in Technology' event on March 15th 2011. The topic is Dashboard Design and Practice using SSRS, and this blog is focused on a small part of the overall SQLPass presentation. Here, I will talk about some of the design around a dashboard which displays information about the… Continue reading Dashboard Design using Microsoft Connect item data for SQL Server Denali