Assets Links 

https://colorstech.net/wp-content/uploads/2025/06/1-removebg-preview.png
https://colorstech.net/wp-content/uploads/2025/06/2-removebg-preview.png
https://colorstech.net/wp-content/uploads/2025/06/3-removebg-preview-1.png

Here’s a summary of the 7 tables in the organic product sales dataset:

1. Beat – Maps Beat Code to Sales Person and Region
2. Customer Grade – Defines Grade, Customer Type, Trade Type, and Discount
3. Customer – Contains Customer ID, Name, Type, Trade Type, Region, and Grade
4. Product – Lists Product Code, Name, Category, Grams, Price/kg, etc.
5. Sales – Transaction data with Date, Bill No., Customer ID, Product Code, Volume
6. Sales Person – Includes Sales Person ID, Name, Gender, Age, Experience, and Region
7. Area – Links Customer ID to Region, State, and Beat No

The Dataset was found on kaggle : Download Dataset Here

Based on 7 tables in the organic product sales dataset, here are 3 powerful Power BI dashboard ideas you can develop for impactful business analysis:

Go to Model View and establish relationships:

Table	Column	Connects To
Sales	Customer ID	Customer → Customer ID
Sales	Product Code	Product → Product Code
Customer	Region	Sales Person → Region
Customer	Grade	Customer Grade → Grade
Customer	Customer ID	Area → Customer ID
Beat	Sales Person or Beat	Area / Sales Person

---

1. Sales Performance Dashboard

Purpose: Track product sales, customer segments, and revenue over time.

Key Visuals:

• Total Sales Volume & Revenue (card visuals)

-- DAX
ProductName = RELATED('Product'[Product])

Total Revenue = 
SUMX(
    Sales,
    Sales[Vol] * 
    (RELATED(Product[Grams]) / 1000) * 
    RELATED(Product[Price/kg])
)

Total Sales Volume = SUM(Sales[Vol])

• Sales by Product & Category (stacked bar/column chart)
• Sales Trend over Time (line chart with date filter)
• Top 5 Products / Customers by Volume (bar chart)
• State-wise Sales Distribution (map or filled map)
• Filter options: Date, Region, Product Category, Customer Type

Insights:

• Identify best-selling products
• Understand peak sales periods
• Spot underperforming regions or segments

---

2. Customer & Trade Type Analysis Dashboard

Purpose: Analyze customer segmentation, trade types, and discount impacts.

Key Visuals:

• Customer Count by Grade & Trade Type (matrix or bar chart)
• Avg. Discount by Customer Grade (donut or bar chart)
• Sales Volume by Customer Type (stacked bar or pie chart)
• Sales vs Discount Trend (scatter plot or combo chart)

Avg Discount = 
AVERAGEX(
  VALUES(Customer[Customer ID]),
  RELATED('Customer Grade'[Discount Type])
)

Filters: Region, Trade Type, Customer Grade, Product

Insights:

• Are discounts driving volume?
• Which customer segments yield the highest returns?
• What’s the trade type mix across regions?

---

3. Sales Force & Territory Performance Dashboard

Purpose: Evaluate performance of salespersons and their assigned beats.

Key Visuals:

• Sales Volume by Sales Person (bar chart)
• Beat-wise Sales Distribution (map or table)
• Customer Count per Beat (card or stacked column)
• Sales Person Experience vs Performance (scatter plot)
• Sales by State / Beat Code (matrix or map visual)

Filters: Sales Person, State, Beat Code

Insights:

• Who are the top-performing sales reps?
• Which beats or territories are underperforming?
• How does experience correlate with sales?

---