Designed and developed an interactive Power BI dashboard to analyze retail sales performance across regions, categories, and products.
The goal of this project was to help business stakeholders understand where revenue and profit were coming from, identify top-performing areas, and spot underperforming categories or products.
- Power BI Report: Retail Sales Performance Analysis (Power BI Dashboard).pbix
- Dashboard Screenshot: assets/dashboard-overview.png
- Power BI
- Power Query
- DAX
- Total Sales
- Total Profit
- Total Orders
- Total Quantity
- Profit Margin %
- Sales over time
- Sales by region
- Sales by category
- Profit by sub-category
- Top 10 products by sales
- Interactive slicers
- The West region generates the highest total sales, indicating strong market performance compared to other regions.
- Sales show an upward trend toward the end of the year, suggesting seasonal demand spikes in Q4.
- Technology is the top-performing category by revenue, outperforming Furniture and Office Supplies.
- Copiers and Phones are the most profitable sub-categories, while Chairs generate lower profit margins.
- A small number of products contribute disproportionately to total sales, indicating a strong top-product concentration.
- Increase marketing investment in the West region to maximize high-performing areas.
- Prepare inventory and marketing campaigns ahead of Q4 to capitalize on seasonal demand spikes.
- Focus on expanding Technology product offerings due to high revenue performance.
- Reevaluate pricing or supplier costs for low-margin items like Chairs.
- Promote top-performing products through bundling or featured placements to drive additional revenue.
- Use the slicers on the right to filter by region.
- Analyze sales trends over time using the line chart.
- Compare regional performance using the bar chart.
- Identify top-performing categories and products using the lower visuals.
