GERMAN POLKINYANDEX DATALENS · EDUCATIONAL BI CASE
FLIGHT DELAYS
CSV data turned into an interactive analytical story.
I prepared the data, configured the dataset, data types and calculated fields, then built a map, line and bar visualisations connected by an airline selector. The dashboard itself didn't need SQL or Python — stated plainly. Separately, on top of the same domain, I built a reproducible SQL artefact: a three-table schema with primary and foreign keys, and eight queries — joins, aggregates, CASE, CTEs, window functions, an anti-join, a data-quality check. Every query is checked by a script that runs them in SQLite against an expected result.
FROM CLAIM TO PROOF
Choose a node to see what it is, what I did, and what it proves.
Dashboard overview
The map, trend and ranking sit together in one analytical view.
VERIFIED ARTIFACTEducational BI case · Yandex DataLens · capture of the public dashboard
Dataset source and licence are being verified before a live link is published.