Renewable Electricity Generation Graphing Using Tableau / Germany

Project Name: Renewable Electricity Generation Graphing Using Tableau / Germany

Project Description:


This visualization depicts an area chart representation of the total renewable energy generated per day nationwide in Germany from 2016 to 2019. Each layer represents the total per day of each type measured in megawatt hour (MWh). The different types include biomass, hydropower, wind offshore, wind onshore, photovoltaic, and other renewable sources. This data can be used to forecast future energy generation and can promote the use of renewable resources. This can result in benefits including reducing air pollution, reducing dependence on imported fuel sources, and increased energy efficiency.


The data feeds used contain readings of electricity generation by renewable energy sources collected by the smart grid technology and is provided by SMARD (“Strommarktdaten”, which translates to electricity market data). They receive the data directly from the European Network of Transmission System Operators for Electricity (ENTSO-E). Bundesnetzagentur verifies the data in order to continuously improve data quality and is then published on SMARD.


Tableau Public was used to created this visualization. The data feeds were first imported and manipulated. The area charts were then created for each year and were placed into an interactive dashboard.


Additional Items: N/A

Developer(s): Jenal Sanchez, Western Governors University


Data Feeds Employed:


Open Source Tools:

Tableau Public


GitHub: N/A


Original Posting Date: 17 October 2020