📊 Sales Data Analysis Dashboard

📖 Project Overview

This Power BI project analyzes sales performance using transactional sales data. The dashboard provides insights into revenue, profit, customer behavior, product performance, and payment preferences through interactive visualizations.

The objective of this project is to transform raw sales data into meaningful business insights that support data-driven decision-making.

---

🛠️ Tools & Technologies Used

• Power BI
• Microsoft Excel / CSV Files
• Data Cleaning
• Data Modeling
• DAX Measures
• Data Visualization

---

📂 Dataset Used

The project is based on the following datasets:

• Orders.csv
• Details.csv

These datasets contain information related to orders, sales amount, profit, quantity, categories, sub-categories, customers, states, and payment modes.

---

📈 Dashboard KPIs

KPI	Value
Total Sales	438K
Total Quantity	6K
Total Profit	37K
Average Order Value (AOV)	121K

---

🎯 Dashboard Features

✅ State-wise Sales Analysis

✅ Monthly Profit Analysis

✅ Category-wise Quantity Analysis

✅ Customer-wise Sales Analysis

✅ Payment Mode Analysis

✅ Sub-Category Profit Analysis

✅ Interactive Quarter Filter

✅ Dynamic Business Performance Tracking

---

📸 Dashboard Screenshot

ankit_salse_dashboard.scr_final.png

---

📄 Project Report

Detailed project report is available below:

Sales_Data_Analysis_Report.pdf

🔍 Key Business Insights

• Maharashtra generated the highest sales among all states.
• Printers contributed the highest profit among product sub-categories.
• Electronics category sold the highest quantity of products.
• The business recorded its highest profit during October and November.
• COD and UPI were the most preferred payment methods by customers.
• Customer-level analysis helped identify top-performing customers based on sales volume.

---

📁 Project Files

• ANKIT.SALSE.DASHBOARD.pbix
• Orders.csv
• Details.csv
• ankit_salse_dashboard.scr_final.png

---

🚀 Business Impact

This dashboard enables stakeholders to:

• Monitor sales performance efficiently
• Identify profitable products and categories
• Track monthly profit trends
• Understand customer purchasing behavior
• Make informed business decisions using data-driven insights

---

👨‍💻 Author

Ankit Kumar

📧 Aspiring Data Analyst

🔗 GitHub: https://github.com/ankitkumar98844

---

⭐ Project Outcome

This project demonstrates practical skills in:

• Data Analysis
• Business Intelligence
• Power BI Dashboard Development
• Data Visualization
• KPI Reporting