ATL Delta Departure Pressure

Delta ATL departure delay hotspots by destination and time block

Hotspot cells are ranked from Delta departures out of ATL after monthly qualification thresholds are applied. The matrix below shows where average departure delay is most concentrated, while the supporting trend view tests whether the worst cells are persistent or confined to narrower periods.

Generated artifact awaiting data
Rows: —
Primary fact table: default.ontime_v2
Worst Hotspot
—
Awaiting hotspot summary rows.
Worst Avg Delay
—
Average departure delay minutes for the top-ranked hotspot cell.
Worst P90 Delay
—
90th percentile departure delay minutes for the same cell.
Qualifying Months
—
Coverage and persistence for the worst hotspot cell.

Hotspot Heatmap

Rows are destinations, columns are departure time blocks, and cell color encodes average departure delay minutes. Redder cells indicate worse structural pressure out of ATL after qualification filters.

Reading the matrix

The top-ranked hotspot cell will be highlighted once data loads.

Lower delay Moderate pressure Severe hotspot

Interpretation Frame

This dashboard separates ranked hotspot cells from their monthly traces so the top-ranked destination-bank combinations can be assessed for severity, repeatability, and ATL bank congestion patterns.

  • The worst hotspot will be summarized here after the ranking rows load.
  • Persistence will be inferred from qualifying-month coverage and the first-to-last qualifying span.
  • The top 5 cells will be used to describe whether pressure is concentrated in a few ATL departure banks or spread more broadly.

Monthly Trend View For Top 3 Hotspot Cells

The trend cards are derived directly from the top 3 ranked hotspot cells in the fetched result set. This view shows whether the highest-delay cells are steady recurring pressure points or narrow spikes.

Top 20 Hotspot Ranking

Ranking priority follows average departure delay first, then p90 delay, then the share of flights delayed 15+ minutes, with completed volume as the final tiebreaker.

Rank Dest DepTimeBlk Avg Delay P90 Delay DepDel15% Flights Qualifying Months First Month Last Month

Query Ledger

Data provenance is kept explicit. This artifact renders the canonical result produced by qforge after the saved SQL was executed against the configured MCP server within the allowed dataset scope.

Label Role Status Rows Source

Dataset Scope

The saved query is constrained to Delta departures from ATL using default.ontime_v2. No references to default.ontime are required for this artifact.

The page remains useful even if the result set is empty. Header context, query provenance, saved SQL, and explanatory framing remain visible, and all analytical panels degrade to clear empty states instead of broken visuals.