Data Analyst
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…
Our World in Data have a comprehensive Coronavirus Pandemic downloadable dataset available in Excel, CSV, and JSON formats. I read the Our World in Data have a comprehensive downloadable Coronavirus Pandemic dataset available in Excel, CSV, and JSON formats. I imported the CSV datafile directly from the web into Power BI, pre-processed the data a…
Pictured below is a chart to show the numbers of positive Covid-19 tests and deaths attributed to Covid-19 in Jordan between the dates of 1st Sept 2020 to 17th March 2021.(Data sourced from the Our World in Data Covid-19 Dataset: https://ourworldindata.org/coronavirus-source-data, and processed with Excel.) Click on the image to view in full resolution. The…
Which are the Premier League football teams currently in form?I imported the Premier League table from https://www.bbc.co.uk/sport/football/tables into Excel via Power Query and used some M code to find the number of points earned by each team in their last 5 matches played (Last5Pts). I then calculated the league position for each team if it…
Below is a table to show how Covid-19 is affecting various countries – those which have suffered >200 deaths in the last 7 days (as of 14th March 2021). Some countries were not included in this dataset from https://ourworldindata.org/coronavirus-source-data including major nations such as USA, and countries suffering at the moment such as Czechia. Looking…
Returning to the theme of my post looking at Chess.com player’s puzzle score data analysis, this time I imported the data directly from Chess.com into Power BI via Power Query with much greater ease than when I had copied and pasted the table of data into Excel, pre-processed it there, saved it as a CSV…
Below is an Excel chart to show the 7-day rolling total distance that I have covered running from the start of 2019 until today (11th March 2021). 30km or more in 7 days is highlighted with bold white font, and 37km or more in 7 days is highlighted in bold yellow font. Dates shown in…