Renewable Energy Dashboard

INTRODUCTION

The Renewable Energy Dashboard project aims to provide a comprehensive overview of the renewable energy sector by analyzing data related to energy consumption, renewable capacity, investment, job creation, and global energy trends. The project utilizes Excel to create an interactive dashboard that allows users to explore and understand the data effectively.

BACKGROUND

The renewable energy sector has experienced significant growth and transformation over the years. To understand the progress and impact of renewable energy sources, it is crucial to analyze and visualize data from different time periods. This project focuses on data from 2000, 2010, and 2019 to capture the changes and trends in the renewable energy landscape.

GOALS

1. Provide an interactive dashboard that displays key metrics and trends in renewable energy.
2. Enable users to explore and compare energy consumption, renewable capacity, investment, and job creation across different years and countries.
3. Visualize global consumption and energy generation patterns to highlight the significance of renewable energy sources.
4. Facilitate data-driven decision-making and promote awareness about the potential of renewable energy.

Methodology

The project utilizes Excel's data manipulation and visualization capabilities to process and present the renewable energy dataset. The dataset includes information on energy consumption, renewable capacity (measured in megawatts), investment in the renewable energy sector (in US dollars), and job creation. Various Excel functions, charts, and interactive elements are employed to transform raw data into meaningful insights.

By analyzing the renewable energy dataset through an Excel-based dashboard, this project aims to provide a comprehensive understanding of the renewable energy sector's growth, impact, and potential for the selected years.

Kindly click this link to have an interaction with the dashboard: Renewable Energy Dashboard.xlsm

For a detailed analysis and presentation, you may want to reach out to me via my LinkedIn as seen on my profile.