Case studies in data systems, evidence workflows, and reporting support

A national local government review needed one defensible route from public submissions to drafting and later consultation review. Inputs arrived in mixed formats, specialist scrutiny was high, and the team could not afford to lose the line from source text to claims, themes, and policy language. The system also had to support more than analysis: it needed to feed drafting, survive public consultation, and keep later review comments visible instead of letting them disappear into tracked changes.

Result: Built the working system behind evidence capture, synthesis, drafting support, and coded review for the February 2026 draft White Paper and the finalisation process.

A primary contractor on a UNICEF child poverty report project in Zambia needed to turn 120 narrative case studies on female-headed households into reporting-ready evidence without losing consistency or traceability. The existing process was slow, theme handling varied from analyst to analyst, and the team needed outputs that non-technical writers could use under review. The fix had to work in spreadsheets, not in a specialist setup only analysts could run, and it had to leave the team with a handover-ready workflow they could keep using after delivery.

Result: Cut analysis time to about 15 minutes per case and saved an estimated 120 analyst hours across the study.

A primary contractor on a UNICEF report project in Palestine needed to recover a delayed situation analysis fast enough to salvage the delivery window. Raw qualitative material was scattered across interviews, notes, spreadsheets, and draft sections, yet the final report still had to meet UNICEF expectations on methodology, ethics, safeguarding, limitations, and evidence-linked recommendations. The team needed a system that could organise evidence for retrieval, analysis, and drafting at the same time, not a slower workflow that forced writing to wait for full manual review.

Result: Recovered a delayed situation analysis and delivered a UNICEF-ready draft within three weeks.