Business Data Management (BDM) Capstone Project analyzing sales & revenue performance of a stationery retail business using Google Sheets, dashboards, descriptive statistics, KPIs, and business analytics.
Friends Corner — a single-owner B2C stationery shop in Mogalpura, Laheriasarai, Darbhanga, Bihar, selling school & office supplies, writing materials, and art supplies. Its records lived on paper. This project turned them into decisions.
| 🏷️ | 🏷️ | ||
|---|---|---|---|
| Owner | Mr. Raj Kamal | Hours | 9 AM – 9 PM Daily |
| Store Type | B2C Stationery Retail | Study Period | 1 Jan – 4 Jun 2026 |
| Employees | 1 | Dataset | 22 wks · 154 days · 75 SKUs |
| Initial Investment | ₹10,000 | Categories | 11 |
| 💰 REVENUE | 📦 VOLUME | 📈 AVG WEEKLY | 🎯 TOP SKU |
|---|---|---|---|
| ₹3,08,623 | 8,357 units | ₹14,028 | ₹8,700 |
- 🥇 Top categories — Notebook (23.1%) + Art Supplies (17.6%) = 40.7% of all revenue
- ⚡ Fast-Moving products — 47 of 75 SKUs drive 54.6% of total revenue
- 📅 Peak days — Saturday + Friday = 37% of the whole week's revenue
- 💵 Collection split — 81.6% cash · 18.4% account
- 📉 Non-movers — just 3 products, only 3.2% of revenue — time to review
| # | Method | What It Answers |
|---|---|---|
| 01 | Business KPI Analysis | Overall performance snapshot |
| 02 | Product & Category Analysis | Which SKUs and categories actually earn |
| 03 | Revenue Pareto (80/20) | Which products to prioritize buying |
| 04 | FSN Classification | Fast / Slow / Non-Moving stock |
| 05 | Trend Analysis | Weekly & day-wise revenue swings |
| Pillar | Move |
|---|---|
| 🟡 Inventory | Keep the 47 Fast-Movers always stocked, review the 3 Non-Movers |
| 🔴 Category Focus | Prime shelf space for Notebook + Art Supplies |
| 🔵 Staffing | Load up Friday–Saturday, restock on quiet Sunday/Wednesday |
| 🟢 Digital | Keep logging sales digitally — don't go back to paper |
Google Sheets Excel Python Descriptive Statistics Pareto Analysis FSN Analysis Chart.js