Data Analyst
Today I took a look at the odds for the next couple of rounds of football matches in the Premier League after the international break. I imported the data directly into Excel from https://www.oddschecker.com/football/english/premier-league. I removed the columns of data I was not interested in using Power Query, and split the odds columns in two…
The international break is the perfect time to take a look at the state of the Premier League and the form of the teams with more than three-quarters of the 2020-2021 season completed. All match results and fixtures are available here: https://fixturedownload.com/download/xlsx/epl-2020, downloadable in Excel format. This file gives the round number, match date, match…
I got the Strava data for a couple of my friend’s long runs: a city half marathon from May 2019 and a 16 mile training run (for the London Marathon) from early-March 2020 before the marathon was cancelled. With Excel I tidied up the data and extracted the numerical data of interest. The chart below…
I took a look at the latest Covid-19 daily deaths in English hospitals statistics, available to download from the NHS website here: https://www.england.nhs.uk/statistics/statistical-work-areas/covid-19-daily-deaths/. They include a weekly breakdown by age of those who have lost their lives after testing positive for coronavirus. The Excel chart above shows the number in each age-group who died with…
Looking at some more Concept 2 rowing machine workout data – this time from a sprint/interval session (20 seconds @ 90% of max effort, 1 minute rest, repeat 20 times.)The Concept 2 Performance Monitor only records a line record of data when a stroke is pulled, therefore it does not record anything during the 1…
Getting back into running in 2020 after a slow start to the year and then the first Covid-19 lockdown resulted in some tactical walks being required during runs – particularly as the runs increased in length. The chart below, plotted in Excel, shows the distance and average speed of each of my runs of 2020.…
Today I quickly tried out a few different techniques with Excel to visualise my 2021 running data (up to and including 25th March) – mostly conditional formatting of charts and their data labels to try and show as much information as possible in single charts of different types. The first chart did not turn out…
The Concept 2 ergometer (indoor rowing machine) has a performance monitor which will output CSV files of data relating to individual workouts. Pictured below is a small snapshot of the data contained within these files (I added the Time(mins) column).The machine takes a reading once per rowing stroke and saves a record index value (Number),…
I recently used Power BI to visualise some Coronavirus data for different countries, and conditionally formatting the data series markers was very easy and intuitive. I wanted to try something similar with Excel (no VBA) on my running data to visualise the quality of my runs month by month so far through 2021. I found…
Using the Coronavirus Pandemic Dataset, downloadable: https://ourworldindata.org/coronavirus-data from Our World in Data, I looked at how the number of deaths attributed to Coronavirus is changing for various countries. I selected only those countries which have a population in excess of 2 million, and which had already suffered a total of at least 500 deaths per…