SQL for Data Analyst Project | Business Expansion Case Study Full Project (2026) #sql #dataanalytics

SQL for Data Analysts Project | Business Expansion Case Study Full Project

🚀 In this video, we solve a real-world business expansion problem using SQL — step by step.

🎯 Business Objective:
A company wants to expand by opening 3 new offline outlets in India.
As a Data Analyst, your task is to analyze 1.5 years of sales data and recommend the top 3 cities based on data-driven insights.

📊 What You Will Learn in This SQL Project:

✅ City-wise revenue analysis
✅ Unique customer analysis
✅ Average sale per customer
✅ Rent vs revenue comparison
✅ Monthly sales growth calculation
✅ Market size estimation using population data
✅ Final data-backed recommendation
--------------------------------------------------------------------------------------------------------------------
📂Dataset Link:- https://www.kaggle.com/datasets/ankitrajmishra/coffee-sales-analysis-dataset

👉Github Profile link:- https://github.com/0111rajankit/Coffee_Sales_Analysis
--------------------------------------------------------------------------------------------------------------------
👉LinkedIn:- https://www.linkedin.com/in/ankitrajmishra/
--------------------------------------------------------------------------------------------------------------------
👉Data Cleaning using SQL:- https://youtu.be/tvCTy-8YUFY
--------------------------------------------------------------------------------------------------------------------
👉Data Analyst Project using MS Excel:- https://youtu.be/tvCTy-8YUFY
--------------------------------------------------------------------------------------------------------------------
👉Python Project for Data Analysis - Exploratory Data Analysis EDA:- https://youtu.be/1tYrE1z5LlI
--------------------------------------------------------------------------------------------------------------------
👉SQL Portfolio Project:- https://www.youtube.com/watch?v=GfMEiYjYZ-Y&t=1449s
--------------------------------------------------------------------------------------------------------------------

Видео SQL for Data Analyst Project | Business Expansion Case Study Full Project (2026) #sql #dataanalytics канала ANKIT RAJ MISHRA