Stop 04 / 06  ·  Earlier work

Heathrow performance.

Earlier work · Power BI

The Heathrow dashboard tracks passengers, flights and cargo using monthly airport traffic statistics for the complete years 2018–2025.

The Overview page compares a selected year with the previous year and with 2019. The Markets page breaks down the change by market.

When passenger numbers rise overall, the market breakdown shows where traffic grew and where it fell.

The airport approach at dusk, with a stepped path.
04 / Airport approach
INTERACTIVE REPORT

Heathrow Performance - Dark and Light

TECH STACK
  • Power BI
  • Deneb
Open report
Saved overview of Heathrow Performance - Dark and Light

The Overview page puts monthly passenger totals alongside aircraft movements and cargo tonnage. Select a year to compare it with the previous year and with 2019.

In 2024 Heathrow handled 83.9 million passengers, up from 80.9 million in 2019, while aircraft movements were slightly lower. Passenger traffic had passed its 2019 level even with fewer flights.

Use the monthly charts to see when the gap opened, then switch to Markets to compare passenger volumes and each market’s share of airport traffic.

Explore the data model ↓
Data source & licence

Monthly passenger, aircraft and cargo totals from Heathrow Airport’s traffic statistics. Heathrow terms of use.

Data model

Airport totals and passenger counts by market share a calendar. The market dimension filters the passenger breakdown.

Relationships
100%
FactFactHeathrowTraffic5 columns · 12 measures

Columns

  • MonthDate
  • DateKeyDimDate.DateKey
  • PassengerCount
  • AirTransportMovements
  • CargoTonnes

Measures

Comparisons
  • Aircraft movements PY
  • Aircraft movements YoY %
  • Cargo tonnes PY
  • Cargo tonnes YoY %
  • Passengers 2019
  • Passengers PY
  • Passengers vs 2019 %
  • Passengers YoY %
Performance
  • Aircraft movements
  • Cargo tonnes
  • Passengers
  • Passengers per movement
FactFactMarketTraffic4 columns · 5 measures

Columns

Measures

Comparisons
  • Market passenger change
  • Market passenger YoY %
  • Market passengers PY
Performance
  • Market passengers
  • Share of airport passengers
Measure hostAppearance1 column · 25 measures

Columns

  • Mode

Measures

  • AppearanceMode
  • Colour 000000
  • Colour 100E17
  • Colour 141018
  • Colour 1A1919
  • Colour 1C1826
  • Colour 252423
  • Colour 282134
  • Colour 2A2434
  • Colour 2C2D2C
  • Colour 30263E
  • Colour 37303F
  • Colour 39264F
  • Colour 39343F
  • Colour 3B3149
  • Colour 57D3C1
  • Colour 7755AC
  • Colour 808080
  • Colour ABA2B9
  • Colour B08AFF
  • Colour BDA0FF
  • Colour BDB4CE
  • Colour EC9DAF
  • Colour F7F4FC
  • Colour FFFFFF
Drag to pan · Ctrl + wheel to zoom · Expand a table to see its fields · Drag its grip to move it One Many Key Foreign key