This project showcases an interactive Sales & Profit Dashboard built using Power BI to analyze Walmart retail performance.
The dashboard provides insights into:
- Overall Sales & Profit performance
- Category-wise contribution
- State-level profitability
- Product-level revenue tracking
It enables data-driven decision-making through interactive filters and dynamic visualizations.
| Metric | Value |
|---|---|
| 💰 Total Sales | 725.46K |
| 📈 Total Profit | 108.42K |
| 📦 Categories Analyzed | 10+ |
| 🌎 States Covered | Multiple |
- Total Sales
- Total Profit
- Dynamic category selection
- Interactive Pie Chart
- Top Categories:
- Chairs – 14.03% (101.78K)
- Phones – 13.6% (98.68K)
- Tables – 11.68% (84.75K)
- Horizontal bar chart visualization
- California leading in profitability
- State-level comparative insights
- Sorted product revenue table
- Identifies high-performing SKUs
- Supports inventory and pricing decisions
- Category selection (Accessories, Appliances, Art, Binders, etc.)
- Dynamic cross-filtering across visuals
- Power BI
- DAX (Data Analysis Expressions)
- Power Query (Data Cleaning & Transformation)
- Data Modeling (Star Schema)
- Interactive Visualizations
- Revenue concentration in Chairs & Phones category
- California is the highest profit-generating state
- Clear SKU-level sales variance enabling upselling opportunities
- Category-level segmentation supports strategic product planning
---
- KPI Dashboard Development
- Business Intelligence Reporting
- Data Cleaning & Transformation
- Advanced DAX Calculations
- Data Storytelling & Visualization