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
- 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.
- 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.
- 03
Cleaned and standardised it (silver)
One structure and controlled codes instead of free text, duplicates removed, and checks applied under agreed rules.
- 04
Prepared it for reporting (gold)
Business-ready tables for the questions housing teams ask: condition, hazards, compliance status and survey progress.
- 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.
More work
Tell me where the data hurts most.
A 15 minute call. I will tell you honestly whether I can help.