Skip to content

README.md

Latest commit

 

History

History
51 lines (42 loc) · 2.57 KB

README.md

File metadata and controls

51 lines (42 loc) · 2.57 KB
Raw

📈 Sales Performance Dashboard

📌 Overview

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.

🎯 Objective

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.

📂 Dataset

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 Satisfaction scores.
  • Time Intelligence: DateTime, Year.

📈 Dashboard Insights

  • 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.

🛠️ Tools & Technologies

  • 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.

📊 Key Features

  • 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.

🧠 Business Impact

  • 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.

🎥 Dashboard Preview

Dashboard Preview

🚀 How to Use

  1. Open the Report: Launch Sales Performance Analysis.pbix in Power BI Desktop.
  2. Select a Year: Use the time slicer to focus on a specific fiscal period.
  3. Analyze Regions: Click on a region in the map to filter other visuals.
  4. Review Products: Drill down into subcategories to see granular performance.