Here’s my Tableau Dashboard based on the trade data that I analysed in Part 1 using MySQL. It’s a nice feeling to go from an unworkable text file to a fully functioning dashboard that makes the data so readily accessible. Read more…
I wanted to do something in MySQL with a large-N dataset. Raw data at the level of individual imports and exports can be acquired from the British government here. Data are for August 2024. The first problem, in fact, the Read more…
Stop and search remains a contentious issue. Critics argue that its use falls disproportionately on ethnic minority groups and that it is evidence of institutional racism within the Metropolitan Police. Others argue it is necessary in order to provide greater Read more…
This Dashboard is based on the Sample Superstore data set provided by Tableau. It is data for a fictitious retailer and is used widely for training purposes. Here’s my take.
People get their news through a variety of sources while the town crier is a distant memory, wheeled out only for fetes. But can we identify patterns of consumers through survey data? The World Values Survey 2022 contains the following Read more…
What are the national or ethnic origins of FTSE 100 companies? There has been a concerted effort from policy makers, influencers, and vested interests to force the diversification of company boards, spearheaded by the so-called Parker Review for race and Read more…
The data set used for this post consists of 15,150 classic hits from 3,083 artists, from around 1900 to 2023. Because they are taken from Spotify, they also contain a series of variables that describes the quality of the music, Read more…
This post was written using the yfinance library for Python as well as pandas and matplotlib. yfinance allows you to access Yahoo Finance’s public APIs to get data on companies. I’ve just started learning python, having taken some excellent courses Read more…