Tableau

A day at the races! This week we got a wealth of Strava data from Andy and Eva across two recent events that they have competed in. Find out more here. You’ll see that they each had a set of questions for the community to consider. I was busy trying to reproduce some of the graphs I’ve seen produced from sports watch / trackers and got very bogged down in the data. A quick look at the submissions that were coming through on twitter showed me that those submitting were focussing on a subset of the questions and only tackling one person’s data. Phew – it was good to take a step back! Eva’s question about the second kilometer of the run intrigued me. Friends that participate in triathlons have mentioned the initial pain over the first 500 meters but I hadn’t picked up on a lull after the first 1000 meters. ...

For week 37 of Makeover Monday we’re looking at UK bicycle thefts based on data from data.police.uk. The reference site linked above has pretty extensive visualisations and I love the way they unfold as you work your way through the site. I’m not going to try to improve upon the site, instead I’m looking for a different angle to show and, given the bleakness of the data (less than 1% of bike thefts resolved!), it’s an opportunity to try a paired back black and white viz. ...

The UN, #MakeoverMonday and #VizForSocialGood came together to challenge the data visualisation community to visualise results from the MYWorld survey on the UN Sustainable Development Goals. You can read more about the challenge on the Makeover Monday blog. The design is geared towards a tablet as there were indications that the UN would like to use the finished viz on stands with tablets at various UN events like the forthcoming UN General Assembly in New York. ...

A quick post for Makeover Monday this week. We had data on NFL player arrests from 2000 to August 2017 with the aim to makeover the interactive visualisation here. Whilst exploring the data I was interested to see the free text outcome data. After grouping this I was surprised to see that the proportion of guilty outcomes seemed to be reducing over time whilst the proportion with an undetermined outcome was increasing . In hindsight you’d expect more recent cases to not yet be determined – perhaps they haven’t yet worked through the system? Still I suspect that there is a story here. Of course that story may not be specific to NFL player arrests and I haven’t checked for similar stats across the wider population. ...

So apparently there was a pretty exciting solar eclipse this week. I guess that’s why Eva picked a NASA data set on solar eclipses for Makeover Monday! Go check out the original article as it’s got a great map of eclipse paths. The data we got for our makeover didn’t include paths, instead it included one coordinate for each eclipse over 5 millennia along with data on the type and duration. Still, the community produced some amazing and informative visualisations. ...

Earlier this year the pudding published an excellent analysis into the myth that various events were a trigger for mini baby booms. The analysis was based on CDC data on natality in America. Fast forward to August and the data set was selected by Andy for week 33 of Makeover Monday. ...

This week a makeover of an article and Tableau chart about sanitation in rural Indian schools, based on data from the ASER Centre. Here is the original chart posted by Eva and Andy: Made over A tile map seemed like a good way to retain some of the benefits of the map whilst mitigating the downsides. It was an interesting exercise to make a tile map for India and the end result still retains some similarity to an outline of India. The addition of imagery featuring the Indian flag reinforces the fact that the viz is about India, and I like the analogy of a child putting their hand up to ask to go to the toilet!. ...

Back into it with a revisualisation of a 2015 Southeast Asian Games infographic. A simple and engaging infographic telling the history of the games. The data provided was a little different; only covering 2007 to 2015. I’ve focussed on a medal table for 2015 and area chart showing medal count trends over the period. Firstly this keeps things simple, secondly it was something I could compare against medal tables on Wikipedia. The reason I wanted to be able to sense check the data against something was due to the structure. For team events both the team medal and individual participants were included so some extra filtering was needed and I wanted to check I had that right. ...

I was on holiday for week 27 to 30 so caught up with these four later in the year… Week 27: Tourism in Berlin and Brandenburg For week 27 a makeover of a filled map showing visitor stats for Berlin and Brandenburg. I’ve retained the filled maps but focussed on an angle that interested me; whilst Berlin ranks top for both number of visitors and total number of nights in all years, when you look at average nights per visitor it is one of the regional districts that usually tops the list. Check out the interactive version here on Tableau Public where you can look at different years, and explore how the figures differ for domestic or international tourists. ...

It’s the half way point for Makeover Monday in 2017: 26 charts selected by Andy and Eva, 26 makeovers submitted and 26 blog posts written. It’s been a tough challenge for me to produce a visualisation every week and tougher still to write about each one. However, both of those aspects have been enjoyable, and the practice and reflection has really helped me get more out of Tableau in my job. I’ve had a few submissions selected in the weekly round up and one was selected in a #VizForSocialGood project for use by Inter American Development Bank. The way the Makeover Monday project works this year with the weekly wrap up lessons and the community input has made a huge difference to me. If you’re reading this, chances are you’ve helped me so thanks! ...