30 Days of Maps Day 15 - My data

Half way there! Day 15 of the #30DayMapChallenge and today's theme is "My data" - Map something personal. Map data from your own life—this could be places you’ve traveled, your daily routine, or any other personal touch.

For this challenge I needed some personal data so I requested an extract of all my data from Strava. Whilst I used to be a keen mountain biker, most of my recent activity has been riding with the kids, but there are still plenty of rides that I've recorded. The data extract from Strava contains a folder of all my rides in GPX format - one file for each ride, so I used PowerQuery's folder data source and merged all of my rides into a single table inside of Power BI - one row for each point along each ride. Within a couple of minutes I had a table of data with nearly a million rows of data. I really can't stress enough how quick this was!

I applied my usual DAX pattern that uses a measure to concatenate each point and turns them into a single linestring in WKT format - one of each ride. Adding this into Icon Map Pro meant I was able to visualise all of my rides ever in Power BI. I added a table at the bottom pulling out a few extra bits of meta data, and I was quickly able to zoom in and view each ride. Finally I added a line chart to show the elevation of each ride, using a DAX measure to only show the line when a single ride is selected.

Within less than 10 minutes I'd created an interactive report allowing me to analyse nearly a million data points. With more time there's loads more that could be done with this to add real value, calculating speed and average stats by year, month etc.

For privacy, I've restricted to the report to just a few rides in Wales, but it's enough to get the idea.

If you'd like to see how the report was built, you can download it here.