In this talk, I’ll walk through how we built an end-to-end analytics pipeline using open-source tools ( Airbyte, dbt, Airflow, and Metabase). At Kunda Kids, we extract data from multiple sources using Airbyte OSS into PostgreSQL, transform it into business-specific data marts with dbt, and automate the entire workflow using Airflow. Our Metabase dashboards provide real-time insights, and we integrate Slack notifications to alert stakeholders when key business metrics change.
This session will cover:
- Data extraction: Using Airbyte OSS to pull data from multiple sources
- Transformation & Modeling: How dbt helps create reusable data marts
- Automation & Orchestration: Managing the workflow with Airflow
- Data-driven decision-making: Delivering insights through Metabase & Slack alerts
Ayoade Adegbite
Data Analytics Engineer at Wirepick