Here is a chart to show the nights (midnight-6am) in a row when my heart rate was below 50 beats per minute.
Data Analyst
Category: Data Visualisation
Monthly WMA Run Analysis – Jan20 to Oct22
Here is a visualisation of my WMA (age-graded speed measure) for my runs between January 2020 and October 2022. The top of the green bars shows the maximum WMA achieved each month, the bottom of the red bars the lowest WMA run each month, and the average WMA is shown by the point where the…
English Premier League Table (before World Cup 22 break)
Looking at the results in the English football Premier League as we hit the break for World Cup 2022 on 13th November 2022. Matches shown for each team as green for a win, amber for a draw, and red for a loss (raw match result data from https://fixturedownload.com/results/epl-2022):
Analysis of Distance Run per Week – 2019 to Oct 2022
Here is a chart to show the number of calendar weeks when I ran a particular total distance. 10km indicates a total distance between 7.5 and 12.49km, 15km, a total distance between 12.5km and 17.49km, etc. Click on the chart to view in full resolution.
All Run Distances Jan-19 to Oct-22
Here are all of my run distances from the period January 2019 to October 2022. Click on the table to view full size. To generate the monthly sorted list of distances run, I used the following:
Quick Look at 10km+ Runs from 2021
Since the start of 2021 I have run 10km or further 66 times (as of 21st July). The chart below shows the speed of these runs (in km/h). Click on the image of the chart to view in full resolution. In April and May I was running my easy/recovery/long runs a bit too fast, but…
Growth in Worldwide Coronavirus Cases 8th July 2021
Below is a chart to show the growth in the number of reported Covid-19 cases for all countries reporting >10,000 new cases in the last 28 days. “GROWTH” measures the increase in the number of reported cases of the last 7 days relative to the first 7 days of the 28 days leading up to…
Growth in the Growth of UK Covid Cases – 01Jul21
The chart below shows the weekly percentage growth in the number of cases of Covid-19 detected in the UK. On the second axis it shows the 7-day rolling average of the number of daily cases. It certainly looks as though we will be seeing 50k new cases detected per day before the end of July…
Processing Garmin Watch 24/7 Heart Rate Data in Excel
My Garmin Forerunner 245 watch records my heart rate, stress levels, steps, activities, sleep, location, and much more throughout the day. The resulting data can be viewed on the associated Garmin mobile phone app and via the Garmin Connect web service. The watch is a fantastic piece of technology, but there is no way to…
Visualising Sleeping Heart Rate Data – Power BI
I have collected my heart rate data for the last 7 months from my sports watch. In order to visualise trends, I have used Excel to bin the data in 5 beats per minute intervals. Below shows this data for the first five hours of sleep for each day. Again in Excel I made the…