Skip to content
adityapatel14Public

About

No description, website, or topics provided.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

21 Commits

Folders and files

Repository files navigation

🛒 Supermart Sales Analysis

A comprehensive retail analytics project exploring 4 years of US superstore transaction data — uncovering profitability drivers, discount pitfalls, regional trends, and customer behaviour patterns.


📁 Dataset Overview

Attribute Detail
File Updated_supermart.csv
Rows 9,994 transactions
Columns 26 features
Time Period 2014 – 2017 (4 years)
Geography United States — 49 states, 531 cities
Unique Orders 5,009
Unique Customers 793
Unique Products 1,862

🗂️ Column Reference

Column Type Description
Row ID Integer Unique row identifier
OrderID String Order identifier (one order can have multiple line items)
OrderDate String (DD-MM-YYYY) Date the order was placed
ShipDate String (DD-MM-YYYY) Date the order was shipped
ShipMode Categorical Shipping method: Same Day / First Class / Second Class / Standard Class
CustomerID String Unique customer identifier
CustomerName String Customer full name
Segment Categorical Customer segment: Consumer / Corporate / Home Office
Country String Always United States in this dataset
City String Delivery city
State String Delivery state
PostalCode Integer Delivery ZIP code
Region Categorical Geographic region: East / West / Central / South
Product ID String Unique product identifier
Category Categorical Product category: Furniture / Office Supplies / Technology
SubCategory Categorical 17 sub-categories (e.g. Chairs, Phones, Binders)
ProductName String Full product name
Sales Float Revenue from the line item (USD)
Quantity Integer Units ordered
Discount Float Discount applied (0.0 – 0.8, i.e. 0% – 80%)
Profit Float Profit from the line item (can be negative)
Year Integer Extracted year from OrderDate
Month Integer Extracted month number from OrderDate
MonthName String Month name (e.g. January)
YearMonth String Period label (e.g. 2016-11) — useful for time-series plots

📊 Key Business Metrics

Metric Value
Total Revenue $2,297,200.86
Total Profit $286,397.02
Overall Profit Margin 12.47%
Average Discount Given 15.62%
Orders with Discount > 30% 1,166 orders
Loss from Over-discounting -$125,006.78

🏷️ Category Breakdown

Category Sales Profit Margin
Technology $836,154 $145,455 17.4%
Office Supplies $719,047 $122,491 17.0%
Furniture $742,000 $18,451 2.5%

🌍 Regional Performance

Region Sales Profit
West $725,458 $108,418
East $678,781 $91,523
Central $501,240 $39,706
South $391,722 $46,749

📈 Year-over-Year Growth

Year Sales Profit
2014 $484,248 $49,544
2015 $470,533 $61,619
2016 $609,206 $81,795
2017 $733,215 $93,439

🛠️ Tech Stack

  • Python — pandas, matplotlib, seaborn
  • Jupyter Notebook — exploratory analysis
  • Power BI / Tableau — interactive dashboards
  • SQL — aggregation queries

🚀 Project Structure

Supermart-Sales-Analysis/
│
├── 01_data_and_cleaning/
│   └── Updated_supermart.csv       # updated dataset
│   └── supermart_sales_data.csv    #raw dataset
│   └── supermart.ipynb             # Data cleaning
├── 02_sql/
│   └── SQL_Practice_Questions.docx # SQL Data Analysis
│    └── supermart_sql.sql
├── 03_dashboards/
│   └── supermart_dashboard.pbix    # Power BI dashboard
│
├── 04_insights/
│   ├── insights_report.md          # Key findings
│   └── business_solutions.md       # Actionable recommendations
│
└── README.md

📌 Notes & Assumptions

  • All records are from the United States — no international orders.
  • The Unnamed: 0 column is an auto-generated index from the export and can be safely dropped during analysis.
  • Negative profit values are real and expected — they represent heavily discounted or returned orders.
  • PostalCode is stored as an integer; leading zeros (common in New England ZIP codes) may be missing and should be zero-padded as strings for geographic mapping.
  • OrderDate and ShipDate are in DD-MM-YYYY format — parse with dayfirst=True in pandas.
  • Each row is a line item, not a full order. Aggregate by OrderID for order-level analysis.

🤝 Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you'd like to change.


📄 License

This project is for analytical and educational purposes. Dataset is based on publicly available Superstore sample data.

About

No description, website, or topics provided.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages