🎉 Zomato Restaurant Expansion Analysis

🎉 Project Summary:

Analyzed Zomato’s restaurant data to uncover trends and opportunities for expansion and improving customer satisfaction. The project involved exploring and cleaning raw data, applying advanced Excel formulas, and developing actionable recommendations.

🛠 Tech Stack:

Microsoft Excel (for data extraction, cleaning, and transformation).

Advanced Formulas: VLOOKUP, XLOOKUP, INDEX/MATCH, COUNTIFS, SUMIFS, IFs, PivotTable, SLICERS.

Visualization(Dashboard): Built charts and graphs to highlight key trends.

🚀 Impact:

Derived strategic recommendations for choosing locations for expansion.

Provide actionable insight into customer preferences, pricing trends, and high-demand cuisines.

Delivered a clear, data-informed roadmap to aid Zomato’s expansion decisions.