Skip to content

GarimaSingh0109/SuperMart-Sales-Analysis

Repository files navigation

📊 Sales Analysis Dashboard (Power BI)

Sales Analysis Dashboard

💼 Project Overview

This Power BI dashboard provides a comprehensive Sales Analysis based on various dimensions such as category, region, segment, shipping mode, and payment method.
It offers interactive filters to help businesses uncover key insights and make data-driven decisions.


🔍 Key Insights

  • Total Sales: 1.57M
  • Total Profit: 175.26K
  • Average Delivery Days: 4
  • Total Quantity Sold: 22K

📂 Breakdown

📁 Sales by Category

  • Office Supplies: 0.64M
  • Technology: 0.47M
  • Furniture: 0.45M

🧩 Sales by Sub-Category

  • Phones: 197K
  • Chairs: 182K
  • Binders: 175K

🚚 Sales by Ship Mode

  • Standard Class: 0.33M
  • Second Class: 0.11M
  • First Class: 0.08M
  • Same Day: 0.03M

👥 Sales by Segment

  • Consumer: 48.09%
  • Corporate: 32.55%
  • Home Office: 19.35%

🌍 Sales by Region

  • West: 33.37%
  • East: 28.75%
  • Central: 21.78%
  • South: 16.1%

💳 Sales by Payment Mode

  • Cash on Delivery (COD): 42.62%
  • Online: 35.38%
  • Cards: 21.99%

📈 Monthly Trends

  • Year-over-Year Monthly Sales & Profit comparisons for 2019 vs 2020
  • Seasonal peaks observed during October to December

🧠 Tools & Technologies Used

  • Power BI Desktop
  • DAX
  • Data Modeling
  • Visuals: Line charts, Donut charts, Bar charts

🔗 How to Use

  1. Clone this repository.
  2. Open the .pbix file in Power BI Desktop.
  3. Use filters to interact with State and Region-wise insights.

🚀 Future Enhancements

  • Add quarter/year-based time slicers
  • Drill-down feature for Category → Sub-Category
  • Customer demographic-based segmentation

📬 Feedback

Have suggestions or want to collaborate?
Feel free to open an issue or connect on LinkedIn.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors