📊 Retail Sales & Profit Performance Dashboard

🚀 Project Overview

An interactive Retail Sales & Profit Performance Dashboard built using Power BI and the popular Superstore Sales Dataset from Kaggle.

The dashboard provides deep business insights into:

• Sales performance
• Profitability trends
• Regional performance
• Product analysis
• Customer segment contribution
• Discount impact on profit

📌 Dashboard Preview

📈 Key Metrics

KPI	Value
Total Sales	2.30M
Total Quantity	38K
Total Profit	$286.40K
Total Orders	5K
Total Discount	$1.56K

---

🔍 Key Business Insights

✅ Regional Performance

• West region generated the highest sales and profit.
• East region also showed strong market performance.
• Central region underperformed compared to other regions.

✅ Product & Category Insights

• Technology category generated the highest profit margins.
• Furniture category had lower profitability despite high discounts.
• Certain products significantly outperformed others in revenue contribution.

✅ Customer Segment Analysis

• Consumer segment generated the largest share of sales.
• Corporate and Home Office segments showed stable contribution patterns.

✅ Discount Impact

• Higher discounts negatively impacted profit margins.
• Furniture products were heavily affected by discounting strategies.

📊 Visualizations Included

• KPI Cards
• Sales Trend Analysis
• Profit by Region
• Profit by Category
• Segment Contribution Analysis
• Product-wise Sales Ranking
• Discount vs Profit Correlation
• Executive Recommendations Panel

🛠 Tools & Technologies

Tool	Purpose
Power BI	Dashboard Development
Kaggle Dataset	Data Source
Excel	Data Cleaning
DAX	KPI Calculations

📂 Dataset

Dataset used: Superstore Sales Dataset (Kaggle)

This dataset contains:

• Orders
• Sales
• Profit
• Discounts
• Regions
• Categories
• Customer Segments

💡 Business Recommendations

• Reduce excessive discounting on low-margin products.
• Focus on expanding Technology category sales.
• Improve strategies in weaker-performing regions.
• Increase targeted marketing for Consumer segment customers.

🎯 Skills Demonstrated

• Data Visualization
• Business Intelligence
• Dashboard Design
• KPI Reporting
• Retail Analytics
• Business Storytelling
• Power BI Development
• Data Cleaning
• DAX Calculations

👨‍💻 Author

Mohammmed Imad

Business/Data Analyst passionate about analytics, business intelligence and AI/ML. Transforming data into actionable insights.

Support

If you found this project useful, give it a star ⭐