Back to all work

Housing software (SaaS)

Haven AMS, stock condition and compliance for social housing

The full medallion architecture on Microsoft Fabric: survey, issue and compliance data from the platform turned into one reviewed source for reporting.

Client
Haven AMS, stock condition and compliance for social housing
Sector
Housing software (SaaS)
My role
Data architect, full medallion build

Context and challenge

Haven is a SaaS platform where housing teams capture surveys, inspections and compliance evidence on site. The data covers properties, components, hazards, issues and certificates, and landlords need answers from it: stock condition, Decent Homes position, open hazards and overdue compliance. The reporting had to come from one trusted source, not from separate extracts that disagree.

What I did

I designed and built the full medallion architecture on Microsoft Fabric, from raw platform data through cleaned, standardised layers to reporting-ready data that dashboards and exports read from.

Solution

  1. 01

    Designed the architecture

    Agreed the layers, keys and rules first: property, components, issues and surveys with stable keys, so the model stays easy to extend.

  2. 02

    Kept every record as it arrived (bronze)

    Raw survey, issue and compliance data lands untouched, so any figure can be traced back to its source record.

  3. 03

    Cleaned and standardised it (silver)

    One structure and controlled codes instead of free text, duplicates removed, and checks applied under agreed rules.

  4. 04

    Prepared it for reporting (gold)

    Business-ready tables for the questions housing teams ask: condition, hazards, compliance status and survey progress.

  5. 05

    Built it all on Microsoft Fabric

    Storage, pipelines and reporting on one platform, so the numbers in every report come from the same place.

Impact

The full medallion architecture on Microsoft Fabric: survey, issue and compliance data from the platform turned into one reviewed source for reporting.

Microsoft FabricMedallion architectureBronze, silver, goldPower BI-ready data

Tell me where the data hurts most.

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