{"repo":"amlanmohanty1/zepto-SQL-data-analysis-project","free":true,"listed":false,"github":"https://github.com/amlanmohanty1/zepto-SQL-data-analysis-project","clone":"git clone https://github.com/amlanmohanty1/zepto-SQL-data-analysis-project.git","description":"Complete Data Analyst Portfolio Project with end-to-end SQL Data Analysis of Zepto E-commerce Inventory data using PostgreSQL.","language":null,"stars":60,"topics":["data-analysis","database","inventory-management","postgresql","sql","zepto","data-science","dataanalysis-projects","dataanalystportfolio","dataanalytics"],"license":"MIT","category":"databases-storage","readme_excerpt":"🛒 Zepto E-commerce SQL Data Analyst Portfolio Project This is a complete, real-world data analyst portfolio project based on an e-commerce inventory dataset scraped from Zepto — one of India’s fastest-growing quick-commerce startups. This project simulates real analyst workflows, from raw data exploration to business-focused data analysis. This project is perfect for: - 📊 Data Analyst aspirants who want to build a strong Portfolio Project for interviews and LinkedIn - 📚 Anyone learning SQL hands-on - 💼 Preparing for interviews in retail, e-commerce, or product analytics 🎥 Watch this YouTube video to implement the full project from scratch: 🔗 Link to Video: Watch on Youtube 📌 Project Overview The goal is to simulate how actual data analysts in the e-commerce or retail industries work behind the scenes to use SQL to: ✅ Set up a messy, real-world e-commerce inventory database ✅ Perform Exploratory Data Analysis (EDA) to explore product categories, availability, and pricing inconsistencies ✅ Implement Data Cleaning to handle null values, remove invalid entries, and convert pricing from paise to rupees ✅ Write business-driven SQL queries to derive insights around pricing, inventory, stock availability, revenue and more 📁 Dataset Overview The dataset was sourced from Kaggle and was originally scraped from Zepto’s official product listings. It mimics what you’d typically encounter in a real-world e-commerce inventory system. Each row represents a unique SKU (Stock Keeping Un","default_branch":null,"files":null,"tree":[],"storefront":"/r/amlanmohanty1","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/amlanmohanty1/zepto-SQL-data-analysis-project/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}