AWS ETL Dashboard
Built an automated, cloud-native weather data pipeline on AWS (EC2, Lambda, EventBridge) that loads curated data into Redshift for a Looker Studio dashboard, and taught the build to 40+ members in a hands-on workshop.
Instructor and Speaker, Raw Data to Cloud Insights, July 2026.
The idea
Raw weather data is only useful if people can easily explore it. This project turns Open-Meteo weather data into an automated, cloud-native pipeline that feeds an interactive dashboard, and teaches others how to build it.
What I did
- Built a cloud-native pipeline on AWS using EC2, Lambda, and EventBridge to automate scheduled ingestion of Open-Meteo data
- Stored curated gold-layer data in Amazon Redshift for analytics
- Built a Looker Studio dashboard on top of the Redshift gold data
- Taught the pipeline end to end in a hands-on session
Result
Taught 40+ members to build and deploy a cloud data pipeline.