DUBAI AIRPORTS

Client Overview:  Dubai Airports manages the world’s busiest international airport, Dubai International (DXB),

and Al Maktoum International (DWC). As a global aviation hub, the organization is committed to sustainability

and innovation in operations.

Project: Carbon Calculator Dashboard

Objective: To enable real-time, data-driven carbon emissions tracking and ESG compliance reporting

through an integrated Tableau dashboard suite.

🔹 Benefits

• Real-Time Emissions Monitoring Across Operations
  Tableau allows integration with real-time data sources (e.g., energy meters, fuel consumption logs, HVAC systems), enabling Dubai Airport to track carbon emissions live across terminals, ground operations, and transport fleets.

• Consolidated View of Scope 1, 2 & 3 Emissions
  With Tableau’s data modeling and visual layer, the airport can create customized dashboards that separate and analyze Scope 1 (direct), Scope 2 (indirect), and Scope 3 (supply chain/travel-related) emissions, aligned with international standards like GHG Protocol and ICAO guidelines.

• Regulatory & ESG Compliance Reporting
  Tableau can generate automated reports and visual summaries that meet sustainability frameworks such as CDP, TCFD, and UAE’s Net Zero 2050 strategy, reducing the burden of manual ESG reporting while ensuring audit readiness.

• Data-Driven Decision Making for Sustainability Initiatives
  Interactive dashboards help decision-makers visualize emission hotspots (e.g., high-emitting terminals or vehicle fleets) and simulate impact of interventions like electrification, energy retrofits, or renewable integration.

• Enhanced Stakeholder Transparency and Engagement
  By deploying public or internal Tableau dashboards, Dubai Airport can communicate its environmental impact clearly to regulators, airlines, and the public, fostering trust and reinforcing leadership in sustainable aviation.

🔹 Deliverables

• ETL Pipeline Design & Implementation Document
  Description: A detailed technical document and workflow diagram describing how emissions-related data (energy, fuel, transport, HVAC, waste, etc.) is extracted, transformed, and loaded from various source systems into the data warehouse.
  Tools: Talend / Apache Airflow / SSIS / Python-based scripts

• Emissions Data Model & Schema
  Description: A centralized, structured data model designed for Tableau consumption — includes normalized tables, dimensions (e.g., facility, time, source type), and calculated fields for Scope 1, 2, and 3 emissions.
  Output: ER diagram, data dictionary, and performance-optimized data mart

• Interactive Tableau Dashboard Suite
  Description: A set of 4–6 interactive Tableau dashboards tailored for:

  • Emissions Overview (by scope, terminal, time)

  • Energy Source Breakdown

  • Carbon Intensity Trends

  • Forecast vs Actual Analysis

  • Operational Emission Hotspots
    Features: Filters, drill-downs, alerts, and export-ready views for reporting

• KPI Definitions & Calculation Logic
  Description: A report defining the logic behind key emissions KPIs, such as:

  • CO₂e per passenger

  • Emissions per square meter

  • Fleet emissions per kilometer
    Includes formulas, assumptions (e.g., emission factors), and data source references.

• Dashboard User Training & Handover Package
  Description: A training guide and knowledge transfer session for Dubai Airport’s sustainability, analytics, and operations teams. Includes:

  • Tableau workbook documentation

  • Data refresh procedures

  • User navigation and dashboard customization

​​