Are you an avid cyclist who regularly uses Strava to track segments and claim K/QOM? Are you a data fiend that yearns to analyze and manipulate fitness tracker data in Alteryx for visualization in Tableau? Well, now you can! In this two-part series, I’ll detail the process I used in analyzing my recent OK Freewheel journey.
Step 1: Export GPX Files
To begin, export your data into GPX files by referencing this article from Strava. To keep things modular, I chose to export each segment individually for bulk processing in Alteryx:
Step 2: Get Turnt Up!
Fire up Alteryx and point an INPUT DATA tool to your GPX files by using a wildcard search. In this case, I used .OK*.gpx and specified XML as the file format. I also chose to include file names as a field to keep everything organized:
What you’ll get is a table containing latitude / longitude coordinates, elevation (meters), date, time and file name:
