The purpose of this blog is to help you to see the difference that the underlying data structure has in determining the visual resulting visual output. For me, the underlying data is all-important; if it isn't clean or well-structured, then this needs to be resolved first. After that, even the neat pivoted and un-pivoted data… Continue reading Using Excel as a data source for Tableau – Shaping your Data
Recently someone told me that they were struggling to produce a Stephen Few inspired bullet chart using Microsoft SQL Server 2008 R2. This is perfectly understandable, because, for some reason, bullet charts are considered a 'gauge' in Reporting Services. This is ironic because, if you've read Stephen Few's material, then you will already be aware… Continue reading Bullet Charts in SQL Server Reporting Services 2008 R2: ‘How To’ Video
As you may have seen, the Man Booker prize has been won by Howard Jacobson with The Finkler Question. If you're a bookworm like me, and like to read all of the short-listed entries and previous Man Booker Prize winners, then you may be interested to have a look at my 'Man Booker Prize' dashboard, which is hosted… Continue reading Man Booker Prize Winners since 1969
It's possible to interact directly with Tableau workbooks using Tableau Public, which is probably best described as a 'Youtube' for data. This means that viewers are no longer passive consumers of data visualisations. Instead, data consumers are turned into active, interactive data consumers who can visually navigate their way, slicing intuitively through their data sets in… Continue reading Nobel Peace Prize Winners visualisation using Tableau
This is the second blog in a series which focuses on the occasional difficulties around user acceptance of bullet charts. In my experience, bullet charts are a bit 'marmite' - some people 'get' them completely, but other people struggle and do not 'get' them. In my own opinion, I am a bullet chart fan, since… Continue reading Why don’t people like bullet charts? Part 2
Every year since 1901, the Nobel Prize is an international award dedicated to outstanding achievements to humanity. There are prizes in physics, chemistry, physiology or medicine, literature. It is administered by the Nobel Foundation in Stockholm, Sweden.The most commonly recognised award is the award for peace, and this year, the Nobel Peace Prize winner has been announced as Chinese dissident Liu… Continue reading Visualisation of Nobel Peace Prize Winners
From speaking with users and report writers, I have found that there are a number of aspects of bullet charts which people might find a bit off-putting. On the other hand, there are users and report writers who love bullet charts and 'ra ra' them as far as possible, using them to replace pie charts and gauges.This blog is the first… Continue reading Why don’t people like bullet charts? Part 1
Think of John Stuart Mill's principle of utilitarianism - the "greatest-happiness principle", which posits that one must always act so as to produce the greatest happiness for the greatest number of people, within reason. I think that this is a good principle for reporting; it's about trying to make data as comprehensible as possible, to the… Continue reading SQLBits Presentation now Available! What’s John Stuart Mill got to do with reporting services?