Skip to content

ESG and financial performance analysis in Excel using Power Query for data prep, Power Pivot for modeling, PivotTable-based insights, and an interactive dashboard.

Notifications You must be signed in to change notification settings

krrusha/ESG-Financial-Performance-Analysis

Repository files navigation

ESG-and-Financial-Performance-Dashboard-Excel

image

Data Used

Data Source - https://www.kaggle.com/datasets/shriyashjagtap/esg-and-financial-performance-dataset?resource=download

This dataset simulates the financial and ESG (Environmental, Social and Governance) performance of 1,000 global companies across 9 industries and 7 regions from 2015 to 2025. It contains realistic financial metrics (e.g. revenue, profit margins, market capitalization) alongside comprehensive ESG indicators, including carbon emissions, resource usage and detailed ESG scores.

Tools Used

Data Cleaning & Transformation – Power Query (Excel)

Data Modeling & Analysis – Power Pivot (Data Model) + DAX + PivotTables

Data Visualization – Excel Dashboard (PivotCharts + Charts + Slicers)

About

ESG and financial performance analysis in Excel using Power Query for data prep, Power Pivot for modeling, PivotTable-based insights, and an interactive dashboard.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published