ZOMATA Resutaurant Management Analysis.

About the project

1. Project Overview / Heading Title: Zomato Restaurant Data Analysis Dashboard Domain: Food Delivery / Restaurant Analytics Tool Used: Power BI (dashboard UI se clear hai) Purpose: Zomato platform par available restaurants ka comprehensive analysis — price, ratings, delivery time, city & area distribution, high/low rated restaurants, etc. 2. Problem Statement Zomato jaise platforms par hazaron restaurants hote hain. Management / business stakeholders ko yeh samajhna mushkil hota hai ki: Kaunse cities / areas mein zyada restaurants hain? Average price range kya hai aur kaunse cuisine expensive hain? High-rated vs Low-rated restaurants ka distribution kaisa hai? Delivery time aur ratings ka relation kya hai? Overall business health (total restaurants, average rating, average price, delivery performance) kaisi hai? Manual data dekhne se decisions lena slow aur error-prone hota hai. Isliye ek interactive visual dashboard ki zarurat thi jo real-time filters ke saath key metrics dikhaye. 3. Solution Ek interactive Power BI dashboard banaya gaya hai jisme: Filters (top pe): Price range slider (0 – 2500) City multi-select filter (“Select all” option ke saath) Key Performance Indicators (KPIs) (right side): Low Rated Restaurant → 3K High Rated Restaurant → 662 Total Restaurant → 9K Average Delivery Time → 53.97 Average Rating → 3.66 Average Price → 348... Visuals: Horizontal bar chart → Food Price (cuisine-wise average/estimated price) Line chart → Total Restaurant in Area Line chart → Price By City Clustered column chart → High Rated Restaurants and Low Rated Restaurants by Area Donut chart → Average Ratings of Restaurant (rating distribution percentages) Column chart → Total Restaurant in City Table → City-wise Average Rating, Avg Delivery Time, Count of Total ratings 4. Key Insights from the Dashboard Cuisine / Food Price Insights: Indian cuisine sabse expensive dikh raha hai (~389) Chinese (~277), North Indian (~246), Fast Food (~240), South Indian (~228) Desserts, Bakery, Beverages, Biryani, Pizzas, Ice Cream lower price range mein hain City-wise Performance: Total restaurants: Kolkata & Mumbai highest (~1.3K each), phir Chennai, Pune, Hyderabad, Bangalore (~1.1K), Ahmedabad (~0.9K), Delhi (~0.7K), Surat (~0.5K) Average Rating: Chennai highest (3.78), Bangalore (3.76), Hyderabad & Kolkata (3.70), Ahmedabad & Mumbai (3.60) Avg Delivery Time: Kolkata sabse high (67.81), Chennai (58.97), baaki cities 44–50 range mein Total ratings count: Kolkata (1346) > Mumbai (1277) > Chennai (1106) > Hyderabad (1075) Ratings Distribution (Donut): Largest slice ~41.5% (likely mid-high ratings) Other slices: 10.02%, 9.54%, 8.86%, 7.25%, 6.63%, 5.33%, 3.96% High vs Low Rated by Area: Kothrud, Indiranagar, etc. mein high-rated restaurants zyada dikhte hain Kuch areas mein low-rated dominance hai Overall: Total ~9K restaurants High-rated sirf 662, Low-rated 3K → majority restaurants average ya low rating pe hain Average rating 3.66 (theek-thaak) Average delivery time ~54 minutes 5. How to Explain This Project to Anyone (Interview / Presentation Style) Introduction (30 sec): “This is an end-to-end Zomato Restaurant Analytics Dashboard built in Power BI. I analyzed restaurant data across multiple Indian cities to uncover insights on pricing, ratings, delivery performance and geographical distribution.” Problem: “Business teams needed a single view to understand which cities/areas perform best, which cuisines are premium, and where delivery & rating issues exist.” Solution & Approach: Data cleaned & transformed (Power Query) Data model created (relationships between Restaurant, City, Area, Ratings, Price tables) DAX measures for KPIs (Total Restaurants, High/Low Rated, Average Rating, Average Price, Average Delivery Time) Interactive visuals + filters for exploration Dashboard designed for both high-level overview (KPIs) and deep-dive analysis (charts + table) Key Findings (highlight 3-4): Indian cuisine commands the highest average price Kolkata & Mumbai have the highest number of restaurants Chennai has the best average rating Kolkata has the highest average delivery time Only ~7% restaurants are high-rated (662 out of 9K) Impact / Value: Helps Zomato / restaurant partners take data-driven decisions on expansion, pricing strategy, delivery optimization and quality improvement. 6. Technical Skills Demonstrated Data Cleaning & Transformation Data Modeling DAX (measures & calculated columns) Visualization best practices Interactive filtering & drill-down Storytelling with data

Skills required