ROMANIA ELECTRICITY DASHBOARD
ROMANIA ELECTRICITY DASHBOARD
Embedded Files
In this little project I decided to explore a dataset about Romanian electricity production and consumption over a period of time of about 4 years and create a summarizing dashboard.Â
The original dataset on Kaggle is Hourly Electricity Consumption and Production by Stefan Comanita.
It contains the following columns: DateTime, containing the date and the time of the record; Consumption with the total electricity consumption; Production with the toal electricity production; Nuclear, Wind, Hydroelectric, Oil_and_Gas, Coal, Solar, Biomass containing respectively the electricity produced by the single energy source considered.
Except for DateTime, the values in the records are in MW and the data covers a period of time of more than 4 years, from January 2019 to March 2023.
Romania has a wide spectrum of energy sources and sometimes the production is bigger than the consumption. For this reason I decided to focus on analyzing the production, looking at its variations over time and how it's generally divided by sources.
The analysis was performed in MySQL Workbench and then the tables uploaded on Tableau.
As we can see the production changes over time and it's clear that the sources had a different output through the years. The production isn't constant even during the months, with higher values in winter and during the week, with the lowest values during the weekend.
As we can imagine during the day the production changes as well, it's higher when people are not sleeping of course, and it's interesting to note how solar production contributes only for a small fraction of time.
Page updated
Google Sites
Report abuse