LarenwayStart a project
Selected work

Case studies from the hard yards.

Anonymised, because the interesting work happens inside regulated, data-heavy organisations. The pattern is the same each time: the data existed — it just wasn't driving anything.

Insurance

Month-end close ran on 40+ spreadsheets across three finance teams — with three different answers to "what did we write this month?"

What we did — A governed Snowflake warehouse, dbt models for a single premium ledger, and Power BI reporting the whole business reads from.

72%
faster close
1
source of truth
40 → 0
spreadsheets in the close
Logistics

Depot performance data landed fortnightly by email, so route problems were spotted two weeks after they'd already cost money.

What we did — Fivetran pipelines from telematics and WMS into a live operations layer, with exception alerts routed straight into Teams.

14 → 2
days to see a problem
−9%
empty running
24/7
exception monitoring
Public sector

Casework reporting to the board took four analysts a full week each quarter — copied by hand from five line-of-business systems.

What we did — Automated the quarterly pack end-to-end: one governed model, generated commentary, and a live dashboard between board dates.

5 → 1
systems reconciled
1 wk → 1 hr
to produce the pack
0
manual copy-paste steps

Results are illustrative — figures anonymised and rounded from representative engagements.