#MakeoverMonday got shortlisted for the Kantar Information Is Beautiful Awards

What an honour! #MakeoverMonday has been shortlisted for “Best DataViz Project” in the Kantar Information Is Beautiful Awards.

static-image

If you’ve enjoyed the project, please go vote for us. Click this link and press the grey vote button (note that you can only click the button once per category, so choose wisely! subliminal messaging: choose MakeoverMonday! )

It’s really been an astonishing year and this project has blown me away.

It’s not about us. It’s about community.

Andy and I predicted it would be a small thing and nobody would care. But then 372 people got involved over 38 weeks. WTF? 54 makeovers a week? Amazing.

Some highlights

Go and look at the Pinterest board: look at the depth and variety of ways to visualize data. When people blog about the impact the project has had, you get the sense it’s really changing the way people work. (Neil Richards and Michael Mixon are two great examples)

Kids are getting involved. Children: enthused by data.

I’ve learnt a lot about how to criticize constructively.  We’ve had some great thoughts on whether things should be complicated or simple.

Who knew that China was the world’s biggest grower of peaches?

Or that a TEU is a measure used by the shipping industry?

Each of the 38 datasets has taught us something. Whether it’s serious or not, participants are learning about the world each week.

#MakeoverMonday live at Tableau Conference in London

We’ve done this live many times and the experience is amazing. You should do it too!

Comcast put MakeoverMonday as a prerequisite in their job descriptions! What? Amazing.

The highlights are long. Andy and I would like to thank everyone who’s been involved in such a rewarding project.

Sounds great! How do I vote? Click here.

#MakeoverMonday: Peaches

peach-index-vert

When Andy and I were discussing future topics, we were considering the Global Peace Index. I mistyped it as the Global Peach Index. “Wait a minute, that sounds fun. What if there is data on the peach industry?”

And here we are with data on global peach growth.

On the first exploration of the data, the massive domination of China pops out. Below is the percentage of peaches grown in China. >30% of all peaches in 2012.

of-all-production

“But China’s huge. And populous,” I though. And that led me to bring in population and area. Do that and you realise that while China’s clearly growing loadsa peaches, and has been increasing its growth in the last two decade, it’s Greece that’s the biggest relative to are and population.

All of which is a good way to say that in data analytics: think about the contextual implications of each measure in your database.

The original

2016-09-26_10-08-38

This week’s source from FAOSTAT is kinda standard fare. Things I think could be improved:

  1. The colour bins have very specific boundaries. I’d rather see them fitting round numbers. This mapping system has to fit all FAOSTAT datasets, so I suspect there’s some automation going on here.
  2. The map has ocean depth and land cover detail. That’s too much detail. Why should I be interested in ocean depth when looking at peach production?
  3. The line chart updates when you select a country, which is nice, but I’d rather also see the title update, otherwise it’s not obvious if you did select anything. There is a country line legend right at the bottom, but I didn’t spot that.

Here’s the horizontal version of the makeover:

peach-index-horz

MakeoverMonday: World’s biggest data breaches

This week we’re tackling one of the interactives from Information Is Beautiful.

I struggled with this week’s makeover. I couldn’t find any great way to retell the story to the level of detail of the original. In the end I decided to exclude detail and focus on just the growth the hacking and what that means for me and you. Personally, I am a huge fan of Lastpass and recommend everyone to use it or an equivalent.

I spent a long time trying to do a remake but in a “better” way than using circles.

I tried a stacked bar:

dashboard-4

The problem? There’s less detail than in the original and it’s not engaging.

I tried a treemap bar (which you can interact with here):

world-biggest-data-breaches

The problem? A treemap is a part-to-whole, and this dataset is only selected breaches. I do like this chart, but because the tree implies part-to-whole it’s not acceptable.

In the end, after more time than I had available to spend on the makeover this week, I figured I’d have to find a simpler, different story and focus on hacks alone:

breaches

My conclusion? The original is a very good way to prioritise access to all the data over ease and accuracy of comparing each breach.

2016-09-19_10-39-10

What I like

  • It’s engaging. That makes me want to explore it.
  • There is detail, in the form of a short sentence to add context, when you click on a circle.
  • It works well on mobile (the vertical timeline is becoming more prevalent as we move to mobile).
  • I like the interactivity: switching bubble size and color for different categories reveals different insights.

What I dislike

  • It isn’t easy to accurately compare the difference in size of different circles. If the prime purpose is to show differences accurately, then you’d need to use bars. Since that wasn’t the prime purpose here, this isn’t too big a problem.
  • There’s a lot of overlapped marks. A border appears around each circle as you move your mouse over it, making this less of a problem. Making the marks transparent is another possible solution.
  • You can choose to colour the bubble by year, but the “Interesting story” color overrides that, confusingly.

 

The little of visualization design: grouping with colour

[I’m shamelessly stealing the idea for “the little of” from Andy Kirk. His series has been amazing]

Yesterday in MakeoverMonday we tackled the worldwide shipping industry. Today the Economist shared a chart about the same topic (above). I highly recommend you also read the full article as it’s about an industry trying to save itself through the use of better data.

