Back to portfolio
Dashboard case study
Customer Segmentation Dashboard
Repeat rate, lifetime value, basket size, and churn risk.
Business question
Which customers are valuable or at risk?
Power BICustomer AnalyticsSegmentationRetention
Customer Segmentation Dashboard
Repeat purchase rate
$428k
Customer lifetime value
41.2%
Average basket size
18.4%
Churn risk
94%
Monthly trend
Live
Category breakdown
Products72%
Regions58%
Segments83%
Targets49%
CountryCustomer segmentPurchase frequency
At a glance
KPIs
Repeat purchase rate, Customer lifetime value, Average basket size, Churn risk
Filters
Country, Customer segment, Purchase frequency
Tools
Power BI, DAX, Customer analytics, Power Query
What it shows
Groups customers by value, retention, and behaviour.
- Segment summary with value, basket, frequency, and churn indicators
- Customer cohort trend view
- Segment filter controls for campaign planning
Main insights
Helps businesses identify high-value customers and retention opportunities.
- High value does not always mean high volume
- Basket size plus repeat rate shows quality
- Retention can focus on value at risk
Helps businesses identify high-value customers and retention opportunities.
Discuss a dashboard