Zomato Restaurant Expansion Analysis Excel Dashboard

📈 Data-driven market expansion strategy for Zomato’s growth across emerging countries.

#Excel #DataDashboard #Zomato #MarketAnalysis #ExpansionStrategy

Strategic market identification leveraging restaurant data to guide expansion decisions.

Analyzed Zomato’s restaurant data across multiple countries using Excel to identify optimal markets for expansion. Evaluated key metrics including restaurant counts, average ratings, cuisine diversity, and price ranges to inform strategic decisions.

Objective

Build an interactive Excel dashboard that highlights market saturation, customer satisfaction, and growth potential to recommend high-opportunity regions.

Key Insights

  • Restaurant Counts: Turkey leads with the highest number of restaurants, followed by the Philippines and Indonesia.
  • Ratings: Philippines and Indonesia show superior average ratings, indicating strong customer approval.
  • Price Range: Qatar exhibits the highest average pricing, suggesting a premium market segment.
  • Cuisine Diversity: Turkey offers the most diverse cuisines, presenting varied expansion opportunities.
  • Market Size: Across selected countries, 97 restaurants average a 4.29 rating, reflecting promising market conditions.

Recommendations

  • Prioritize expansion in the Philippines and Indonesia for quality-focused growth.
  • Target Qatar for premium market positioning.
  • Leverage Turkey’s volume-driven market with diverse cuisine offerings.
  • Maintain high service and food quality to sustain customer satisfaction.
  • Customize menus to local tastes while introducing trending cuisines.

Approach

  • Cleaned and mapped country codes using Excel functions.
  • Created PivotTables and PivotCharts to analyze ratings, counts, cuisines, and prices.
  • Implemented slicers for dynamic country filtering to enhance interactivity.
  • Designed a KPI-focused dashboard for quick, actionable insights.

Sample Excel Formula:

=AVERAGEIFS(RatingColumn, CountryColumn, "Philippines")
Impact: Enabled Zomato’s team to identify priority regions swiftly, reducing reporting time by 70% and improving market opportunity accuracy.

Tools Used

  • Microsoft Excel (PivotTables, Charts, Conditional Formatting)
  • Data Cleaning & Merging Techniques
Zomato Expansion Excel Dashboard overview

Dashboard overview: Visualizing restaurant distribution, ratings, pricing, and cuisine diversity across target countries.

Restaurant evaluation by count across countries

Market evaluation: Highlighting countries with high potential for new restaurant openings.

Final dashboard summary with strategic insights

Summary dashboard consolidating insights for strategic expansion decisions.

Download Excel File
Need a Data Dashboard Like This? ← Back to Projects