AneshaaK / Restaurant-Data-Analysis Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

Objective is to build a web service to host an interactive dashboard of any given service and city of the end user's choice using Tableau Desktop

0 stars 0 forks Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 13 Commits
source-code-bq		source-code-bq
.gitattributes		.gitattributes
Data230_Project_Presentation.pdf		Data230_Project_Presentation.pdf
README.md		README.md

Repository files navigation

Restaurants Data Analysis - Yelp

Data Visualization

Project Methodology: CRISP-DM
- Data Collection : Yelp (https://www.yelp.com/dataset)
  - Leveraged two subsets of dataset: Businesses (business.json) and Check-ins (checkin.json)
- Data Preparation & Processing:
  - Stored both json files in cloud storage
  - Removed unnecessary columns and approx 1% of missing values using Google Dataprep
  - Created tables in Bigquery with processed data
- Data Visualization:
  - Connected to Bigquery in Tableau Desktop
  - Joined both tables and created date fileds, lociation hierarchy and visual tool tips for better view

About

Objective is to build a web service to host an interactive dashboard of any given service and city of the end user's choice using Tableau Desktop

bigquery sql json-files gcp-storage tableau-dashboards gcp-cloud-storage gcp-dataprep

Report repository

Languages

SQL 100.0%