Portfolio Demonstration · Available for Environmental Excellence Manager opportunities

Environmental Excellence
Dashboard — Portfolio

A working multi-plant sustainability performance dashboard built to demonstrate Scope 1/2/3 emissions tracking, water and waste KPIs, and SBTi-aligned target reporting — using methodology aligned with GHG Protocol, ISO 14064-1, and TGO Carbon Footprint standards.

View Live Dashboard → About the Project
⚠ Demonstration data: All figures are fictional and generated for portfolio purposes. Plant locations approximate Coca-Cola Thailand operations but values do not reflect actual Demo performance.
147k
tCO₂eq tracked across
Scope 1, 2 & 3
6
Plants modeled
across 4 regions
432
Monthly data points
over 24 months
25+
DAX measures &
Power BI patterns
5
Reporting frameworks
referenced

01Methodology & Frameworks

Built on internationally recognized standards. Every emission factor is documented and traceable — designed to be defensible under third-party verification, not just visually polished.

📐

GHG Protocol Corporate Standard

Scope 1 (direct), Scope 2 (electricity — both location and market based), and Scope 3 (value chain) inventory structure following the WRI/WBCSD Corporate Standard and Scope 2 Guidance.

📊

ISO 14064-1:2018

Boundary setting via operational control approach, with audit trail design supporting ISO 14064-3 third-party verification readiness.

🇹🇭

TGO Methodology

Carbon Footprint for Organization (CFO) calculation framework with Thailand grid emission factor of 0.4999 kgCO₂eq/kWh from TGO 2023 reference.

🌍

GRI 305 / CDP / SBTi

Reporting structure aligned with Global Reporting Initiative emissions standard, CDP Climate questionnaire, and Science-Based Targets initiative methodology.

📦

Ecoinvent 3.9 + IPCC AR5

Packaging materials (PET, glass, aluminum) from Ecoinvent database; refrigerant emissions using IPCC AR5 GWP100 values.

🎯

2030 Reduction Target

25% absolute reduction vs 2015 baseline aligned with Coca-Cola System SBTi commitment, with progress-to-target tracking and gap analysis.

Ready to explore the dashboard?

Interactive Scope 1/2/3 breakdown, monthly trends with seasonal patterns, plant comparisons, and progress-to-target tracking. Best viewed on desktop.

Open Dashboard →

02About this project

Why it was built and what it represents — a self-directed learning artifact to demonstrate the bridge between manufacturing data architecture and environmental KPI systems.

The Author

  • NameJatupol Saramek
  • Experience19+ years manufacturing IT
  • Most recent8.5 yrs · Cargill Meat (7 plants)
  • Power BI25+ enterprise dashboards
  • EducationMSc Computer Science (NIDA)
  • LocationAyutthaya, Thailand

Capability Status

  • Power BI / DAXExpert
  • Multi-plant data integrationExpert
  • SQL Server / SAPExpert
  • GHG Protocol Scope methodologyActive dev
  • ISO 14064-1 frameworkActive dev
  • TGO CFO certificationPlanned 2026

03Available on request

The complete portfolio package — including the underlying data model, DAX measure library, and implementation guide — is available for review during the interview process or upon request.

📊

Sample Dataset

Excel workbook with 432 records: production volumes, energy and water consumption, full Scope 1/2/3 emissions breakdown, waste streams, targets, and emission factor reference table — across 6 plants and 24 months.

⚙️

DAX Measures Library

25+ production-ready DAX measures covering total emissions, intensity ratios, year-over-year comparisons, progress-to-target tracking, data quality indicators, and KPI formatting patterns.

📖

Implementation Guide

Step-by-step documentation for porting this design to Power BI Desktop: data model setup, relationships, _Date table creation, measure definitions, and visual layout specifications.

Reach out via the contact details below — happy to walk through any aspect of the design.

Open to opportunities

Available for Environmental Excellence Manager and Sustainability Data leadership roles.

📧 jatupol.sa@gmail.com 💼 LinkedIn ⌨ GitHub