For week 38 we challenged the community to analyze and visualize our race data, which we produced on Sunday as Andy ran the Richmond Marathon and I competed at the Sprint Triathlon Age Group World Championship in Rotterdam.
This meant the data came out late on Sunday, as I only finished my race at 4.30pm and had to wait to collect my bike and wetsuit from transition, make my way back to the hotel, download the data, tidy it up and upload it and of course coordinate with Andy as he got his data ready.

So thanks everyone for being patient on the timing.

I published the original vizzes and some accompanying information on our blog. And that is where we get started with Lesson 1…




This lesson is not for you, but for Andy and me (mostly me this time, as I wrote that blog and it was my week for MM).

We clearly were not clear in our communication. We provided background information to give people a helping hand if they wanted to find out more about marathons and triathlons and the KPIs people look at when training for such races. So far so good.

We also included a fairly long list of questions and comments around the things we were interested in finding out based on our data.

That’s where I failed to state that answering those questions was COMPLETELY OPTIONAL.

As Monday came and went there were hardly any submissions and on Tuesday it was still just a ‘slow trickle’ of vizzes. None of the regulars had posted anything yet and I was getting really worried that we had missed some secret agreement the community made to just not participate this week. So we asked around and it turned out that some people were put off or intimidated by those questions and saw them as requirements to be addressed.

Nooooooooo! Our intention was to give people guidance in case they didn’t know which direction to take their analysis. And for our own benefit, we hoped we’d get some answers that would help our training and our race performance.

We tried something different this week and it didn’t work out the way we expected. Most of that can probably be alleviated by communicating more clearly, so my apologies if you felt put off or overwhelmed by the questions we posted. Don’t be discouraged, we were simply trying to give guidance to those who wanted to do ‘more’ than a makeover. We didn’t expect people to go through the entire list and answer each question.




Ummm, this is another one for Andy and me. This week’s dataset was challenging. The topic was different but our community can handle different topics, they’ve proven that to us many times this year. Beside the topic, however, there were additional challenges in the fields contained in the dataset.

In the dimensions we had fields including Path ID, which is a field containing data from each point at which a GPS signal was recorded by our watches.

In the measures, there was a whole lot more. We had velocity, distance, speeds, moving time, heart rate, cadence, etc. This is very different from sales, profits, number of records.

In Tableau, working with duration and time is not straight forward. And understanding the definitions of these fields isn’t necessarily intuitive. Andy and I have worked with this data for months as we’re testing the Strava Web Data Connector that is being developed by Tableau. You guys don’t have the benefit of that background information and I failed to provide a link to additional resources. You could argue that the community is well capable of doing a google search and I completely agree, but we may have been spoiling you by providing simpler and more self-explanatory datasets in the past, so the lesson for me here is to give more background information, including this link to the Strava API documentation which defines each of the fields:

To make the data set really useful and have all the necessary fields for analysis, additional calculations were required and Andy and I agree that we should have provided those calculations. In all honesty, there just wasn’t enough time, but here are a couple if you’re interested…

  1. Duration = [Time]/86400   This divides the time which is given in seconds, by the number of seconds per day. The resulting duration field can be formatted by changing the Number Format to Custom and typing ‘hh:mm:ss’ into the text box
  2. Speed = [Velocity] * 3.6   This turns velocity (meters per second; location dependent) into speed (km per second; location independent). For miles per hour use *2.24. Then change the aggregation to ‘Average’ rather than Sum, because otherwise you will get the sum of each data point (each Path ID), which is incorrect.


Andy also called out Jonathan Drummey’s excellent blog as a resource for duration calculations in Tableau, so check it out.


There are also a couple of lessons for the community from this week’s challenge, so let’s move onto




We’re here to help and we run this project for the community. If you have questions, please ask us anytime.

Yes, there are questions to which you can find the answer quite easily by doing a simple google search, and then there are other questions which we can certainly help you with. If you’re unsure of how to tackle the challenge, just ask. If you want to understand what a certain field means, let us know and we’ll clarify.

Not only will this help you with your analysis, it is also good practice for business analysts in general. Asking questions and challenging the status quo is what we’re here to do. Don’t hesitate, just fire away.

Frederic Fery did that and he got the answers he needed:



Sometimes little errors sneak up on us because we don’t sense check our results. Now I don’t expect people to know what my average running speed should be. A quick check for reasonableness is possible though. Is it likely that I’m running at 30km/hr or that Andy completed his marathon at 3.2km/hr? Not really.

Both authors fixed it though when we pointed it out, so well done on taking the feedback on board:

Ian initially had the speed in meters per second and the alignment suggested that I was running at over 31km/hr

He made the relevant updates after we gave him feedback and the alignment and units are much more intuitive and clearer now

Francis had simply not turned the meters per second into kilometers per hour, so the labelling suggested that Andy was running his marathon at a pace more appropriate for someone twice his age 😉

A quick clarification later, he implemented the changes and updated his workbook

Following those 4 lessons, let’s look at this week’s favorites…





Author: Suraj Shah
Link: Tableau Public

What I like about it:

  • Stunning design!
  • Great context provided above the chart to inform the audience and explain the detail of the dashboard below
  • Annotations show that Suraj considered the questions Andy was interested in finding answers to and they also call out interesting points in the race
  • Great colour choices and clean design
  • Nice use of BANs to call out KPIs

Author: Michael Mixon
Link: Tableau Public

What I like about it:

  • Fantastic interactivity and tooltips that make exploring fun!
  • Great overview of both races, I really like the gantt chart for its sequential view of each race
  • Clean design
  • Great custom maps which give context and let me explore data points from the line charts at the bottom at their specific location on the course

Author: Eric Severson
Link: Tableau Public

What I like about it:

  • Great context and explanation of drafting in cycling
  • The annotations are spot on and really point out the key observations Eric made
  • His analysis is very accurate, I was in fact drafting during those sections
  • Great colour choices

Author: Neil Richards
Link: Tableau Public

What I like about it:

  • I hoped someone would do a pace calculator because the stuff that’s out there is very uninspiring. A quick google search gives you this very disappointing top result
  • Great mobile-friendly design
  • Interactivity and exploration is encouraged
  • Compared to standard pace calculators this one actually shows not just the target pace for a desired finishing time, but also how well Andy did in his previous races with relation to that target time, i.e. how realistic and achievable is the target time based on past performance
  • Nice and simple design and colour selection

Author: Brian Harris
Link: Tableau Public

What I like about it:

  • The design, font choice and colours are outstanding!
  • The annotations and notes add great context
  • I really like the combination of velocity (could use speed in km/h here which is easier for me to comprehend) and heart rate because they are related and make the drafting sections more apparent
  • The concluding remarks at the bottom are a great way to summarize

Link: Tableau Public

What I like about it:

  • A simple, mobile-friendly viz that gives me the KPIs for the viz
  • Great use of the map
  • Nice interactivity with actions
  • The line chart at the bottom gives me some nice context, looking at the speed over time for each leg of the race