Yelp User Engagement Analysis

Shubham Harde

0

Business Analyst

Data Analyst

Microsoft Excel

MySQL

pandas

Problem Statement:

In a competitive market like restaurant industry, understading the factors that influence business success is crucial for stakeholders. Utilizing the Yelp dataset, this project aims to investigate the relationship between user engagement(reviews, tips and check-ins) and business success metrics (review count, ratings) for restaurants.

Research Objectives:

Quantify the correlation between user engagement (reviews, tips, check_ins) and review count/average star rating: This will help us determine if restaurants with higher user engagements experience a corresponding increase reviews and ratings
Analyze the impact of sentiment on review count and average star rating: We will investigate if positive sentiment in reviews and tips translates to higher star ratings and potentially the total number of reviews left.
Time trends in User Enagament: We will explore if consistent user engagement over time is a stronger indicator of long-term success compared to sporadic burst of activity

Hypothesis Testing

Higher levels of user engagement (more reviews, tips and check-ins) correlate with higher reveiw counts and ratings for restaurants. Positive sentiment expressed in reviews and tips contributes to higher overall ratings and reviews counts for restaurants. Consistent engagement over time is positively associated with sustained business success for restaurants.
Like this project
0

Posted Dec 19, 2024

Contribute to Shubham-Harde/SQL_Projects development by creating an account on GitHub.

Likes

0

Views

1

Tags

Business Analyst

Data Analyst

Microsoft Excel

MySQL

pandas

Airline Data Analysis Using SQL
Airline Data Analysis Using SQL
Crunchy Corner Business Optimization & Financial Analysis
Crunchy Corner Business Optimization & Financial Analysis