Categories: Power BI / Practice Datasets
Tags:

This Power BI dashboard titled “Sales, Profit & Customer Metrics Analysis” provides insights into total sales, profit, customer count, target sales, and customer satisfaction across different regions. Below is a breakdown of each section of the dashboard:

Note You can get the dataset from here : https://github.com/slidescope/sales_profit_customer_metrics/

1. Key Metrics (Top Section)

  • Total Sales: Displays the total revenue generated ($480.81K).
  • Profit: Shows the total profit ($193.68K) along with a gauge indicating progress.
  • Count of Customers: Displays the total number of customers (133).
  • Target Sales: Indicates the sales target set (779K).

2. Filters (Left Sidebar)

  • Region Selection: Allows filtering data by Central, East, North, South, and West regions.
  • Customer Satisfaction Factors: Filters based on Hygiene, Pricing, Quality, Service, and Speed.
  • Country Selection: Enables users to select multiple countries.

3. Graphs & Charts (Main Dashboard Area)

  • Total Sales and Target Sales by Month (Top Left Chart):
    • A bar chart comparing actual sales and target sales for each month.
    • Highlights sales trends and seasonal variations.
  • Count of Customers by Month (Middle Right Chart):
    • A line graph showing the number of customers per month.
    • Identifies peak months for customer engagement.
  • Sum of Sales by Country (Bottom Right Map):
    • A geographic map visualization showing sales distribution across South American countries.
    • Darker colors indicate higher sales in specific countries.
  • Customer Satisfaction – Score (Bottom Left Chart):
    • A horizontal bar chart displaying customer satisfaction scores across different factors.
    • Hygiene has the highest score (225), followed by Speed (139), Quality (137), Pricing (130), and Service (116).
  • Total Sales and Total Profit by Region (Bottom Right Chart):
    • A stacked bar chart representing the percentage of total sales and profit for different regions.
    • Displays the distribution of revenue and profitability across North, East, West, Central, and South regions.

Insights & Use Cases

  • Helps identify top-performing regions and customer behavior trends over time.
  • Assists in tracking progress toward sales targets and profitability goals.
  • Enables data-driven decision-making for regional marketing strategies.
  • Highlights customer satisfaction areas that need improvement.

This dashboard is an interactive tool for monitoring key business metrics, allowing users to filter data and analyze performance at different levels. Let me know if you need further details or modifications! 🚀