Sustainable Energy Dashboard: Tracking Renewable Energy and Carbon Emissions in Egypt
# Egypt's Energy Landscape: A Comparative Analysis
## Project Overview
This repository contains the final project for the **DEPI Power BI
Specialist Track**. The project provides a comparative, data‑driven
analysis of **Egypt's electric power generation** and **renewable energy
transition** against countries with similar generation profiles.\
The objective is to benchmark Egypt's performance, assess strengths and
weaknesses, and deliver actionable insights for policymakers and
energy‑sector stakeholders.
The analysis uses data from international sources and tools including
**Excel**, **Python**, and **Power BI**.
------------------------------------------------------------------------
## Team Members
- **Ahmed Abdelaty Tawfik Gohar**
- Student ID: 21093569
- Email: ahmedgohar11@gmail.com
- **Amr Fawzy Abdelhamed Abdelaziz**
- Student ID: 21100957
- Email: amrfawzyabdelhamied@gmail.com
- **Mahmoud Abdelnaby Refaat**
- Student ID: 21045900
- Email: mahmoudrefaataa@gmail.com
- **Mahmoud Magdy Elsaeed Abdelrahman**
- Student ID: 21089136
- Email: mahmoudelsaaed4@gmail.com
------------------------------------------------------------------------
## Project Methodology
1. **Country Selection**\
Identify countries with total electricity generation within ±10% of
Egypt's level.
2. **Generation Mix Analysis**\
Compare electricity sources: fossil fuels, hydro, solar, wind, and
nuclear.
3. **Performance Benchmarking**\
Assess key indicators:
- Carbon and GHG emissions
- Energy conversion efficiency
- Energy demand
- Renewable energy share and growth
4. **Renewable Energy Deep Dive**\
Analyze renewable potential, national strategies, and socio‑economic
impacts.
5. **Data Visualization & Insights**\
Develop interactive Power BI dashboards for comparison and ranking.
6. **Recommendations**\
Provide evidence‑based recommendations for Egypt's energy
transition.
------------------------------------------------------------------------
## Key Deliv …