Renewable Capacity Explorer

Analysis of installed electricity capacity in Italy.

Light-theme dashboard for 2007–2024: filters, installed capacity and four charts. The period excludes 2004–2006, whose incomplete data the app flags.Click to enlarge

I built this application to explore Terna's data on installed electricity capacity in Italy without reassembling every analysis from several files. Solar, wind, hydro, bioenergy and geothermal can be compared by region and year; thermoelectric capacity and national totals provide a further reference.

Goal
Where is installed capacity concentrated, how does it change over time, and which sources drive the changes? The app makes these questions explorable through filters, indicators, charts and a detail table.
Method
A local Bun server fetches four datasets from the Terna API and stores them in SQLite. Aggregations distinguish gross and net capacity and use the stock of the last selected year, avoiding counting the same plants more than once. The React dashboard presents time series, territorial comparisons and missing data.
Development and features
I developed acquisition, caching, resumable synchronisation and the interface. The flow starts from personal Terna credentials, stored locally, and moves on to choosing the years to download and exploring the dashboard. After synchronisation the data remain available offline. Records can be filtered and searched, the selection exported to CSV and the charts saved as PNG or SVG. Annual changes show the net change in capacity, including decommissioning.
Next projectOmniPV