• Downloaded restaurant data from the Kaggle website for more than 50,000 restaurants across Bangalore. ingested this data in the MySQL database and performed ETL to remove outliers, and clean up bad records. • For analysis of Bangalore restaurants, using Excel, VBA macros, and pivot table. Figured out the best restaurants based on rating. • Used Microsoft Power BI to build various BI dashboards that can show the best restaurants and rate distribution in different restaurants based on cuisines, locations, online orders, and table booking. • Finally, prepared a data story.
-
Notifications
You must be signed in to change notification settings - Fork 0
• Downloaded restaurant data from the Kaggle website for more than 50,000 restaurants across Bangalore. ingested this data in the MySQL database and performed ETL to remove outliers, and clean up bad records. • For analysis of Bangalore restaurants, using Excel, VBA macros, and pivot table. Figured out the best restaurants based on rating. • Use…
rajeshg75b478241/Zomato-Bangalore-Restaurant-Data-Analysis
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
About
• Downloaded restaurant data from the Kaggle website for more than 50,000 restaurants across Bangalore. ingested this data in the MySQL database and performed ETL to remove outliers, and clean up bad records. • For analysis of Bangalore restaurants, using Excel, VBA macros, and pivot table. Figured out the best restaurants based on rating. • Use…
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published