Launch, grow, and unlock your career in data

July 10, 2017

Makeover Monday: The History of Le Tour de France

Tough data set for me this week as I know nothing about cycling. In addition, I raced this clock this week and completed Makeover Monday in an hour with the Data School. We then all presented our work back to Eva.

If you're particularly bored, here's a recording of my screen for the whole hour.

Ok, still awake? Hopefully you enjoyed my Spotify playlist at least. This week's viz that we're reviewing is knomea.

What works well?

  • Clear titles
  • Line chart is easy to understand

What could be improved?

  • Don't use dual axis area charts and not make it clear which is which
  • The dual axis chart implies correlation when there may or may not be any.
  • Why the blue background? This makes me think it means something.
  • Labeling the axis every 33 years is a bit odd (pun intended)
  • The connected lines make it look like race occurred during the World Wars.
  • Tell more of a story. When I ask "so what?", I can't answer it.

I'm pressed on time, so here's my Makeover Monday week 28. Enjoy!


  1. Great work Andy! It would be interesting to see how average speeds on commonly ridden mountain passes has changed over the years (i.e. Ventoux, Ausbisque, Alpe d'Heuz, Madeleine, Tourmalet, Galibier, etc.). I think performance on the major climbs over time would say a lot about how rider fitness, bike technology and potentially PED usage has changed over time. I don't know how accessible that kind of data would be, but it would interesting to see.

  2. Very nice. I really like the 'story commentary' pointing us to the important facts.

    Can I ask why the % Finished chart doesn't have the gaps during the war years that the others had?
    Is it a factor of using a 10 year rolling average for that line?
    Something you might have looked at had you had more time?

    Thank you

    1. Yes, it's the 10 yr avg that is preventing the line from breaking up. I ran out of time to figure out why it didn't work. Thanks for asking!