From the blog

#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 in Active Flights brand emerald on near-black.
Data & Engineering·

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.

#sql#duckdb#analytics#engineering
A grid of origin rows against destination columns with cells shaded by density into a route heatmap, in Active Flights brand blue on near-black.
SSIM & Schedules·

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.

#od-matrix#network#analytics#scheduling