#analytics

2 articles tagged #analytics.

A read-only SQL query over schedule tables returning a small aggregated result, rendered as a query panel and result grid, on an Active Flights blog card.

Data & Engineering21 May 20265 min read

Querying a schedule with SQL

Sometimes the fastest way to answer a schedule question is to write the query yourself. Here's what it means to treat a parsed SSIM schedule as read-only tables you can ask SQL against — locally, with your data staying on your machine.

A grid of origin rows against destination columns with cells shaded by density into a route heatmap, on an Active Flights blog card.

SSIM & Schedules30 Apr 20266 min read

The OD matrix, explained

An origin–destination matrix turns a wall of flight legs into a picture of where a network flows. Here's how to read one built from a schedule — and, just as importantly, what it can and can't tell you.

#analytics

Articles

Querying a schedule with SQL

The OD matrix, explained