erdemcicek2026

erdemcicek2026 / Zepto-Sales-Analysis

Public
19
0
89% credibility
Found May 17, 2026 at 19 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
AI Summary

This project is a complete grocery sales analysis toolkit that transforms raw product data into meaningful business insights. It takes a spreadsheet of 4,000 Zepto products and cleans it up by fixing errors and removing duplicates. Then it answers real business questions: Which products generate the most revenue? Where are pricing opportunities? Which items are out of stock? The results are presented both as written SQL queries and as an interactive Power BI dashboard with colorful charts showing key metrics like total revenue (₹122.27M), average discounts (7.62%), and out-of-stock items (453). The project serves as a reusable template that anyone can apply to analyze their own product catalogs.

How It Works

1
🔍 You discover the project

You find this analysis project online and notice it helps people understand grocery sales data like a professional analyst would.

2
📦 You see the raw data

The project starts with a spreadsheet full of product information — names, prices, discounts, and stock levels for thousands of grocery items.

3
✨ The data gets cleaned up

Messy entries are fixed, missing information is handled, and duplicate products are spotted so the analysis stays accurate.

4
You choose your path
📝
SQL Analysis Path

Run pre-written questions to discover specific insights like top-selling products and discount patterns

📊
Dashboard Path

View an interactive dashboard with colorful charts showing revenue, stock status, and category breakdowns

5
💡 Insights come to light

You uncover important findings — 453 products are out of stock, some high-priced items have surprisingly low discounts, and Kellogg's products drive the most revenue.

6
🎯 You apply it to your own business

Using the same approach, you can analyze your own product catalog to spot pricing opportunities and inventory problems.

🎉 Your analysis is complete

You now have a clear picture of product performance, pricing strategy, and stock health — just like a data analyst would deliver.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 19 to 19 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is Zepto-Sales-Analysis?

This is a data analysis project that explores Zepto's grocery product catalog using SQL and Power BI. It takes raw product data and transforms it into business insights covering pricing strategies, discount patterns, inventory levels, and revenue potential. The project handles data cleaning in PostgreSQL, then visualizes findings through an interactive dashboard.

Why is it gaining traction?

The project addresses a real pain point: understanding why products are out of stock and which high-MRP items lack competitive discounts. It answers practical business questions like "which categories offer the best customer deals" and "what revenue are we losing to stockouts." The combination of SQL analysis with a visual dashboard makes the insights immediately actionable for stakeholders who prefer charts over query results.

Who should use this?

Business analysts working in e-commerce or grocery delivery will find the SQL queries most useful as templates for similar datasets. Data analysts transitioning from Excel to SQL can use the documented queries as learning references. Product managers evaluating inventory gaps or pricing opportunities might benefit from the dashboard views showing out-of-stock items and discount distributions across categories.

Verdict

This is a solid learning project for SQL-based e-commerce analysis, but with only 19 stars, the credibility score sits at roughly 0.9% -- indicating it's early-stage and community validation is minimal. The documentation is thorough and the Power BI dashboard provides immediate visual value, but there's no test coverage or maintained codebase to rely on for production use. Treat it as a reference implementation rather than a tool to integrate.

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.