Author: Shamnas Valangauparambil Mohammedali
Degree: MSc Transition Management, Justus Liebig University Giessen
Tools: R · Shiny · ggplot2 · plotly · dplyr · DT
Status: ✅ Complete — Portfolio Project 1 of 5
This interactive dashboard analyses ESG (Environmental, Social, Governance) scores and CO2 emissions for 30 global companies across 8 sectors from 2021–2023. It was built to demonstrate applied data analysis skills in a sustainability context, directly relevant to roles in ESG reporting, sustainable finance, and climate risk analysis.
Live features:
- 5-tab interactive dashboard with real-time filtering
- Company-level ESG pillar breakdown (E / S / G)
- CO2 emissions analysis with intensity metrics (per revenue, per employee)
- Trend analysis 2021–2023
- Side-by-side company comparison tool
- Full searchable/filterable data table
| Tab | What It Shows |
|---|---|
| 📊 Overview | ESG scores, rating distribution, E/S/G pillar breakdown |
| 🌍 CO2 Emissions | Bubble chart, top emitters, sector intensity, per-employee |
| 📈 Trends | ESG and CO2 change over time, sector improvement analysis |
| 🔍 Compare | Side-by-side comparison of any two companies |
| 📋 Full Data | Complete filterable dataset with colour-coded ratings |
 |
Source: Publicly available ESG disclosures and sustainability reports
Coverage: 30 companies · 8 sectors · 5 countries · 3 years (2021–2023)
Sectors: Automotive, Chemicals, Energy, Finance, Healthcare, Industrials, Technology, Retail
Key variables:
Environmental_Score,Social_Score,Governance_Score— ESG pillars (0–100)ESG_Total— Weighted composite ESG scoreESG_Rating— AAA (Leader) to BB (Laggard) classificationCO2_Emissions_MtCO2— Annual Scope 1+2 emissionsCO2_per_Revenue— Emissions intensity per $1B revenueCO2_per_Employee— Per-employee carbon footprint
install.packages(c(
"shiny",
"shinydashboard",
"ggplot2",
"dplyr",
"plotly",
"DT",
"scales",
"tidyr"
))# Option 1: From RStudio — open app.R and click "Run App"
# Option 2: From R console
shiny::runApp("path/to/project1_esg_dashboard")-
Technology sector leads ESG performance — SAP, Microsoft, and Google score 73–81, significantly above the 65-point threshold for "Advanced" rating
-
Energy sector shows highest CO2 intensity — Shell, BP, and TotalEnergies emit 50–62 MtCO2 annually, with CO2/Revenue ratios 15–20x higher than technology companies
-
Positive ESG trend 2021–2023 — All sectors except Retail showed improvement, with Technology (+5.3 pts avg) and Industrials (+4.0 pts avg) improving fastest
-
ESG–Emissions inverse relationship — Regression analysis confirms negative correlation between ESG score and CO2 emissions (visible in bubble chart), consistent with academic literature on green transition incentives
-
German companies outperform EU average — DAX companies average ESG score of 68.2 vs EU sample average of 64.7, reflecting stronger regulatory pressure from German climate legislation
This project demonstrates competencies directly relevant to:
- ESG Analyst roles — Data aggregation, scoring methodology, rating frameworks (aligned with MSCI ESG methodology)
- CSRD Compliance — Understanding of E/S/G pillar structure mirrors ESRS disclosure requirements
- Sustainable Finance — CO2 intensity metrics align with EU Taxonomy screening criteria
- Climate Risk Analysis — Emissions trend analysis supports physical and transition risk assessment
project1_esg_dashboard/
├── app.R # Complete Shiny application
├── esg_data.csv # Dataset (30 companies, 2021-2023)
└── README.md # This file
- LinkedIn: linkedin.com/in/shamnas-vm-89931b365
- Email: shamnasvm63@gmail.com
- University: MSc Transition Management, JLU Giessen, Germany
Part of a 5-project sustainability data portfolio. Next: Project 2 — Land Use Change Analysis using QGIS & Google Earth Engine.