Tools used in this project
Energy Excel Dashboard

About this project

The main objective of this project is to visualize the evolution of the different renewable energies around the world since 1965. It is important to show how the renewable energy is growing by countries, continents and in the whole world by year, considering a huge amount of data.

This Excel project mainly focuses on data cleaning and data visualization.

Some Excel features used are: Power Pivot, Power Query, Macros, Data Validation; INDEX-MATCH, VLOOKUP, GETPIVOTDATA functions; Map, Donnut, Line and Stacked Columns charts, among others.

This dashboard project is part of a bigger project made in R Markdown notebook which can also be found in this Portfolio under the name of "World Renewable Energy Insights & Evolution - R Project", and on Kaggle.

Discussion and feedback(2 comments)
Claudia D
Claudia D
10 months ago
Great stuff here, Carlos!
2000 characters remaining