A hand holding a pen, about to write something in a project planner.

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:

  • Automated end-to-end wine data processing
  • Improved query speed and data reliability in BigQuery
  • Delivered real-time wine insights via Tableau dashboards
  • Technologies used

    • Flask
    • Docker
    • Apache Airflow
    • Google Cloud - BiqQuery
    • Tableau
    View the code. View the Dashboard.
    Projects