Case studies
Hands-on analytics projects — each one a full write-up on Substack covering the data, the questions, and the decisions behind the dashboards.
Bank Customer Analytical Overview
First end-to-end analytical project using Microsoft Excel to explore and report on bank customer data.
Read Case StudyDanny's Pizza Sales
Second Excel analytical project examining sales trends and performance using pivot tables and dashboards.
Read Case StudyAnalysing Employee Data at Splendor Investments
First SQL project — from writing queries to building a dashboard analysing employee data.
Read Case StudyFrom SQL Queries to Excel Charts: Brewery Data
Analysed three years of brewery data using SQL queries, visualised through Excel charts.
Read Case StudyPharmaceutical Sales Across 4 Years and 2 Countries
First Power BI project analysing multi-year, multi-country pharmaceutical sales data.
Read Case StudyBeyond Drag and Drop: A Workforce in Crisis
Used DAX, Power Query, and Power BI to uncover deeper workforce insights beyond basic reporting.
Read Case StudyCar Sales EDA
Exploratory data analysis of car sales data using Python, pandas, and seaborn to uncover patterns in pricing, mileage, and buyer behaviour.
Read Case StudyStudents Performance
Exploratory analysis of student academic performance using Python, pandas, and matplotlib to understand CGPA distributions and grade-class patterns.
Read Case StudyDietician
Python analysis of client diet and health data to evaluate diet-type effectiveness, calorie targets, BMI distribution, protein intake, and activity alignment.
Read Case StudyWhat 10,000 Rides Taught Me About Ride-Sharing (And Why Surge Pricing Isn’t Doing Its Job)
An Excel dashboard analysing 10,000 ride-sharing trips to explore demand patterns, driver ratings, and whether surge pricing actually matches customer behaviour.
Read Case Study