FORECASTING · ENERGY

Weekly-retrained demand forecasting for an energy retailer

Replaced a five-year-old spreadsheet demand model with a monitored forecasting model, retrained weekly against live meter data.

Context

A UK energy retailer was over-provisioning generation capacity against a demand forecast built on a five-year-old spreadsheet model, with no stated uncertainty. Planning decisions were being made against a single point number nobody fully trusted anymore.

Constraint

The team had six weeks of budget and needed the new model integrated into an existing planning process, not a parallel system nobody would actually use.

Approach

We built a forecasting model validated against two years of historical meter data, deployed it behind an internal API, and set it to retrain weekly against live data. Every forecast ships with a stated confidence interval instead of a single number.

What shipped

A production forecasting service, an internal dashboard showing forecast vs. actual with the uncertainty band plotted, and a weekly retraining job with drift alerting.

Measured outcome
−23%
forecast error, first full quarter after launch
Industry

Energy retail, UK

Stack
PythonAWS LambdaPostgresGrafana
Duration

5 weeks

Engagement

Fixed-scope sprint

Contact

Have a system worth building right?

Start a project →