Portfolio.

Introduction

In a world where sustainability is becoming a core business driver, companies need tools that go beyond just compliance—they need insights. I built this tool to help businesses visualize their environmental impact, monitor carbon emissions and identify areas for improvement using real-time, data-backed analysis.

---

Objective

• Build a scalable tool to track and analyze sustainability metrics.
• Provide real-time insights into emissions, energy, and waste.
• Help leadership make eco-conscious, data-driven decisions.
• Automate reporting and reduce manual effort.
• Benchmark performance over time and against industry standards.

---

Methodology

Data Handling:

1. Cleaned and preprocessed 10M+ rows using Pandas, handling missing values, removing duplicates and normalizing key features using Min-Max scaling for consistent comparisons.
2. Handled datetime parsing and feature engineering to extract monthly/quarterly/yearly trends
3. Merged multiple data sources (internal operations, utility usage, transportation logs) to create a unified sustainability dataset.

Analytics & Metrics:

1. Created Custom KPIs (Calculated Fields) such as:
• Total Carbon Emissions (MT CO2)
• Total Carbon footprint (MT CO2)
• Energy Consumption (MWh)
• Emissions per distance (kg CO2/km)
• Sustainability Score
2. Performed YoY and MoM comparisons using calculated columns and window functions.

Dashboard & Visualization (Tableau):

1. Built interactive dashboards with dynamic filters (region, department, time range)
2. Included line charts for trends, gauge charts for sustainability scores, and heatmaps to identify high-emission zones.
3. Designed a scorecard view that highlighted top performers and red flags.

Automation & Reporting:

1. Used Python scripts with Scheduled Tasks to automate monthly data refresh and dashboard updates.
2. Enabled export to PDF and Excel options with one-click snapshots for leadership reporting.
3. Ensured compatibility with Tableau Public and Tableau Server for flexible sharing.

---

Result

1. Reduced manual reporting time by 10–12 hours per month through automation.
2. Empowered the sustainability team with a real-time view of emissions, leading to quicker interventions and better decision-making.
3. The company used the tool to identify areas of improvement, resulting in a significant reduction in carbon emissions.