This repository contains an SQL analysis of a 3,732-row inventory dataset from Zepto, focusing on pricing, stock levels, and category insights. The analysis uses MySQL to provide actionable insights for inventory management and decision-making.
From the README
🛒 Zepto Inventory Analysis SQL Project Turning 3,700+ raw inventory rows into pricing, stock, and revenue decisions — using nothing but SQL. Zepto is one of India's fastest-growing quick-commerce platforms, delivering groceries in minutes. Behind every "10-min delivery" promise is an inventory system juggling thousands of SKUs, fluctuating stock, and aggressive discounting. This project digs into that inventory data to answer questions a category manager or business analyst would actually ask: What's driving revenue? What's sitting out of stock? Where are we discounting too much — or too little? --- 📑 Table of Contents • Tools Used • Dataset • Project Structure • Schema Design •...
Skills
- data-analysis
- data-analytics
- ecommerce
- inventory-analysis
- mysql
- sql
- sqltools
- vscode
