This project explores product data from Zepto, an Indian grocery delivery platform, using SQL.
The goal was to perform data cleaning, exploration, and analysis to uncover insights about pricing, stock levels, and sales potential.
- Objective: To analyze Zepto’s product catalog and derive meaningful insights from the data.
- Tools Used: MySQL
- Dataset: Simulated dataset inspired by product listings on Zepto (contains pricing, stock, and category details).
Key steps:
- Counted rows and previewed sample data.
- Checked for null values and duplicates.
- Identified distinct product categories.
- Compared in-stock vs out-of-stock products.
- Found duplicate product names appearing multiple times.