📊 Superstore Sales Analysis — Excel Mini Project

A mini project analysing 2,538 US retail orders (2014–2017) across 20 states using 20 Excel formulas — from raw data to a final business report.

Live Sheet: Google Sheets — Mini Project Author: Akshat Dixit · GitHub: AkshatDweb

Dataset

• 2,538 order records · 20 fields · 764 customers
• 48 US states · 3 categories · 17 sub-categories
• Fields: Order ID/date, Ship Mode, Customer, Segment, State, Region, Category, Sales, Quantity, Discount, Profit

What's Inside

20 questions solved per state (Q1–Q20) using: INDEX/MATCH · COUNTIF · SUMIF/SUMIFS · MINIFS/MAXIFS · RANK · date functions · nested IF · conditional formatting

Covers: region lookup, order/sales totals, state ranking & contribution %, segment-wise sales, first/last order dates, profit after 18% tax, and profit-slab classification.

Key Results

• Total sales: $438.1K across 20 states | Profit: $37.5K before tax, $30.8K after
• California & New York drive ~39% of sales and 84% of profit
• Consumer segment leads in 16/20 states (52.8% of sales)
• 6 states lose money — mainly due to heavy discounting (Illinois, Texas, Pennsylvania)

Recommendations

1. Protect top states (CA, NY)
2. Fix discount-driven losses (IL, TX, PA)
3. Grow the Consumer segment further
4. Replicate Michigan's low-discount, high-profit model

---

📬 Questions welcome — AkshatDweb