How dmitrydoni/air-boltic works
Project type and purpose
• This is a data-analytics/ETL pipeline project (“Air Boltic marketplace analytics”).
• It ingests sample datasets (CSV/JSON), runs transformations with dbt against DuckDB, then analyzes and visualizes results via Polars in a Jupyter notebook and exports an HTML report for stakeholders.
File structure
• Top level:
• analytics/air_boltic_analytics → a dbt project with subfolders: sources, staging (stg_*.sql), intermediate (int_*.sql), marts (dim_*.sql & fct_*.sql), plus macros, seeds, snapshots, tests, logs, target.
• analytics/analytics_report.ipynb & .html → Polars-based analysis and report.
• analytics/dev.duckdb → the DuckDB instance used by dbt and Polars.
• docs/analytics_architecture.png → existing architecture doc.
• samples/ → raw input files.
• Key config: dbt_project.yml, pyproject.toml, uv.lock.
README for additional insights
• Purpose: build a reusable, layered data model and deliver an HTML analytics report.