Gym Performance Analysis (Yelp Analysis)

Description

This repository contains SQL scripts for analyzing Yelp data at both user and business levels.

Dataset

The dataset used for this analysis can be downloaded from the following link: Download Yelp Dataset

Files

• gym_user_level_analysis.ipynb: SQL queries for user-level analysis.
• gym_business_level_analysis.ipynb: SQL queries for business-level analysis.
• gym_user_level_analysis_report.pdf: Report for SQL queries for user-level analysis.
• gym_business_level_analysis_report.pdf: Report for SQL queries for business-level analysis.

Usage

1. Download the dataset from the provided link.
2. Extract the dataset files.
3. Run SQL scripts using Apache Spark.
4. Visualize outputs as described.

Results

Key insights from analyses include:

• Top cities for gyms.
• User activity trends.
• Rating patterns.