This project involves a comprehensive analysis of Zomato restaurant data using advanced Excel functions, SQL queries, and interactive dashboards created with Power BI and Tableau. The primary objective is to extract valuable insights into restaurant industry trends related to location, opening trends, ratings, and price ranges.
- Develop a comprehensive Country Map Table.
- Construct a Calendar Table utilizing the Column Datekey.
- Determine the Number of Restaurants based on City and Country.
- Calculate the Number of Restaurants opening based on Year, Quarter, and Month.
- Compute the Count of Restaurants based on Average Ratings.
- Generate buckets based on the Average Price of reasonable size and determine the quantity of restaurants falling into each bucket.
- Calculate the Percentage of Restaurants based on "Has_Table_booking".
- Determine the Percentage of Restaurants based on "Has_Online_delivery".
- Develop Charts based on Cuisines, City, and Ratings.
(Note: Key Performance Indicators (KPIs) are not limited solely to the above; experimentation with additional KPIs is encouraged.)
- Excel: Leveraged advanced Excel functions such as VLOOKUP, PivotTables, and conditional formatting.
- SQL: Utilized SQL queries for data extraction and manipulation.
- Power BI: Created interactive dashboards for visualizing and analyzing Zomato restaurant data.
- Tableau: Employed Tableau for visualizing Zomato restaurant data and generating insights.
Excel Dashboard: Utilized advanced Excel functions for comprehensive data analysis and visualization.
Power BI Dashboard: Developed interactive dashboards for enhanced visualization and analysis of Zomato restaurant data.
Tableau Dashboard: Utilized Tableau for visualizing Zomato restaurant data and deriving actionable insights.
This project was created to demonstrate proficiency in data analysis and visualization tools such as Excel, SQL, Power BI, and Tableau. By analyzing Zomato restaurant data, valuable insights were obtained into industry trends, enabling informed decision-making and strategic planning.
This project is licensed under the MIT License. See the LICENSE.txt file for details.
This project represents a meticulous analysis endeavor aimed at unraveling the intricate patterns within Zomato restaurant data. By leveraging a combination of advanced Excel functions, SQL queries, and interactive dashboards with Power BI and Tableau, we've unearthed valuable insights crucial for informed decision-making within the restaurant industry.
Your engagement is vital to the continuous enhancement of this project. Whether it's through cloning the repository, contributing with your insights, or connecting with me on LinkedIn, let's collaborate and elevate our understanding of the restaurant landscape together.
Thank you for exploring this project, and here's to making data-driven decisions that shape the future of dining experiences!
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent