Dashboard Week - Pirate Andy & How to make Sense of your Runkeeper Data

by Anuka Teggart

Dashboard Week

WEDNESDAY

 

This time Andy has decided to harness DS2’s collective brain power for his own ends by having us go through copious amounts of his worryingly meticulous exercise data from the popular app Runkeeper. What have we learnt? That these apps commonly record their data very annoyingly as a separate gpx file (new file type!) for every single tiny part of your journey resulting in thousands for every run! This was certainly a task in alteryx and choosing what to focus on in this sea of data proved to be even more difficult.

Alas, due to the impending deadline (the end of the day), I decided to simplify my idea from being the greatest viz on quantified self anyone has ever seen to something more realistic (a common theme I’ve found). The simplification was to focus on finding out Andy’s best runs of all time, filtered first by distance then by pace. I used the workflow below (with Andy’s help!) to find the top 10:

 

andy run flow

Where the summarize tool is is where the process to find the top 10 actually begins. The first half was simply to join the gpx run data with Andy’s personal exercise data (weight fluctuation etc) and to clean it up a bit. The summarize tool was used to group by file name and create average distance and pace columns for every file name (i.e. run as each run had the same file name which essentially combines all the tiny run parts into one – gotta love the summarize tool). The columns are filtered by distance then pace and the top 10 were selected using the sample tool.

I decided to visually represent Andy’s best runs with a map. Now, I had been waiting for an occasion just like this to finally use my favourite map from mapbox, the Pirate Map! Then I thought, why not continue the theme throughout the viz? Hence why I created these highly flattering images of Andy below using the app iArrPirateFree.

12607146_1690319434519701_801613952_n12625765_1690318351186476_798247957_n

 

 

 

 

 

 

 

 

 

 

 

 

 

To create the map, double click latitude and longitude, change to a line map and put datetime on line. Remember to right click datetime and change to ‘Exact Date’ and the rest is formatting. To see how to use a map from Mapbox in Tableau, read my next blog on Mapbox 🙂  Overall I’m happy with my viz, I really enjoyed the chance to make a light-hearted and playful viz and think the pirate theme works really well and methinks I’ll use it again in the future 😉

 

Andy's Top 10 Runs of All Time

As always, thank you for reading!

Anuka

#TipWeek: Bar-in-Bar Charts - Great for comparing two things

2 mins read

Fri 19 Feb 2016

#TipWeek: How to Colour Tabs in Tableau

1 mins read

Thu 18 Feb 2016

#TipWeek: Tableau Server Tip - Run tabadmin and tabcmd from anywhere on your computer

2 mins read

Wed 17 Feb 2016

#TipWeek: Calculating Z-scores to Test Significance in Tableau

2 mins read

Tue 16 Feb 2016