This Power BI dashboard provides a detailed analysis of retail sales performance. It is designed to track revenue, profitability, and customer satisfaction across different regions and product categories.
The primary goal is to enable stakeholders to:
- Monitor key financial metrics (Sales, Profit, YoY Growth).
- Identify high-performing regions and product lines.
- Correlate customer satisfaction with sales performance.
- Analyze trends over time to forecast future growth.
The analysis uses Retail Dataset.xlsx, which includes the following key data points:
- Sales Metrics:
Sales,Profit,Units Sold,Yearly Sales,YoY Sales Increase. - Product Details:
Category,Subcategory. - Regional Data:
Region. - Customer Insights:
Customer Satisfactionscores. - Time Intelligence:
DateTime,Year.
- Revenue & Profit Trenrds: Visualizing top-line and bottom-line growth over time.
- Regional Performance: Heatmaps or bar charts showing which regions are driving the most value.
- Product Mix: Analysis of best-selling categories and subcategories.
- Satisfaction Analysis: Understanding how customer happiness impacts sales volume.
- Growth Metrics: Year-over-Year (YoY) comparison to benchmark performance.
- Power BI: For creating the interactive report and visualizations.
- Excel: Source data storage.
- DAX: Used for calculating time-intelligence measures (e.g., YoY Growth if not pre-calculated) and complex aggregations.
- KPI Indicators: Cards for Total Sales, Total Profit, and Avg Satisfaction.
- Trend Lines: Monthly/Yearly sales trajectory.
- Category Filter: Slicers to drill down into specific product segments.
- Regional Map: Geographic visualization of sales density.
- Strategic Planning: Data-backed decisions on inventory and regional expansion.
- Performance Monitoring: Real-time tracking of sales goals.
- Customer Focus: Highlighting areas where satisfaction improvement could boost revenue.
- Open the Report: Launch
Sales Performance Analysis.pbixin Power BI Desktop. - Select a Year: Use the time slicer to focus on a specific fiscal period.
- Analyze Regions: Click on a region in the map to filter other visuals.
- Review Products: Drill down into subcategories to see granular performance.