One governed set of numbers for the executive team
A warehouse, semantic layer and dashboard suite replacing departmental reports that disagreed with each other.
Client: Public sector agency (anonymised)
- Certified definition per metric, with a named owner
- One
- Monthly reporting pack, previously assembled by hand
- Automated
- Data freshness, with alerts before review meetings
- Monitored
- Security applied by role and territory
- Row-level
Three departments produced monthly reports from three extracts, using three different definitions of the same core metric. Executive meetings spent more time reconciling figures than deciding anything, and every report cost days of analyst time to assemble.
We built orchestrated pipelines into a dimensional warehouse and, crucially, a governed metrics layer where each metric has exactly one certified definition and owner. Dashboards read only from certified datasets; analysts can build their own views on top but cannot silently redefine a metric. Freshness monitoring flags a stale dashboard before a meeting does.
Technologies used
- Next.js
- TypeScript
- PostgreSQL
- Python
- Redis
- Docker
- Kubernetes
Services engaged
Other case studies
- Utilities2024
Replacing spreadsheet billing for a regional water utility
A full commercial platform covering meter reading, tariff calculation, invoicing and mobile money collection for a utility serving tens of thousands of connections.
- Next.js
- TypeScript
- Flutter
- Node.js
- Services2024
Consolidating HR and payroll across distributed sites
One employee record and one payroll run replacing site-level spreadsheets and a legacy payroll package.
- Next.js
- TypeScript
- Node.js
- PostgreSQL
- Financial Services2025
Automating document intake with AI-assisted extraction
A retrieval and extraction pipeline that reads application documents, structures the data and routes uncertain cases to a human reviewer.
- Next.js
- TypeScript
- Python
- PostgreSQL
Recognise this problem?
If any of the above sounds like your operation, a short discovery conversation will tell us both quickly whether there is a fit.
Or email walter.mussagy@gmail.com — we reply within one business day.