🛒 Zepto E-commerce SQL Analysis Project

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.

---

📊 Dataset

• Table: zepto
• Database: Zepto_SQL_Project
• Source: CSV product data imported and cleaned in MS SQL Server

---

🔍 Key Analyses Performed

• ✅ 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

---

🧠 SQL Concepts Used

• 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)

---

🛠️ Tools Used

• MS SQL Server 2019
• SQL Server Management Studio (SSMS)
• Dataset imported from CSV file

---

👨‍💻 Author

Siva Nilla

🎯 Passionate about Data Analysis

💼 Freelance Designer & data enthusiast

🔗 Connect with Me

---

⭐ Project Purpose

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.

---

🔗 GitHub Repository

git clone https://github.com/SivaNilla28/Zepto-Sql-DataAnaylsis-Project.git

---