Projects

Every dataset gets the same discipline.

Ask a sharp question, clean the data, test the obvious answer — then say what should be done. Four investigations, each one clickable.

01

Public health · IDSS2 dataset

The sixteen-point gap nobody had mapped

Five diseases, 500 case reports, and a recovery-rate spread wide enough to be a policy problem — not a medical one.

EDADemographic analysisPolicy reportingExcel
02

Education · 5,000 student records

The model that was too perfect

A regression came back with R² = 1.000. Instead of celebrating, I went looking for the leak — and found it.

RMultiple regressionHypothesis testingEDA
03

Retail analytics · synthetic sales data

The weekend effect, and the Tuesday problem

A four-panel dashboard that explained why revenue swung across the week — and what to do about the mid-week slump.

ExcelDashboard designFeature engineeringPivotTables
04

Small business · spreadsheet engineering

A ledger that does its own math

A formula-driven sales log that turns a shop owner's daily entries into live revenue and profit — with no manual arithmetic anywhere.

ExcelAdvanced formulasAutomationPower Query