Santosh Kumar

This Zomato data analysis project leverages AWS/Azure ETL/ETP pipelines to provide actionable insights across sales, operations, and customer behavior, presented through Power BI dashboards covering overall performance, KPIs, user trends, and city-specific metrics.

The Overview Page serves as the high-level executive summary of Zomato's overall business performance. It provides a quick snapshot of key business health indicators, allowing stakeholders to grasp the current state and identify immediate trends. Key Metrics include Total Revenue, Total Orders, Average Order Value, Number of Active Customers, and overall Operational Efficiency Score. Visualizations typically include high-level trend lines for revenue and orders over time, geographical heatmaps for overall performance, and summary cards for current key figures. Its purpose is to offer a concise, top-down view of the business, enabling rapid assessment of performance and strategic alignmen

Get a quick overview of Zomato’s performance with ₹987M in revenue, 2 million orders, and 150K+ ratings. The dashboard highlights top-performing food categories, the best cities by order volume, and sales trends across years. A powerful visual summary to track business growth and customer engagement over time.

total users, active users, and churn patterns. The page shows that Zomato has a youthful user base, with most customers aged 20–26. However, a significant churn of 33K users indicates a need to improve retention strategies. Gender-based analytics also reveal trends in gaining and losing users.

Discover how different cities are contributing to overall sales, ratings, and user activity. Tirupati leads in revenue, while Bikaner shines in user engagement and ratings. The city-wise analysis helps uncover high-performing regions and opportunities for expansion or deeper targeting.