Wine Recommendation Analytics with Airflow, BigQuery,Tableau and Custom API
Project Summary
Built a custom API and automated data pipeline with Airflow to process and manage wine data. Stored the data in BigQuery for analysis and created Tableau dashboards for visualization.
Highlights:
- Developed custom API endpoints with Flask to serve wine data (wineries, wines, ratings, harmonizers)
- Automated data cleaning and merging in Airflow DAGs using Pandas
- Loaded structured data into BigQuery with clustered tables for faster queries
- Built interactive dashboards in Tableau connected directly to BigQuery
- Containerized and deployed services with Docker
Outcome:
Technologies used
- Flask
- Docker
- Apache Airflow
- Google Cloud - BiqQuery
- Tableau