Data Analyst
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…
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…
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…
Having previously read in the BBC weather forecasts from the web using Power BI, today I attempted to read in and process the latest betting odds for the next 14 matches of Premier League football from https://www.oddschecker.com/football/english/premier-league. Initially it seemed like a very simple task, but then it turned out that the oddschecker.com sometimes changes…
Returning to Chess.com data (see here: http://www.neilmcniven.co.uk/3-conditional-formatting-of-bar-chart-colours-on-other-columns-of-data/), I had collected and saved all of my chess puzzle data from 29th Dec 2020 until 15th Jan 2021. Each day had its own CSV file looking like the one imaged below. Each row gives the date, puzzle rating, number of moves correctly made out of the target…
Continuing to look at Power BI, I decided to see how easy it is to import raw data from the internet in the form of web page tables, and get useful information visualised from it. I chose to use the BBC Weather website page for my location. Six tables were automagically found on the webpage,…