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. The dashboard is best viewed on my Tableau Public page.
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 hardest part was actually loading the data into MySQL. Firstly, 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 safety. This dashboard presents data on stop and searches in 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 question: Below are presented summary statistics of the answers given. 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 FTSE Women Leaders for sex. All this requires some sort 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, in terms of its things like its loudness, tempo, and 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 from Alex the Analyst, and I wanted to try out Read more…