INTERACTIVE REPORT

Heathrow Performance - Dark and Light

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

Compare monthly passenger numbers, flights and cargo at Heathrow from 2018 to 2025. The Overview page puts each year alongside the previous year and 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.

Next project · Spotify →

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