Retail Performance Analytics Dashboard is an interactive Business Intelligence solution built using Power BI to transform raw retail sales data into meaningful business insights.
The report enables stakeholders to monitor sales performance, customer behavior, product profitability, and regional trends through interactive dashboards.
Retail businesses generate thousands of transactions every day, making it difficult for management to identify:
- Top-performing products
- High-value customers
- Profitable regions
- Sales trends
- Discount impact on profitability
This dashboard provides a centralized view to support faster, data-driven business decisions.
- Total Sales
- Total Profit
- Profit Margin
- Monthly Sales Trend
- Top Products
- Sales by Category
- Sales by Segment
- Top 5 Products
- Bottom 5 Products
- Sales by Sub-Category
- Profit by Sub-Category
- Discount vs Profit Analysis
- Top Customers
- Customer Distribution
- Customer Sales vs Profit
- Sales by Segment
- Profit by Segment
- Sales by Region
- Profit by Region
- Sales by State
- Profit by State
- Sales by Ship Mode
- Total Sales
- Total Profit
- Total Orders
- Total Customers
- Profit Margin
- Average Order Value
- Product Performance
- Customer Performance
| Tool | Purpose |
|---|---|
| Power BI | Dashboard Development |
| Power Query | Data Cleaning |
| DAX | Calculated Measures |
| CSV | Data Source |
- 📌 Technology generated the highest sales.
- 📌 West region achieved the highest profit.
- 📌 Consumer segment contributed the highest revenue.
- 📌 California generated the highest sales.
- 📌 Tables showed the lowest profitability.
- 📌 Higher discounts negatively impacted profit for several sub-categories.
- Retail-Performance-Analytics.pbix
- Sample-Superstore.csv
- executive-dashboard.png
- product-analysis.png
- customer-analysis.png
- regional-analysis.png
- Download the repository.
- Open
Retail-Performance-Analytics.pbixusing Power BI Desktop. - Load the provided dataset if prompted.
- Explore the interactive dashboards using slicers and filters.
- Data Cleaning
- Data Modeling
- Power Query
- DAX
- Dashboard Design
- KPI Development
- Data Visualization
- Business Intelligence
- Storytelling with Data
Kamlesh Suthar
Aspiring Data Analyst
⭐ If you found this project helpful, consider giving it a star!