This project provides an in-depth sales and restaurant analysis based on Zomato’s dataset. The analysis is done using Excel, SQL, Power BI, and Tableau with a focus on building a data model, transforming data, and generating key performance insights.

• Zomato Sales Poweerbi - Power BI Dashboard
• My Zomato Excel - Excel dashboard
• Tableau Dashboard Tableau visual dashboard
• zomato_sql_queries_completed All SQL queries used
• .gitattributes Git LFS tracking for large files
• Dataset - Dataset used for Zomato Sales Analysis

1. Data Modeling

   • Built a star schema using Excel sheets
   • Established relationships for accurate analysis

2. Calendar Table Creation
   Using Datekey_Opening, generated the following columns:

   • Year
   • Month Number
   • Month Full Name
   • Quarter (Q1–Q4)
   • Year-Month (e.g., 2023-Jan)
   • Weekday Number & Name
   • Financial Month (FM1 to FM12)
   • Financial Quarter (FQ-1 to FQ-4)

3. Currency Conversion

   • Converted Average Cost for 2 from local currencies to USD

4. Restaurant Metrics

   • Total number of restaurants by City and Country
   • Openings by Year, Quarter, and Month
   • Count of restaurants by Average Ratings
   • Bucketing restaurants based on Average Price

5. Behavioral Segmentation

   • % of restaurants with Has_Table_booking
   • % of restaurants with Has_Online_delivery

6. Cuisines & Ratings Insights

   • Charts and trends based on Cuisine popularity, City, and Ratings

7. Dashboard

   • An interactive dashboard built to visualize and filter KPIs dynamically

Excel Dashboard

PowerBi Dashboard

Tableau Dashboard

• Microsoft Excel – Power Query, Power Pivot, DAX
• Power BI – KPI dashboards and data modeling
• Tableau – Alternative visual exploration
• SQL – Data transformation and queries
• Git & Git LFS – Version control for large files