Weather Analytics Pipeline
End-to-end ELT pipeline ingesting global weather data for selected cities across multiple continents. Python extracts from the Open-Meteo API into DuckDB; dbt handles 3-layer transformation (staging → intermediate → marts); Evidence.dev renders interactive dashboards. Automated daily via GitHub Actions.
PythonDuckDBdbtEvidence.devGitHub Actions
9Cities tracked
365Days of history
5dbt models
PassingCI status