What’s I like in this chart is the “Proposed alliances” blocks next to the company names. The primary question in the story is the size of the shipping companies. The secondary question, dealt with in the second half of the article, covers alliances. They designed the chart so you can get on with answering the primary question without the initial distraction of the alliance information.

If I’d designed this chart, I’d have probably coloured the whole bar according to the proposed alliance. I’ve mocked that up below.

coloured-bars

What’s the problem? You can’t escape the colours. You see the colours before you answer the primary question. What the Economist did was keep simple bars that allow the primary question to be answered first. Once that’s dealt with, you can examine the alliance colours and focus on the secondary question.

MakeoverMonday: global shipping companies

12-companies-account-for-80-of-the-global-shipping-industry-with-group
Pareto: do you understand what this is showing?

This week’s original looked so simple, I thought it would take just a few moments to whip up a bar chart. Then I figured that was too obvious. And then I got lost in a fascinating voyage of discovery finding out about the global shipping industry. I never knew capacity was measured in TEU (ie a container). And who can resist looking at images of enormous container ships? Maybe you can, but not me.

Reading about the industry soon pointed out just how dominant those top 20 companies are. Which led me to the Pareto. I’d enjoyed Andy K’s tip on Paretos last week, so they’re on my mind. I don’t actually think we really need a pareto here. In this case, the more compelling view is  the basic bar chart. A simple annotation saying that the top 20 companies account for 90% is enough. It’s easier to read that information than understand it from a pareto.

the-bar-chart
Or is the bar easier and more compelling?

Download my workbook here.

 

#MakeoverMonday: Alan Rickman

Alan Rickman

Just a quick one this week. Alan Rickman’s career was lauded, justifiably, when he died earlier this year. However, I hadn’t realised until tackling this week’s makeover just how much it had been dominated by Harry Potter.

I only have time for a very quick post this week. One thing I did do was to orient the bar chart the opposite way to normal (header on right, bars pointing to the left). Why? Because the photo of Severus was facing to the right – I wanted the makeover to look like Severus was looking at the chart itself.

#MakeoverMonday: Tax Havens

tax havens

$2.1 trillion dollars? We are used to hearing monetary values like that, but what does 2.1 trillion dollars look like? It’s such a huge number, I thought it would be good to relate it to other types of expenditure.

It is astonishing that the offshore money is 2/3 the size of the entire US federal budget.

This weeks source was in need of a makeover. Pie charts aren’t a great way to show this data (read Stephen Few’s classic “Save the pies for dessert” for a great explanation). Making a pie with so many slices renders everything virtually unreadable.

European Disc Golf Championships day 3

l

Loved the battle at the top of the Masters today – Kristian held on so well for 2.5 rounds but just lost it towards the end, allowing Anders to draw level.

Holes change by round
Click for interactive version (and narrow this down by division).

Let’s look at how the holes have changed over the rounds. Is hole 16 the most boring? Sure looks like it: the most pars and very few birdies. Holes 1 and 5 have given up the fewest birdies. 

How about the gold/brown rounds? Here’s team GB. Derek Robins had a difference of only ten between his gold/brown rounds. Well done!

Click for interactive
Click for interactive version to find any gold/brown rounds.

How about some player profiles? Here’s Team GB’s Chris O’Brien who’s been playing brilliantly… over 2 days and had a bit of a shocker today.

Click for interactive version.
Click for interactive version (and to look at any player in the tournament).

 

 

 

European Disc Golf Championships Day 2

Another cracking day, judging by the scores. The leaders were having a good old ding-dong battle. Pasi faded at the end of the second round, but Juho stormed on through:

Leaders

Players clearly learned a new approach on hole 1 today. In round 1, there were around 60 pars and over 100 over pars. Today? More people got par than any other score:

Hole 1 different rounds

Now – what we all want to know is what are our Golden and Brown rounds? The golden round is when you take the best score of each hole and total that. The brown round is the opposite: what’s the worst score?

Here’s a static image, but the interactive version is below:

Golden and Brown

 

Finally well done to Team GB’s junior, Ned Morris, who had a great second round. Look at that steady-as-a-rock run of pars from holes 9-16:

Ned Morris day 2

Ned – don’t worry about bogeying holes 16 and 18. Derek’s done the same in both rounds:

Derek round 2

European Disc Golf Championships

It’s disc golf analytics time! My friends are in Finland at the European Disc Golf Championships. Here’s some analytics for you to explore.

Each screenshot has a link to the interactive version.

First of all – you can compare players against each other. Here’s team GB’s progress through round 1. Chris O’Brian did extremely well, while Derek, Dan, James and Si all ended up within 1 shot of each other:

player battle
Interactive here

How about the holes? Well, hole 1 was brutal. 4 birdies and >100 bogeys or worse. Ouch. Hole 4 was the opposite: 40% of all players birdied it today.

Hole 1. Ouch
Hole 1. Ouch. Interactive
Hole 4. Phew.
Hole 4. Phew. Interactive.

And how did the Open division do in terms of Birdies/Bogeys? Well done Pasi Koivu for getting 11 birdies! Amazing.

Open player birdie/bogey ratio
Open player birdie/bogey ratio