IRENA has useful databases on renewable energy. This data can be used in trend analysis of renewable energy integration and assessments of the energy transition. Therefore, these tools are useful for activists, academics, journalists, policymakers, and students. 

Data tool download: 

Go to the page HERE

Click on the first image on the page (which is also shown above in this article). Once clicked it will download the 'Renewable Electricity Capacity and Generation Statistics' query tool which is in Microsoft Excel format. Once downloaded you can enable editing and enable content in excel. 

Data analysis: 

There are four columns to select from in the main panel,

1 - Select indicators: Generation is in energy units  and capacity is in power units 

2 - Select technologies: Can select multiple options (which is useful for graphics) 

3 - Select countries and areas: Can select multiple options 

4 - Select year/s: Can select multiple years to compare them in adjoining columns  

After selections are made there are six options asking “Select preference for row sort order and perform query”. This enables how the results are put into columns and rows in the second sheet. If you select “Indicator-Technology-Country/Area”, column 1 will show capacity/generation, column 2 will show energy technology, column 3 will be the countries/regions selected, and final column/s will automatically show the year/s. 

On the left side, there is a Select/deselect tab where you can control the “Select countries and areas” option above (column 3 in the main panel). “S” denotes Select and “D” denotes Deselect.

After selecting the “perform query” you can shift to the second sheet to view the results. Some countries may not have data.  Simply delete the rows without data and proceed to make graphs and plots. 

Additional information: 

Citation/source for referencing: IRENA (2019), Renewable Energy Statistics 2019, The International Renewable Energy Agency, Abu Dhabi.  

A more detailed description is here on how to use the Query Tool 

Data methodology is further described here indicating the sources