Data Engineering, featured
How much has Argentina warmed?
- problem
- There was no simple way to see how temperature changed in each region of the country, city by city, with comparable data since 1940.
- solution
- ELT pipeline that pulls 85 years of daily data for all 24 of Argentina's capitals plus 3 other cities (ERA5 reanalysis), models it with dbt on DuckDB with data-quality tests at every layer, and publishes an interactive dashboard that GitHub Actions refreshes twice a week.
- stack
- Python, SQL, dbt, DuckDB, GitHub Actions, Observable Plot