🛍️ Vrinda Store — Sales Data Analysis

An Excel-based analysis of ~31,000 e-commerce order records for Vrinda Store, a multi-channel apparel seller operating on Amazon, Flipkart, Myntra, Ajio, Meesho, and Nalli. Raw order data is cleaned and transformed into PivotTable-driven insights on sales trends, customer demographics, order fulfillment, and geography, consolidated into an annual report dashboard.

Overview

Vrinda Store sells kurtas, sets, western dresses, sarees, and more across seven online channels. This project analyzes a full year of order data (Jan–Dec 2022) to answer key business questions:

• Which months and channels drive the most revenue?
• How does spending differ between men and women, and across age groups?
• What share of orders are cancelled, returned, or refunded?
• Which Indian states generate the highest sales?

Dataset

Detail	Value
Records	31,047 order line items
Unique orders	28,471
Unique customers	28,437
Date range	Jan 2022 – Dec 2022
Total sales	₹2,12,76,377
States covered	50
Sales channels	Amazon, Flipkart, Myntra, Ajio, Meesho, Nalli, Others

Raw data columns: Order ID, Customer ID, Gender, Age, Age Group, Date, Month, Order Status, Channel, SKU, Category, Size, Qty, Amount, Currency, Shipping City/State/Postal Code/Country, B2B flag.

Tools

• Microsoft Excel — PivotTables and PivotCharts for aggregation and trend analysis
• Data cleaning — standardizing city/state naming, handling multi-item orders, categorical grouping (age bands)
• Cross-tabulation analysis (gender × age group, channel × order share)

Steps

1. Imported and cleaned the raw order-level dataset (standardized location fields, grouped ages into bands, checked for duplicates/multi-item orders).
2. Built PivotTables to summarize sales by month, gender, age group, order status, state, and channel.
3. Created PivotCharts for each summary to visualize trends at a glance.
4. Consolidated all views into a single annual report dashboard sheet.

Dashboards

The workbook (Vrinda Store Data Analysis Project.xlsx) contains the following sheets:

Sheet	Purpose
Vrinda Store	Raw, cleaned order-level transaction data (source table)
Sales Vs Orders	Monthly pivot of total sales value vs. order count
Men Vs Women	Sales split by gender
Age And Gender	Order share by age group (Teenager / Adult / Senior) crossed with gender
Order Status	Breakdown of Delivered, Cancelled, Returned, and Refunded orders
States	Top revenue-generating Indian states
Channels	Order share by sales channel
Vrinda Store Report 2026	Consolidated annual report / dashboard view

Results

• Order fulfillment: 92%+ of orders are successfully delivered; cancellations, returns, and refunds together account for a small but trackable slice of volume.
• Gender split: Women's apparel drives roughly 60% of revenue over men's.
• Top states: Maharashtra, Karnataka, Uttar Pradesh, Tamil Nadu, and Telangana are the leading markets by sales value.
• Channel mix: Amazon is the dominant channel by order volume, followed by Myntra and Flipkart.
• Category demand: Kurtas and Sets together make up the majority of items sold, ahead of Western Dresses, Tops, and Sarees.

How to Run

1. Download Vrinda Store Data Analysis Project.xlsx from this repo.
2. Open it in Excel (or Google Sheets / LibreOffice Calc).
3. Go to the Vrinda Store Report 2026 sheet for the summarized dashboard, or explore individual pivot sheets for deeper cuts.
4. Click into any PivotTable and use "Refresh" or adjust field settings to explore the data further.

Author

Ashmit Srivastava 📧 ashmitsrivastava0208@gmail.com 🔗 LinkedIn · GitHub