I clean, analyse and visualise data using Python and SQL, turning raw datasets into findings someone can actually act on.
My toolkit is Python and pandas for cleaning and analysis, SQL/MySQL for querying, Excel for quick checks, and Git for version control. I'm currently building up my Power BI skills to take these projects further into dashboards.
Gloucestershire Crime Analysis · Python, pandas, Matplotlib, Seaborn Cleaned and combined 117,553 street crime records from 24 monthly files into one dataset, then worked through what the numbers could and couldn't actually support.
Retail Sales SQL Analysis · MySQL 14 SQL queries, including a window function for branch-level rankings, turning 1,000 transactions into business findings and recommendations.
Travelling Salesman Visualiser · Python, Streamlit An interactive app comparing brute-force and nearest-neighbour route optimisation, trading a small amount of accuracy for a big jump in speed.