Launch, grow, and unlock your career in data

September 18, 2017

Makeover Monday: A Day at the Races

As Eva already outlined, yesterday was race day for both of us. While she was at the Age Group Sprint Distance World Championships in Rotterdam, I was running the Richmond Marathon in preparation for the Frankfurt Marathon at the end of October.

Given there's also the #FitData17 challenge we thought we'd give everyone some data to play with.

I'm going to be making over my results from Strava.

What works well?

  • Of course no run is good without a map.
  • Including a breakdown of my pace for each mile
  • Showing a timeline along the bottom and allowing me to customize the metrics

What could be improved?

  • There are no markers on the map to show me where I started, ended nor any mile markers along the way.
  • The table shows me my pace, but it doesn't add any value because I can't see all of the miles at the same time making spotting trends impossible.
  • The line chart has three separate metrics showing, yet only one axis. It doesn't make sense to overlap three metrics.

What I wanted to learn?

  • Is my 3:25 goal for Frankfurt achievable?
  • Is there anything interesting in the heart rate data?
  • I want to be able to compare the key metrics across the two races.
  • Is hitting "the wall" avoidable?

I must admit that I need to dig into this data further in order to be able to answer these questions. However, time is running out on the day and I won't have time to look at it more tomorrow, so I'm starting with a viz that does some simple comparisons. It'll have to do for now and it certainly improves upon the original.

Click on the image for the interactive version.

Click on the image for the interactive version


  1. Hi Andy, what did you type when creating the calculated fields for the avg. speed/ pace per mile?

  2. where can i download this workbook?

    1. Click the download button on the footer of the viz