This project analyzes renewable energy transition trends across European countries after the Russia-Ukraine energy crisis.
Using SQL-based data modeling and Python-driven exploratory data analysis (EDA), the project investigates:
- Renewable energy growth trends
- Fossil fuel dependence
- Energy transition risks
- Renewable investment opportunities across Europe
- How has renewable energy adoption changed since 2000?
- Is Europe accelerating its renewable transition?
- Which countries are transitioning fastest?
- Which countries remain highly fossil dependent?
- How uneven is the energy transition across Europe?
- Which countries remain vulnerable to fossil fuel reliance?
- Which countries show strong renewable growth potential?
- Which markets are emerging renewable opportunities?
- Which countries combine high fossil dependence with accelerating renewable growth?
The dataset contains country-level energy indicators from 2000–2024, including:
- Renewable energy share
- Fossil fuel share
- Low-carbon energy share
- Python
- Pandas
- Matplotlib / Seaborn
- MySQL
- SQL
- Jupyter Notebook
The project uses a relational database structure with:
fact_energyentityyearindicator
A star-schema style design was used to support flexible energy trend analysis.
- Europe’s renewable energy share increased from ~7% in 2000 to ~18% in 2024
- Renewable adoption accelerated after the Russia-Ukraine crisis
- Denmark emerged as a renewable leader
- Poland and Belarus remain highly fossil dependent
- Estonia showed accelerating renewable transition momentum after 2020
Countries with:
- high fossil dependence
- accelerating renewable growth
may represent strong future renewable investment markets.
The project includes:
- Europe vs World renewable trend analysis
- Fossil fuel dependence analysis
- Renewable investment opportunity landscape
- Energy transition trajectory analysis
Renewable energy in Europe is no longer only a climate objective — it has become a strategic energy security and investment priority.