Customer Segment Analysis
Power BI · Projects & Case Studies
Theory
A segment analysis compares groups of customers to see who drives revenue and how they buy. In the sample model each customer belongs to a Segment, Consumer or Corporate, in the Customers table. Because Customers filters Sales through the CustomerID relationship, putting Customers[Segment] on a matrix with measures for customer count, orders, total sales and average order value immediately shows the comparison.
With the sample data, Consumer (Asha and Meera) has 2 customers, 3 orders and ₹3,300 of sales, an average order of ₹1,100. Corporate (Ravi and Karan) has 2 customers, 3 orders and ₹2,900, an average of ₹966.67. So Consumer leads slightly on both total and order size. The case study then adds a drill-through to customer detail, a RANKX measure for top customers, and a SWITCH-based tier (Gold, Silver, Bronze) to suggest which customers to target.
Why we use it
Businesses rarely treat all customers the same. Segment analysis shows where revenue comes from and helps sales and marketing decide where to focus.
When to use it
Use this pattern whenever a dimension groups entities: customer segment, city, product category or channel. If segments must be computed from behaviour (for example by spend), create them with a calculated column or a dynamic segmentation measure.
How it works
- Question: which customers drive revenue?
- Place Customers[Segment] on a matrix
- Add count, orders, sales and average order measures
- Is one segment clearly stronger? Yes: Drill through to its top customers. No: Compare by City or Category instead.
- Write the recommendation
Syntax
Matrix: Rows = Customers[Segment]; Values = [Customers Count], [Orders], [Total Sales], [Avg Order Value]
Customers Count = DISTINCTCOUNT(Sales[CustomerID])
Avg Order Value = DIVIDE([Total Sales], [Orders])Example
Customers Count = DISTINCTCOUNT(Sales[CustomerID])
Orders = DISTINCTCOUNT(Sales[OrderID])
Avg Order Value = DIVIDE([Total Sales], [Orders])
// Matrix by Customers[Segment]:
// Consumer 2 3 3,300 1,100.00
// Corporate 2 3 2,900 966.67
// Insight: Consumer leads on both total sales and average order size.Key points
- Segment comes from the Customers dimension and filters Sales
- Count customers with DISTINCTCOUNT on the fact key
- Average order value = total sales / distinct orders
- Add RANKX and SWITCH tiers to prioritise customers
- State the insight in the visual title