Click Here to view the project- Github

https://github.com/ontu001/sk-mart_retail_chain_analysis

📝 Case Study Overview

In this case study, I analyzed sales, customer behavior, product performance, inventory status, and marketing effectiveness for SK Mart — a growing retail chain operating in key areas of Dhaka, Bangladesh. Using SQL, I explored real-world business problems such as identifying top-performing products, customer purchase patterns, low-stock risks, and the impact of marketing campaigns across platforms like Facebook and YouTube. The goal of this analysis is to provide actionable insights that can help optimize SK Mart’s operations and drive data-informed decision-making.

🧠 Business Questions:

1. What are the top 5 best-selling products by quantity and revenue?

The results show that Coca Cola leads in both metrics, followed closely by Chili Powder, Cheese, Potato Chips, and Turmeric Powder. These products contribute significantly to overall sales, indicating strong customer demand across both branded snacks and essential grocery items.

with best_selling_products as (
select
	p.name,
	sum(o.quantity) as total_order,
	sum(o.price) as revenue,
	rank() over(order by sum(o.price) desc, sum(o.quantity) desc) as rank_
from products as p
inner join order_items as o on p.id = o.product_id
group by 1

)
select *
from best_selling_products
where rank_ <=5;

1. Which customers placed the most orders?

Using SQL, I identified the most frequent buyers at SK Mart based on total order volume. Kimaya Bose and Jayesh Lall lead the list with 9 orders each, followed closely by Aradhya Lall with 8 orders. Several other loyal customers, including Anvi Mallick, Hridaan Ramakrishnan, and Pari Bose, placed 7 orders each. This insight highlights a group of highly engaged customers who are likely to respond well to loyalty programs or targeted promotions.