Selected work

An analytics portfolio with the working left visible.

These case studies start with a decision, show the dataset and analytical approach, and end with a recommendation. They are designed to demonstrate business analysis capability without implying client delivery.

Every project is explicitly labelled as a synthetic portfolio case study.
01

SQL projects

Decision-ready analysis built from relational data, clear definitions and reproducible queries.

2cases
02

Python projects

Exploratory analysis, prediction and operational modelling translated into commercial actions.

2cases
03

Python + SQL projects

End-to-end analytical workflows that join, validate, model and communicate business data.

2cases
04

Marketing dashboards

KPI systems designed around decisions, not decoration: acquisition, conversion, efficiency and value.

2cases
05

Business writing

Structured recommendations, executive briefs and requirements documents for time-poor stakeholders.

2cases

All case studies

Ten decisions. Five analytical formats.

Synthetic case studySQL

Retail margin & discount leakage

Which sales look healthy until discount and cost are included?

A reproducible gross-margin diagnostic that separates top-line growth from value-destructive discounting and identifies where commercial controls should change.

£463k
analysed revenue
40.6%
gross margin
33.7%
margin on 15%+ discount orders
View full case study
Synthetic case studySQL

Tender pipeline & bid/no-bid analysis

Where should a constrained bid team spend its next week?

A bid-performance model that turns a pipeline list into a decision queue and separates attractive opportunities from expensive distractions.

36.8%
submitted-bid win rate
£92.2m
open pipeline
19.9d
average submission window
View full case study
Synthetic case studyPython

Customer churn risk prioritisation

Which customers need intervention before the renewal date?

A practical classification workflow that balances predictive performance with the commercial need to explain who is at risk and why.

0.694
ROC-AUC
15.2%
base churn rate
75.8%
churn in highest-risk decile
View full case study
Synthetic case studyPython

Demand forecast & reorder policy

How much stock protects service without locking up cash?

A six-SKU forecasting and safety-stock model with a transparent holdout test and a simulated operational impact check.

22.3%
holdout MAPE
90.9%
simulated stockout reduction
318
highest reorder point
View full case study
Synthetic case studyPython

Executive sales KPI pipeline

Can leadership trust the number before discussing the trend?

A small analytical pipeline that removes duplicate orders, standardises channels, filters business-valid revenue and exposes an auditable customer-level mart.

47
duplicates removed
3,171
valid completed orders
£346k
governed revenue
View full case study
Synthetic case studySQL

Customer 360 & retention queue

Which valuable customers are becoming quiet?

A relational customer mart and RFM-style prioritisation layer that connects value, frequency and recency to an actionable outreach queue.

134
high-value at-risk customers
40.9%
revenue from top 20%
5
joined source fields
View full case study
Synthetic dashboardDashboard design

Paid media ROI command centre

Where should the next £10,000 of budget move?

An executive-first marketing view that links spend to conversion and revenue, while keeping diagnostic channel metrics one level deeper.

2.66x
blended ROAS
3.37x
best channel ROAS
1.14x
weakest channel ROAS
View full case study
Synthetic dashboardMarketing funnel

Event acquisition & member conversion

Which promotion fills the room and grows the community?

A student-society marketing dashboard that traces awareness through attendance to membership and exposes channel efficiency.

80.0%
show-up rate
20.5%
attendee-to-member
£2.33
cost per member
View full case study
Synthetic writing sampleExecutive writing

Board memo: sustainable office furniture

A one-page recommendation for an ambiguous market-entry decision.

A concise board-style memo that converts scattered market assumptions into three options, explicit risks, a recommendation and 90-day next steps.

3
strategic options
5
decision criteria
90d
pilot horizon
View full case study
Synthetic writing sampleRequirements

CRM renewal requirements brief

Aligning sales, marketing and operations before software selection.

A structured BA deliverable that links stakeholder pain points to prioritised requirements, process impacts and testable acceptance criteria.

4
stakeholder groups
12
prioritised requirements
6
acceptance criteria
View full case study