Categories: Power BI
Tags:

Sales Distribution Analysis Dashboard in Power BI

This is a Sales Distribution Analysis Dashboard, which visually represents sales performance across various metrics. Here’s a breakdown of the key components:

Power BI File dataset can be downloaded here : https://github.com/slidescope/Sales-Distribution-Analysis-Power-BI/tree/main

Key Metrics (Top Section)

  1. Revenue: 1.45M – The total revenue generated.
  2. Units Sold: 2754 – The total number of units sold.
  3. Sales Target: 1.42M – The predefined target for sales.
  4. Count of Sales: 500 – The total number of sales transactions.

Visualizations

  1. Revenue and Target by Month (Bar & Line Chart)
    • Displays monthly revenue performance against sales targets.
    • Green bars represent revenue, and the blue line shows the sales target trend.
  2. Top 5 Customers by Revenue (Bar Chart)
    • Lists the highest revenue-generating customers.
    • Customers such as Shawn Dillon and Stephanie Miller have contributed the most.
  3. Revenue by Product (Bar Chart)
    • Highlights the sales contribution of different products.
    • Laptops have the highest revenue (0.42M), followed by Smartphones and Cameras.
  4. Country-wise Revenue (Map)
    • A geographical heatmap showing revenue distribution by country.
    • North America and Asia appear to have high revenue generation.
  5. Country-wise Target (Donut Chart)
    • Represents the percentage contribution of different countries to the total sales target.
    • France (15.03%) and USA (13.0%) have the highest target allocations.
  6. Revenue by Region (Bar Chart)
    • Shows revenue distribution across different regions.
    • Europe (0.40M) leads, followed by North America (0.38M) and Asia (0.37M).

Filters & Controls

  • Region Filter: Allows selecting specific regions (Asia, Europe, North America, etc.).
  • Country Filter: Enables filtering by country.
  • Product Filter: Users can select specific products.

Branding

  • The dashboard includes a Slidescope logo, suggesting it might be designed by or for an educational or industrial training institution.

This dashboard provides a comprehensive overview of sales distribution, making it easy to analyze performance across products, regions, and customer segments.