15, 000 km of Running: Analyzing my STRAVA Data with SQL

Visit my site to check out some of my hobby projects: https://www.lazydatadev.com

In this video, I'm using SQL to analyze my Strava data. More specifically, this is what was explored and most of it is not available in Strava's dashboard:

0:00 Intro
2:20 Total running distance by year
5:00 Countries in which I have any activities
6:37 10 longest runs
10:38 TOP 3 longest runs by year
14:27 bucketed count of runs by distance - 5km ; 5 - 10km ; 10 - 15km; 15 - 21km; 21 - 42km; 42+
19:00 The month in which I covered most distance
21:45 TOP 3 fastest 10km
26:13 TOP 3 fastest half-marathons
27:15 TOP 3 fastest marathons
28:18 Double run days
30:47 David Goggins' challenge 4 x 4 x 48

I used a Python script to fetch my Strava data, for more information, check out this video: https://youtu.be/E5fQgz2sn20

If you have questions or ideas for future videos, just leave a comment below.
And if this was useful, please like the video and consider subscribing for more Excel, VBA and Python data automation and analytics tutorials.

Видео 15, 000 km of Running: Analyzing my STRAVA Data with SQL канала LazyDataDev