GERMAN POLKIN

YANDEX DATALENS · EDUCATIONAL BI CASE

FLIGHT DELAYS

CSV data turned into an interactive analytical story.

ZERO-CONTEXT EXPLANATION

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.

3 TYPESmap, line and ranking
14airlines in the selector
1 FILTERconnects the views
8 QUERIESJOIN → CTE → window function, a separate SQL artefact
REAL ARTIFACTS

FROM CLAIM TO PROOF

Choose a node to see what it is, what I did, and what it proves.

01 / Dashboard

Dashboard overview

The map, trend and ranking sit together in one analytical view.

VERIFIED ARTIFACT

Educational BI case · Yandex DataLens · capture of the public dashboard

Dataset source and licence are being verified before a live link is published.

Download CV (RU)Open live dashboard ↗Next case →Discuss a role →