Local government
Newham Council
A clean, consistent foundation that reporting and the gold layer can be built on.
- Client
- Newham Council
- Sector
- Local government
- My role
- Data architect, bronze and silver layers
Context and challenge
Council data lived in separate systems, each with its own format and gaps, so no one could build reliable reports on top of it.
What I did
I built the bronze and silver layers of the data platform. Bronze keeps each source as it arrived. Silver cleans and standardises it under agreed rules, so every later report starts from the same trusted data.
Solution
- 01
Kept every source as it arrived
The bronze layer holds each system's data untouched, so nothing is lost and every figure can be traced.
- 02
Cleaned and standardised it
The silver layer applies agreed rules: one format, duplicates removed, gaps handled.
- 03
Prepared the ground for reporting
Reports and the gold layer start from the same trusted data.
Impact
A clean, consistent foundation that reporting and the gold layer can be built on.
More work
Tell me where the data hurts most.
A 15 minute call. I will tell you honestly whether I can help.