This project analyzes Zepto inventory and product data using SQL to uncover insights related to pricing, discounts, stock availability, revenue generation, and inventory management.
The project includes data exploration, data cleaning, and business analysis queries using MySQL.
- MySQL
- CSV Dataset
The dataset contains inventory-related information including:
- Product Name
- Category
- MRP
- Discount Percentage
- Available Quantity
- Selling Price
- Product Weight
- Stock Availability
- Removed products with zero price
- Converted prices from paise to rupees
- Checked for null values
- Identified duplicate product names
Identified products with the highest discount percentages.
Found high-MRP products currently unavailable because they have high margins as well.
Calculated estimated revenue generated by each category.
Filtered products with MRP above ₹500 but discounts below 10%.
Identified top categories offering maximum discounts.
Calculated price per gram for products above 100g.
Grouped products into:
- Low
- Medium
- Bulk
Calculated total inventory weight for each category.
- Some premium products are frequently out of stock
- Certain categories offer significantly higher discounts
- Weight-based pricing helps identify best-value products
- Build Power BI dashboard
- Perform customer behavior analysis
- Create product recommendation insights