Analyzing Strava Data: Part 1 – Exporting and Parsing Segments with Alteryx

Data

Analyzing Strava Data: Part 1 – Exporting and Parsing Segments with Alteryx

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:

Individual Export of GPX Files for 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:

Alteryx Input Data

What you’ll get is a table containing latitude / longitude coordinates, elevation (meters), date, time and file name:

Alteryx > Results – Input Data (1) – Output” src=”/wp-content/uploads/sites/default/files/blog-content/StravaAlteryx3.png” style=”border-width: 0px; border-style: solid;” /></p><p>What you’ll quickly notice is that Strava tracks progress at a very granular level (seemingly, every other second). In the interest of keeping data set sizes small, we’ll compress this data set in Alteryx while maintaining data integrity. I’ve attached a screenshot of what my final workflow looked like. Check the bottom of this post for the actual Alteryx workflow, and stay tuned for Part 2 where I showcase how to visualize this data in Tableau!</p><p><img alt=

More About the Author

Jubail Caballero

Analytics Consultant
Alteryx Tool Spotlight: Compare Values Across N Groups with Dynamic Replace Imagine you are supplied financials from multiple vendors and have the wonderful task of comparing them to each other? With two ...
Alteryx Batch Macros – Email Customized Reports to a List of Users Have you ever had the pleasure of emailing customized sales reports to 25 regional managers? How about 100 customers? It probably took ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072