Data Analyst
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…
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…
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…
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…
Looking at the data from Johns Hopkins (https://data.humdata.org/) to see how various countries are doing at the moment with regards to their respective fights against the Coronavirus pandemic. The chart below shows the percentage increase in deaths due to Covid-19 for last week compared to the reports from the week before for countries with >500…
I have continued experimenting with Microsoft Power BI trying to find situations in which it is faster and easier to use than Excel for data visualisation. If I find something faster and easier in Power BI (in which I have <=0 experience), then it really must be a strong use case for the application. Looking…