Business Intelligence, Data Visualisation, PowerBI, Tableau

Using Excel as a data source for Tableau – Shaping your Data

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

Business Intelligence, SQLServerPedia Syndication

Bullet Charts in SQL Server Reporting Services 2008 R2: ‘How To’ Video

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

Data Visualisation, Tableau

Nobel Peace Prize Winners visualisation using Tableau

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

Business Intelligence, Data Visualisation

Why don’t people like bullet charts? Part 2

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

Business Intelligence, Data Visualisation, Tableau

Visualisation of Nobel Peace Prize Winners

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

Business Intelligence, Data Visualisation

Why don’t people like bullet charts? Part 1

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

Business Intelligence, Community

SQLBits Presentation now Available! What’s John Stuart Mill got to do with reporting services?

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?