About this project
Yelp Relational Database Business & User Analysis
The purpose of this project is to showcase my skills and knowledge in Structured Query Language (SQL)
Scenario
You are going to be playing the role of a real-world data scientist using SQL to both answer specific questions for an organization and make inferences based on your discoveries.
You will be using a dataset from a US-based organization called Yelp, which provides a platform for users to provide reviews and rate their interactions with a variety of organizations – businesses, restaurants, health clubs, hospitals, local governmental offices, charitable organizations, etc. Yelp has made a portion of this data available for personal, educational, and academic purposes.
Entity-Relationship (ER) Diagram
Click the diagram for full size image
My Analysis
Part I
Profiling and Understanding Yelp Dataset
[View analysis here]
Part II
Inferences and Analysis
[View analysis here]
[Complete file available for download here]
Open with any Text Editor
Recommend Sublime Text