The Retail Sales Performance Dashboard is an interactive and insight-driven business intelligence solution developed using Microsoft Power BI. This project analyzes multi-year retail sales data (2019–2024) to track key performance indicators, identify sales trends, and evaluate profitability across products, regions, states, and customer segments.
The dashboard is designed to help business stakeholders monitor performance, compare year-over-year sales, and make data-driven strategic decisions.
- Track overall sales, quantity, profit, and profit margin
- Analyze product-level performance and top-selling items
- Compare sales across store types (Online, Offline, Franchise)
- Identify regional and state-wise performance trends
- Monitor monthly sales vs previous year (PY) comparison
- Evaluate top-performing cities by sales, quantity, and profit
- Enable dynamic filtering by Year and Customer Segment
- Total Sales: 4.72bn
- Total Quantity: 316K
- Total Profit: 873.55M
- Profit Margin: 18.49%
The KPI cards include trend indicators to quickly visualize performance movement over time.
- Highlights highest revenue-generating products
- Helps identify strong-performing and underperforming product categories
-
Donut chart showing contribution from:
- Online
- Offline
- Franchise
-
Useful for channel performance analysis
- Regional distribution (North, South, East, West)
- Supports geographical strategy planning
- Interactive map visualization
- Displays state-wise performance insights
- Helps identify high-growth and low-performing states
- Month-wise comparison of current sales vs PY sales
- Enables trend and seasonal performance analysis
- Tabular visual with key metrics
- Highlights most profitable cities
- Microsoft Power BI
- Power Query (Data Transformation & Cleaning)
- DAX (Data Analysis Expressions)
- Data Modeling (Star Schema Approach)
- Interactive Slicers & Filters
- KPI Cards & Advanced Visualizations
- Identified high-margin products and revenue-driving categories
- Determined strongest performing sales channels
- Analyzed regional contribution to overall revenue
- Tracked monthly performance trends and growth patterns
- Compared year-over-year performance for business evaluation
- Year-wise filter (2019–2024)
- Customer Segment slicer
- Fully dynamic visuals with cross-filtering capability
- Drill-down enabled for detailed analysis
This dashboard enables:
- Data-driven strategic planning
- Revenue optimization decisions
- Performance monitoring across multiple dimensions
- Identification of growth opportunities
- Executive-level reporting and KPI tracking
✔ Clean and professional UI design ✔ Consistent color theme and branding ✔ Interactive and user-friendly layout ✔ Business-focused KPI tracking ✔ Advanced DAX measures for accurate calculations