Back to all work

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

  1. 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.

  2. 02

    Cleaned and standardised it

    The silver layer applies agreed rules: one format, duplicates removed, gaps handled.

  3. 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.

Bronze layerSilver layerData cleaningStandard rules

Tell me where the data hurts most.

A 15 minute call. I will tell you honestly whether I can help.