Project Overview

SQL-driven market analysis to identify the top three Indian cities for opening new physical coffee shop locations based on demand and demographic projections.

Key Features

• Analyzed regional customer transactions and sales volumes using PostgreSQL queries.
• Engineered population density projections and consumer demand models (estimated at 25% coffee drinkers) to identify the highest ROI cities.

Tech Stack