Oh dear – it’s that time of year again. Time for the Iron Viz competition. The first challenge this year is the Wikipedia challenge. Create a viz, any viz, so long as the data comes from Wikipedia.
1. The Idea
There are tons of data on Wikipedia. Trouble is, much of it is in a nightmare format and takes a lot of tidying up. I wasn’t cool with doing much of that this time so reasonably tidy data was a must. I also wanted something with depth, and an element of competition, danger and heroism. And I love technology so wanted that as well. All in all a tough ask.
But then I stumbled across the perfect topic – how speed records have evolved over time. Ticks all the boxes and could be a nice use of Story Points.
So that was it – “The Evolution of the Speed Record” was GO!
I got the data from 3 Wikipedia pages.
The data has enough variety and richness to satisfy my requirements. It is also pretty consistent between pages so makes consolidation into Excel a lot easier. I did have to remove entries that referred to record attempts that were not ratified, and I also had to standardise on mph vs kph as well as distance miles vs kilometers. But with those caveats, I’d gotten me a pretty decent dataset.
It was also cool that most rows linked off to pages about the pilot and the craft used, each with some neat images for use in the viz. Plenty of room to supplement this data set should that be required. I also managed to find some clips of some of the drivers on YouTube.
3. Viz Design
The evolution of the record featured trials and tribulations, joy and pain, heroes and villains. So all in all this was a great opportunity to try Story Points for the first time.
The overall look and feel took some arriving at and I’d like to thank Kelly & Chris for assisting with the peer review process. My original version made use of custom “speed-style” fonts to give the impression of speed, but we eventually decided that the real ethos of the whole story was the nostalgia and ‘Pathe’ News‘ style of flat capped heroes with handlebar mustaches pushing the boundaries of technology. So we switched to a style that sort of represented a 1930’s newspaper. I was really pleased with the final look and feel of it. Deciding the style really helped the story design of the charts. I tried to be as minimal as possible, removing unnecessary chart ink and distractions.
I wanted to give a feeling of progressing along a chronological timeline, whilst interspersing with ‘infographic’ style information pages. In particular there was a great story to tell about Germany and Operation Paperclip, that made a great infographic.
I obviously wanted to use some advanced techniques so used the individual Wikipedia pages for some of the pilots to link off to an embedded web page. A masterstroke was working out that if I added “?printable=yes” to the URL it would give me a stripped back render of the page, that almost looked like a 1930’s newspaper, fitting the theme perfectly. I was really happy with that.
There’s also a page that links off to a YouTube video of the driver. I like that one, as the links are all monochromatic grainy film with appropriately stiff-upper-lipped voiceover. Excellent. I did worry a little about the ethics of including these videos as some of them show the final moments of the driver’s life. I think I’ve been respectful enough in my overall viz to justify inclusion though. I also added an old-school TV border to give a little bit more visual appeal.
So overall I was really pleased with this. A nice style, several good stories and a use of some advanced multimedia techniques.
As mentioned this was my first use of Story Points. Unfortunately it turned out to be a frustrating experience. The feature, whilst undoubtedly useful, is in need of customisation and doesn’t provide a smooth user experience. One for the Tableau dev team to look at for sure.
Another challenge was the fact that the new Tableau Public site has sneakily been changed to https. That only becomes apparent when accessing a published viz using Chrome. Make sure your links to embedded content are https or they won’t work.
5. Analysis & Story
So what can we take from this story? Here are some of the key observations that Tableau has allowed me to glean from the dataset.
- Records are dominated by only 3 nations, with France killing it in early years with their brilliant aviators.
- It took a while for airspeed to get going, in fact land speeds were higher for a long time.
- Germany’s poor record really didn’t tell the full story, their brilliant scientists being key to the USA’s great NASA missions in later years. Interesting how their previous misdemeanours were overlooked though…
- Most record-breaking attempts advanced the speed slightly, with the occasional big jump.
- The incredible Malcolm Campbell and his son Donald held an amazing 21 records.
- Oddly, no-one seems to be bothered about records anymore, there hasn’t been a new record since 1997. Or is it too hard / dangerous now?
So that’s it. I hope you enjoy the visualisation. If you do then please consider voting for me in the IronViz competition, should this make the Elite8 twitter vote-off thing.