This repository contains a SQL-based data analysis project on Zepto's product inventory and pricing data. Using MS SQL Server, this project explores key business insights such as inventory status, discount patterns, and product category performance.
- Table:
zepto - Database:
Zepto_SQL_Project - Source: CSV product data imported and cleaned in MS SQL Server
- ✅ Top 10 best-value products by discount percentage
- 🚫 High MRP products that are out of stock
- 📦 Category-wise average discount percentage
- 💸 Products with the highest original prices and their selling price
- 🏷️ Brands with the highest average discounts
- 📉 Items with selling price lower than MRP, showing effective discounts
SELECT,WHERE,ORDER BY,GROUP BY,DISTINCT- Aggregate functions:
AVG(),SUM() - Conditional filtering:
WHERE,HAVING - Sorting and limiting results:
TOP,ORDER BY DESC - Type casting and formatting:
ROUND(),CAST(),DECIMAL() - Basic data cleaning and conversions (e.g., paise to rupees)
- MS SQL Server 2019
- SQL Server Management Studio (SSMS)
- Dataset imported from CSV file
Siva Nilla
🎯 Passionate about Data Analysis
💼 Freelance Designer & data enthusiast
|
|
This project is part of my learning journey into SQL and data analytics. It demonstrates how SQL can be used to perform real-world analysis on e-commerce datasets — helping businesses make smarter decisions about inventory, pricing, and product performance.
git clone https://github.com/SivaNilla28/Zepto-Sql-DataAnaylsis-Project.git