Retail Business Analytics Case Study — SQL & Python
Published:
A business analytics case study for Matrix Manufacturing & Retail (MMR), a fictional bicycle retail company, developed as the final project for a Level 4 Data Analytics Bootcamp, Gateshead College (Distinction, 2026).
Going beyond the original brief, I designed a synthetic relational database from scratch in MySQL. This included custom variables not present in the source data — and implemented a full data pipeline from database creation through SQL extraction and transformation to Python analysis and business reporting. The final 10-page report addressed four business questions around product performance, seasonal sales trends, and customer loyalty across six UK locations, framed around real business KPIs and a structured data strategy including GDPR considerations.
Tools: MySQL Workbench · Python (Pandas, Seaborn, Matplotlib)
Methods: Relational database design
- SQL querying and normalisation
- Descriptive and diagnostic analytics
- Data visualisation
- Business reporting