Skip to content

KaniskaEr/Restaurant_Rating_Analysis_project

Repository files navigation

🍽️ Restaurant Ratings Analysis 📌 Project Overview

This project analyzes restaurant ratings using real-world datasets of consumers, restaurants, cuisines, and preferences. The goal is to uncover insights into:

Consumer behavior & dining preferences

Popular cuisines and restaurants

Rating distribution and trends

Data-driven recommendations for restaurant businesses

A Power BI dashboard (Restaurant Ratings Analysis.pbix) has been created to visualize these insights interactively.

📂 Project Structure Restaurant-ratings-analysis-main/ │── Datasets/ │ ├── consumer_preferences.csv │ ├── consumers.csv │ ├── data_dictionary.csv │ ├── ratings.csv │ ├── restaurant_cuisines.csv │ ├── restaurants.csv │── Restaurant Ratings Analysis.pbix │── README.md

📊 Datasets

The datasets include information about customers, restaurants, cuisines, and ratings:

consumers.csv → Consumer demographics

restaurants.csv → Restaurant details

restaurant_cuisines.csv → Cuisines served by restaurants

ratings.csv → User ratings for restaurants

consumer_preferences.csv → Consumers’ cuisine preferences

data_dictionary.csv → Description of all fields

🚀 How to Use

Clone this repository:

git clone https://github.com/KaniskaEr/Restaurant_Rating_Analysis_project.git cd Restaurant_Rating_Analysis_project-main

Open Restaurant Ratings Analysis.pbix in Power BI Desktop .

Load the datasets (CSV files are included in the Datasets folder).

Explore interactive dashboards and insights.

📈 Key Insights (from Dashboard)

Distribution of ratings across different restaurants.

Most preferred cuisines by consumers.

Demographic factors influencing restaurant choices.

Restaurant performance analysis based on ratings and customer feedback.

🛠️ Tools & Technologies

Power BI → Interactive data visualization

CSV datasets → Structured restaurant data

Data Cleaning & Transformation → Handled within Power BI

📌 Future Enhancements

Add predictive modeling for restaurant ratings using Python.

Deploy an interactive web dashboard version.

Incorporate sentiment analysis from restaurant reviews.

About

Restaurant Ratings Analysis is a data analytics project that explores consumer preferences, restaurant details, cuisines, and ratings to uncover insights into dining behavior. Using Power BI dashboards, it visualizes rating trends, popular cuisines, and restaurant performance to help businesses and customers make informed decisions.

Topics

Resources

Stars

Watchers

Forks

Packages

 
 
 

Contributors