A personal project to surface play history insights from an encrypted proprietary database,
using AI-assisted research, SQL querying, Python scripting and XML manipulation
to build a practical DJ library management tool.
Built a production ETL pipeline for Herd, merging historical ranking data with a new tracking platform for one of the world's leading airlines and hospitality brands.
Analysis of ride volumes 2018–23 across 11 recording sites based on 1.2 million data points & +80% daily completeness over a continuous 6 year period.
A comprehensive analysis of 206 UK festivals in 2025, combining web scraped festival data with 30 years of historical weather patterns to provide insights and predict optimal festival experiences.