Case Studies: Zomato & Swiggy
These two Indian food delivery giants—Zomato and Swiggy—offer rich datasets and business scenarios for students to practice real-world data analysis. Both operate in hyper-competitive markets with large amounts of transactional, customer, and operational data, making them ideal for hands-on EDA and data visualization practice.
Zomato Case Study: Customer Behavior Analysis
Objective: Understand patterns in customer ordering behavior across cities and time frames.
Steps for EDA:
Data Cleaning & Formatting:
- Remove nulls from delivery times or ratings.
- Standardize restaurant names and cuisines.
Key Fields to Explore:
- Customer ID, Order Timestamp, Cuisine Type, Ratings, Delivery Time, City.
Analytical Questions:
- What time of day sees the highest order volume?
- Which cuisine is most popular in Tier 1 vs. Tier 2 cities?
- What’s the average delivery time by city?
Visualizations:
- Bar charts for cuisine preference.
- Heatmaps for order timings.
- Box plots for delivery time distributions.
Insights:
- Urban cities prefer fast food during weekdays.
- Longer delivery times correlate with lower ratings.
- Discounts drive higher order volumes on weekends.
Swiggy Case Study: Delivery Efficiency & Cost Optimization
Objective: Analyze delivery data to optimize delivery routes and reduce cost per order.
Steps for EDA:
Data Preparation:
- Remove duplicates and correct inconsistent location names.
- Format timestamps and calculate delivery durations.
Key Fields to Explore:
- Delivery Partner ID, Pickup & Drop Location, Time Taken, Distance, Delivery Fees.
Analytical Questions:
- What are average delivery times by zone?
- How does distance impact cost per delivery?
- Which zones experience the highest delays?
Visualizations:
- Line graphs for time vs. distance.
- Geographic maps for delivery density.
- Histograms of cost per order.
Insights:
- Certain zones experience peak-hour delays.
- Short-distance orders still incur high costs due to idle times.
- Incentives improve delivery times but increase cost per order.
