This is a beginner-friendly SQL Data Analytics project based on a real-world Zepto inventory dataset. The project demonstrates how Data Analysts use SQL to clean, explore, and analyze e-commerce data to generate business insights.
This project is perfect for:
- 📊 Data Analytics beginners
- 📚 Students learning SQL
- 💼 Portfolio & Resume Projects
- 🚀 Practice for real-world business problems
📺 Watch Full YouTube Video: https://youtu.be/pY6pJURhloY
In this project, we perform complete SQL-based data analysis on Zepto product inventory data.
The workflow includes:
✅ Data Cleaning ✅ Data Exploration ✅ Business Insights Generation ✅ Real-world SQL Query Practice
The dataset contains product inventory data from Zepto, including:
- Product Name
- Category
- MRP
- Discount Percentage
- Selling Price
- Stock Availability
- Product Weight
- Inventory Quantity
This dataset simulates real e-commerce business data used by data analysts.
- SQL
- PostgreSQL
- Data Cleaning
- Data Analysis
- Aggregations
- CASE Statements
- GROUP BY
- ORDER BY
- Business Problem Solving
- PostgreSQL
- pgAdmin
- SQL
- Clone the repository
git clone <your-repo-link>-
Import the dataset into PostgreSQL
-
Run the SQL queries
-
Explore business insights from the data
- Writing real-world SQL queries
- Solving business analytics problems
- Working with e-commerce datasets
- Performing data cleaning using SQL
- Building portfolio-ready projects
Subscribe for more:
- SQL Projects
- Data Analytics Projects
- Power BI
- Python
- Machine Learning Basics
🔥 Learn. Build. Grow.
If you found this project useful, consider giving it a ⭐ on GitHub.