Case study · Industrial energy company
Trusted metrics in a lakehouse
Owned lakehouse models with medallion layers, SCD Type 2 history and data quality rules, so business metrics stayed consistent.
The problem
Business metrics in an industrial energy company had to stay consistent as data and history changed underneath them.
What I built
I owned the lakehouse models: medallion layers from raw to curated, Kimball-style dimensional models, SCD Type 2 history so past figures stay reproducible, and data quality rules that check the data before it reaches dashboards.
- Bronze raw source data
- Silver cleaned, conformed
- Gold Kimball models, SCD Type 2
- Quality Lightup rules
Stack
- Databricks
- Kimball
- SCD Type 2
- Lightup