Iron Viz – The History of the English Football League
Every year Tableau have a set of competition to find their three Iron Viz competitors for the Tableau Conference. The start of this years set has just been announced and has the theme of “found data” from Wikipedia.
I have decided to enter and you can find my entry below, click on it to enter the interactive version.
No idea is new and this is definitely true in data visualisation, we absorb and learn as we find new and interesting content in our field and so it would be fair to say the idea for this visualisation was seeded from several others I’ve seen over time. Here are a few that spring to mind but there are a great many more:
Fifa World Rankings – I saw this Viz last year and immediately fell in love with it, I remembered it after I started my own Viz so guess it had always been at the back of my mind.
Tracing the History of NCAA Conferences – This fantastic viz was featured in one of the talks featured at #tapestry and it set the seed for this latest Viz. You can probably see how.
State of America Rankings – My research in Sankey last week for the blog took me to this great looking visualisation by Jeffrey Shaffer
I didn’t look at these visualisations while building mine, but looking back at what might have inspired me it’s very clear the influence they had on my design in many different ways. I love the way the community shares and influences each other in this way.
Design and Iteration
It’s worth saying that my initial idea didn’t look like this in my head – the idea of the bump chart was there, along with a story element but I imagined having more room to tell
the story without the clicks to reveal. However as the visualisation evolved and I built it out I found the space I had shrinking. I quickly turned to a side scrolling viz (which I’ve seen
done well) but found the space limiting, I also realised I had loads of white space at the start to drop my list of teams – a quite accidental area I was able to make good use of. I love
the way tableau allows me to design and build something so quickly that I can design and iterate “on the fly” without breaking my flow of analysis and story telling.
My first half hours work:
Later, this is as I was developing the story I had this. Note the design is there but the story element hasn’t grown into what it became, I was hoping to float transparent text over each image but as Tableau doesn’t support transparent workbooks I had to change my plan.
Now the painful bit, a confession, I found no quick way to grab the data from Wikipedia. I did spend an hour with different methods (Alteryx, Kimono labs, Import IO) before I realised the a
combination of inconsistent data formatting and lots of text surrounding the data meant it may just be quicker to copy and paste all the tables. That’s over 100 pages of data, but it only
took a couple of hours. I did it directly into Excel, deleted the intervening rows and added the league names as an extra column as I went. As a person who tends to enjoy over engineering solutions I was pleased that my decision actually looks like it saved me time.
Next I created an overall rank in Alteryx and also duplicated the data to create the sloping bump lines (more on this later), before outputting to tde. Alteryx wasn’t essential here but
it’s my tool of choice – I could equally have spent longer in Excel and got the same effect (I prefer to get out of Excel asap these days – Alteryx on the other hand is a joy to use).
There’s not a lot of data but there are a lot of marks on the page and over a hundred axes, incorporating the actions I built to highlight the data this meant performance started to become an issue and I had to take a few steps to pare back my visualisation. As always this became a compromise between aesthetics and story vs user experience, here’s what I did:
- my “bumps” originally took 49 marks between years, I lowered this to just 13. While this means you can make out individual line segments it means performance is much better.
- I moved my Viz into Tableau v9 Beta, this improved performance dramatically and since Tableau Public is on v9 I was still able to publish.
I also decided against adding any more story elements elsewhere in the visualisation like adding points, goals, etc to the tooltip and / or having a clickable league table (as I thought I might do at one point). While the performance isn’t as quick as I’d like it I think I it is good enough not to spoil user experience.
I wanted the design on this Viz to look hot, I mean really hot. I sourced some non-copyright images off the internet (a google search with the Search Tools is really helpful here):
I cannot stress enough how important it is to source images in an ethical way, stealing someone else’s image from the internet without their permission is not cool.
With the images sourced I turned to Photoshop to create my header image to add a few tweaks that would have been hard in Tableau, namely:
- I added a slight gradient to the bottom of the images
- I amended my axes so that they had a transparent colouring every ten years
- I blended the images together into a single header for performance reasons
- I created a smooth title in a nice font – Tableau Public has a limited range of fonts
Technical Tips and Tricks
I’ve used several tricks in this visualisation, none of them new and all of them provided by the Tableau community over time in the form of their blog posts. Here’s a short list:
Dynamic Annotations by Joshua Milligan (@VizPainter) – I used this trick to allow a parameter to hide the league labels.
Creating a Sankey Style Slope-graph by Jeffrey Shaffer (@ ) – the sloping style of chart just makes this Viz in my opinion
Rough Guide to Tableau Actions by Peter Gilks (@pgilks) – actions are used in this Viz to create the story element
Table Calculations by Jonathan Drummey (@ ) – an indispensable compendum of information that i still go back to
I’m proud of this visualisation and so I think it’s important to thank those who played a part in making it happen, even if only in a very small way through their part in the tableau community. If you aren’t on Twitter then I recommend you get an account, the people I’ve already mentioned as well as those below all influenced the creation of this viz in some way, most of them unknowingly and are part of a much larger and wider wonderful Tableau community (too many to mention) that encourages each other to build better and better visualisations.
In no particular order:
Kelly Martin (@VizCandy) creates visualisations that continue to inspire me
Matt Francis (@Matt_Francis) is a Story Telling master, again an inspiration and offered me encouragement and tips for this Viz.
Paul Banoub (@Paulbanoub) offered some great encouragement and also competition in Iron Viz, forcing me to be at my best.
Andy Kreibel (@VizWizBI) offered some performance tips and again loads of encouragement
Last but not least I’d like to thank my The Information Lab colleagues for their input and help.