Regional energy balances
Context
Every year, Brussels Environment produces the energy balance of the Brussels-Capital Region: a document tracing the production, transformation and consumption of energy across all sectors (housing, transport, industry, services…). Producing it is a European obligation, framed by Regulation (EC) No 1099/2008 on energy statistics (whose Annex B defines the balance format).
The mission: bring the design of this balance in-house (previously reliant on external tooling) as a controlled, reproducible and auditable internal data chain.
What I did
Ingestion tools for non-dev teams. The heart of the work: letting colleagues (non-developers) ingest data from very heterogeneous formats (database dumps, Excel files, CSV, PDF, emails…) and funnel it into a data model designed specifically for the balance, with absolute traceability from raw input to result.
- Tools built in KNIME (modules + R routines called within the workflows) so they stay usable by non-devs.
- Reproducibility ensured by Git, on both the data and the KNIME + R scripts.
A Quarto reporting tool. Built the balance’s publishing chain: bibliography, embedded ggplot2 charts, automated document generation.
Traffic-data spatialisation. A tool computing vehicle-kilometres (veh.km) per municipality of the Brussels-Capital Region, broken down by vehicle type and by COPERT road typology, from Brussels Mobility’s Musti traffic model, connected to an internal PostGIS database, feeding the transport sector of the balance.
Outcome
An in-housed, reproducible and auditable reporting chain: non-dev teams ingest messy data into a controlled, end-to-end versioned model, and Brussels Environment now produces its energy balance internally, in line with EU reporting requirements.