Skip to content

abhisekde96/zomato-data-analytics-and-etl-pipeline

Repository files navigation

Zomato Data Analytics | GCP Data Engineering

The goal of this project is to perform data analytics on Zomato restaurant Data via ETL processes, quering and finally dashboarding.

Insights

https://lookerstudio.google.com/reporting/191f74e7-4ccb-4fc5-81a6-8307d00f4a21

image

Flow

image

--> create cloud bucket
--> upload csv to bucket
--> make public access to csv

--> start VM
--> mage start zomato_analytics --> http://34.131.152.61:6789/

Modern Data Pipeine Tool - https://www.mage.ai/

Contibute to this open source project - https://github.com/mage-ai/mage-ai

--> BigQuery
--> LookerStudio

Data Modelling

image