Extracting weather observations from a public API and transforming them into a dimensional model using Python, DuckDB and dbt.
A collection of analytics engineering projects exploring data ingestion, transformation, modelling and the analytical layer.
Extracting weather observations from a public API and transforming them into a dimensional model using Python, DuckDB and dbt.
Taking raw tennis data from Google Sheets and transforming it into a structured analytical model using BigQuery and dbt.