Energy / ESG Data engAnalytics industrialmanufacturing Verified 8% energy reduction

Consumption baseline

2 people · 4 months Data engineer · Me — architecture and delivery
the engagement client data — not shown
heard
"We have made a public reduction commitment and I cannot prove a single kilowatt-hour of it."
real problem

Meter data existed at fifteen-minute resolution but consumption moved with production volume and weather. Without a counterfactual baseline, any reduction claim was unfalsifiable.

system built

Meter ingestion with gap handling, a weather- and production-normalised baseline model per site, and a verification report that states measured savings with a confidence interval rather than a single number.

what broke

Two sites had meters replaced mid-year. Baselines are now versioned per meter generation and the discontinuity is shown in the report.

the open rebuild same architecture · public data
dataset

ASHRAE Great Energy Predictor III + NOAA weather

what the rebuild covers

Baseline model and the verification report with intervals. The meter-generation versioning is in the write-up only.

artifacts
NotebookCodeDatasetWrite-upDemo
Open the code Open notebook