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

  1. Question: which customers drive revenue?
  2. Place Customers[Segment] on a matrix
  3. Add count, orders, sales and average order measures
  4. Is one segment clearly stronger? Yes: Drill through to its top customers. No: Compare by City or Category instead.
  5. 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

Power BI topics

Power BI Introduction

Getting Data

Power Query (Data Transformation)

Data Modeling

DAX (Data Analysis Expressions)

Data Visualization

Dashboards & Reports

Power BI Service

Advanced Features

Projects & Case Studies

Interview & Certification

Advanced DAX & Time Intelligence

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Power BI Dashboards & DAX

Learn data visualization and interactive dashboards step-by-step. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice DAX Online 250 business scenarios on a star schema — write a measure and compare your visual with the expected one. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Power BI  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax / Where to find it
{{ current.syntax }}
Example
{{ current.example }}
What You'll Learn — click to check off
  • {{ pt.mark }} {{ pt.text }}

Share this topic