E-COMMERCE & RETAIL — DATA REPORT Ujjaval Bhardwaj  ·  FY 2024-25

The Vrinda Store

How Data Reveals the Real Story Behind ₹21 Crore in Annual Sales

₹21.18 Cr TOTAL REVENUE
32,047 TOTAL ORDERS
89.3% DELIVERY SUCCESS
7 CHANNELS
10+ STATES COVERED
TOOLS Excel Power BI Pivot Tables TYPE Sales Analysis Customer Segmentation Business Intelligence

THE PROJECT OVERVIEW

Vrinda Store sells on 7 major platforms across India. This project skips the opinions and goes straight to the data — 32,047 real orders, ₹21.18 Crore in annual revenue, and 10+ states analyzed across multiple customer segments. What we found challenges almost everything management assumed about channels, customers, and growth.

EXPLORATORY DATA ANALYSIS

Dashboard 1 — Executive Summary

₹21.18 Cr Revenue 32,047 Orders 7 Channels

3 INSIGHTS
📊 32K+ Orders ⚙ 7 Channels 🗺 10+ States Cleaned in Excel  ·  Visualized in Power BI
01

Women Drive the Business

Female customers account for 64% of all orders and form the core revenue pillar of the store. Adult women aged 30–50 alone represent 34.6%.

02

Channel Concentration Risk

Amazon (35.5%), Myntra (23.4%), and Flipkart (21.6%) together contribute 80% of total revenue — a significant concentration risk.

03

Exceptional Delivery Rate

89.3% of all orders are successfully delivered, with a cancellation rate below 3% — well above industry average for apparel e-commerce.

Dashboard 2 — Financial Health & Revenue Split

Gender Split AOV Analysis

2 INSIGHTS
📊 Gender Revenue Split 📐 AOV Benchmark Doughnut Chart  ·  Excel Pivot

Revenue: Men vs Women

₹6,609 Avg. Order Value (AOV)
₹13.56 Cr Women's Revenue
₹7.61 Cr Men's Revenue
"The business is currently operating at scale with a healthy average ticket size of ₹6,609 — predominantly driven by the female segment (64%). The male segment represents an immediate ₹7.6 Cr expansion opportunity."

Dashboard 3 — Customer Segmentation

Age Groups Gender Cohorts

3 INSIGHTS
📊 Segment Breakdown Treemap  ·  Excel
Adult Women (30–50) 34.6% Cash Cow
Teen Girls 21.1% Growth Future
Adult Men 15.5% Immediate Gap

Strategic Insight

Adult Women are our 'Cash Cow,' but the Male segment represents a ₹7.6 Cr opportunity that is currently under-marketed. Targeted men's wear launch could add 15-20% to revenue.

Dashboard 4 — Channel Distribution

7 Platforms Omnichannel Strategy

2 INSIGHTS
📊 Platform Revenue Share Horizontal Bar Chart  ·  Excel

Revenue Share by Channel (%)

⚠️

Concentration Risk

80% of revenue relies on 3 platforms. Strategic priority is to diversify into Meesho (Social Commerce) and D2C to reduce dependency.

Opportunity

Meesho and Nalli combined hold only ~9% share today but represent the fastest social-commerce growth corridor.

Dashboard 5 — Geographic Footprint

10+ States Regional Heatmap

2 INSIGHTS
🗺 State-level Data Map Visual  ·  Power BI
Maharashtra
₹2.99 Cr Top State
Karnataka
12.5% South Leader
Uttar Pradesh
9.9% Growing
North India
Untapped Highest Potential

South India contributes 52.6% of revenue — Vrinda is a market leader here. The North India corridor (Delhi, Punjab, Haryana) is largely untapped and represents the fastest route to new customer acquisition.

South India
52.6%
West (MH)
24%
North India
12%

Dashboard 6 — Seasonality & Timing

12-Month Trend Peak & Dip Analysis

3 INSIGHTS
📈 Monthly Revenue (₹ Cr) Line Chart  ·  Excel
PEAK SEASON

Jan – Apr

Increase ad spend by 40%. Festival & wedding-season demand is highest.

OFF SEASON

Sep – Nov

Run aggressive discount campaigns & clearance sales to sustain volume.

KEY STAT

16% Variance

Peak-to-trough difference is 16% — predictable enough to build a media calendar.

Dashboard 7 — Operational Excellence

Order Status Return Rates

2 INSIGHTS
📦 Fulfillment Funnel Donut Chart  ·  Power BI

Order Status Distribution

Delivered
89.3%
Returns
3.3%
Other
~7.4%
💡

Reducing returns from 3.3% → 2% through better product imagery and size guides will save an estimated ₹40–50 Lakhs annually.

3-PILLAR STRATEGY ROADMAP

Based on the data, three strategic pillars offer the clearest path to ₹25 Crore in FY25.

01

Market Penetration

  • Aggressive push in North India (Delhi, Punjab, Haryana).
  • Target: +30% new customer base within 12 months.
  • Increase state coverage from 10 → 18 states.
02

Product Diversification

  • Launch a dedicated Men's Wear collection.
  • 60% budget retained on Adult Women segment.
  • Tap Teen Girls cohort with trend-driven drops.
03

Channel Strategy

  • Reduce Amazon dependency from 35% → below 30%.
  • Scale Meesho for social-commerce audience.
  • Launch D2C website for margin improvement.

FINANCIAL GROWTH PROJECTION

By executing on all three pillars, the model projects a path from ₹21.18 Cr to ₹25 Cr+ in FY25.

Target Revenue: ₹25 Cr+

"By unlocking the male segment, entering North Indian markets, and improving operational efficiency, we project a 20%+ revenue increase in FY25."