Let’s get vizzical, vizzical! I wanna get vizzical! I think that’s how the song goes anyway.
Some of you may know a company called Opta. They’re the leading provider of sport data in Britain and provide feeds to just about everyone, including major broadcasters, sporting clubs and governing bodies. What they don’t know about data isn’t worth knowing.
Anyway, I know what goes on there as my brother Simon is their Director of Marketing. And one of their main industry events is a twice a year football quiz event where they invite all the big players from media, online, broadcast and other experts to get together and battle it out. The questions are ultra-fiendish and the competition fiercely fought. It’s a very popular event.
So my task was to viz up the results from the last quiz and see if we can infer some trends and have a bit of fun.
And here it is. The 4th OptaJoe Football Quiz results viz.
So how’d I do this?
For a change this was the easy bit! A spreadsheet of questions, teams and the scores for each team. I used a very simple Alteryx module to transpose the data into the correct format, but that was a 2 minute job.
That gave me a data structure like this. Perfect for Tableau.
2. Viz design
This was the hard bit. I needed this to be clear, accurate and look smart. Opta plan on using this viz as part of the promotional material for their next quiz so it needed to be spot on.
Top Panel – I usually put the focus of the viz in this area. And the focus is obviously the result. I used one of my favourite views, the dual axis bar chart with shape terminator to show the results.
Bottom Left – I wanted to show how the standings were fluctuating as the rounds went on. For example, did Sky Sports run away with it, or did the lead change hands multiple times? Who finished strongly and who faded at the finish line? Did that with a simple line chart. Not so effective with all the teams selected but as with many views, very effective when only a subset is selected.
Bottom Right – Now I love this view. This is a matrix using the rank calculation to show how each team ranked per round. It works great with the colour coding and allows you to easily see the teams that were constantly good or bad. It also adds an element of colour to the viz.
You can also see how some teams actually won a couple of rounds, like the Mirror, but also had some shockers that cost them a decent overall finish.
Font – Now Opta have a very well defined brand identity, and part of that brand is the typeface they use. I managed to identify it as “Chalet Paris NineteenSeventy“, which was as close as I could get to their font. I managed to download this font and install, which allowed me to select it as one of the usable fonts in Tableau. Unfortunately I got inconsistent behaviour when publishing to Tableau Public so the end result isnt as good as I would have liked. Any report consumer would also have to have that font installed to get the full effect.
You can go grab the font from here if you want.
Filtering – The chosen filtering was determined by the intended use of this viz. For example, this viz is likely to be shared amongst the teams to generate banter and a bit of a laugh at how well / badly one team has performed against one of their industry rivals. So I decided to group up the teams by industry sector, to allow a direct comparison within a couple of clicks.
Take this example of the viz filtered to show just the TV companies taking place. You can see the final outcome, round by round progress and comparative rankings per round. It’s even better when you clear the round selector and iterate through the rounds, effectively replaying the quiz from the start. Very cool.
So there you have it. I’m well pleased with this one. I’ve never tried to vizualise quiz results before and I think this format works well. It’s a good example of the viz design being heavily influenced by the audience and what I imagined they’d do with the viz in terms of generating banter, chat and competition in the pub.
Oh and if you think you can do better than some of the teams then here are the questions. Good luck!