Case study · Home services
A lakehouse that made the numbers agree
One governed Databricks lakehouse pulling 20+ sources together, with 150+ KPIs.
Delivery work from our track record. We've left the client unnamed; the numbers are real.
95%
faster report refresh
150+
KPIs in one model
20+
sources unified
The challenge
Reports took hours to refresh and still contradicted each other - every team computed its own version of the truth. Leadership had stopped trusting the dashboards.
What we did
- Built a bronze-silver-gold lakehouse on Databricks, governed through Unity Catalog.
- Modeled the gold layer as a proper star schema and turned 150+ KPIs into one shared set of numbers.
- Brought in 20+ sources, both historical backfills and daily incrementals.
- Locked down access with row-level security, so people see their data and only theirs.
Stack
DatabricksDelta LakeUnity CatalogPower BIAzure