Data Analyst
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…
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,…
Chess.com offers puzzles to help people to improve their chess playing skills. The stats relating to the last 25 puzzles completed by any user of the website can be see online here: https://www.chess.com/stats/puzzles/PLAYERUSERNAME , as shown below. I copied a table of this data, dropped it into an Excel worksheet, and added an index column…