This project analyzes product data from an e-commerce platform (Zepto) to extract business insights related to pricing, inventory, and revenue potential.
- Analyze pricing and discount strategies
- Identify high revenue generating products
- Evaluate inventory risks
- Determine value-for-money products
- MySQL
- SQL (Joins, Aggregations, Case Statements)
- Contains product-level data including price, discount, category, and inventory
Identified products with highest revenue potential based on price and quantity.
Analyzed which categories contribute most to overall revenue.
Detected categories with high out-of-stock products.
Evaluated impact of discount strategies on pricing.
Identified products offering best quantity per price.
SELECT
category,
SUM(discountedSellingPrice * availableQuantity) AS total_revenue
FROM zepto
GROUP BY category
ORDER BY total_revenue DESC;