An interactive Power BI dashboard built to analyze and visualize Zepto's inventory dataset — a dataset containing SKU-level information from a fast-growing 10-minute grocery delivery platform.
This project provides insights into:
- Discount trends across categories
- Inventory availability and out-of-stock items
- Price and quantity distribution
- Revenue performance by category
The dashboard helps stakeholders and decision-makers identify high-performing categories, optimize pricing strategies, and manage stock effectively.
Zepto Inventory Dataset – Kaggle
Created by: palvinder2006 on Kaggle
The dataset contains over 3,000+ SKUs across categories like:
- Fruits & Vegetables
- Dairy, Bread & Batter
- Chocolates & Candies
- Cooking Essentials
- Munchies
- Packaged Foods
- Personal Care
- Beverages, and more.
- KPI Tiles: Total Revenue, Total Quantity, Available Quantity, Avg Discount %
- Visuals:
- Bar Chart: Avg Discount % by Category
- Line Chart: Revenue by Category
- Donut Chart: Discount % Distribution
- Column Chart: Quantity Sold by Category
- Filters:
- Out-of-Stock Status
- Category-wise filter
- Power BI Desktop
- Power Query for data shaping and cleaning
- DAX for custom measures
- Excel / CSV as data source
- Data cleaning and transformation
- KPI calculation and visual storytelling
- Slicer-based interactivity
- Dashboard design and business insight generation
![Zepto Dashboard]
- Clone this repository:
git clone https://github.com/your-username/zepto-inventory-dashboard.git