Skip to content

pavithralanalytics/Ecommerce-Sales-Dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Dashboard Preview

Ecommerce Sales Dashboard 📊

This project is a Power BI dashboard designed to analyze ecommerce sales performance across different dimensions such as profit, sales amount, quantity, categories, customers, and payment methods.

🔍 Project Overview

The dashboard provides:

  • Key performance indicators (KPIs)
  • State-wise sales distribution
  • Category-wise performance
  • Monthly profit trends
  • Top customers analysis
  • Mode of payment insights
  • Sub-category sales breakdown

📈 Key Metrics

  • Total Profit: 37K
  • Total Sales Amount: 438K
  • Total Quantity Sold: 5,615
  • Average Sales: 121K

🗂 Visual Insights

  • Top States: Maharashtra, Madhya Pradesh, Uttar Pradesh
  • Top Category: Clothing (62.62%)
  • Most Used Payment Mode: Cash on Delivery (43.74%)
  • Peak Profit Month: November

🛠 Tools Used

  • Power BI
  • Microsoft Excel (for data preparation)

📁 Files in This Repository

  • Sales Dashboard.pbix → Power BI dashboard file
  • POWER BI.pdf → Project presentation
  • dashboard.png → Dashboard preview image

👩‍💼 Author

Pavithra L
MBA – Business Analytics & Finance


⭐ If you like this project, feel free to star the repository!

Releases

No releases published

Packages

 
 
 

Contributors