An interactive Power BI dashboard built to help stakeholders understand customer value across 800 customers — segmenting them by tier (Bronze, Silver, Gold, Platinum) and purchase behavior (Regular, Occasional, Frequent) to surface where revenue and profit are actually concentrated.
Businesses often struggle to identify which customer groups contribute the most value and where marketing efforts should be focused. This project aims to segment customers based on purchasing behavior and provide insights that support retention and revenue growth strategies.
Dataset: Tableau Sample Superstore (Modified Customer Segmentation Dataset)
Tools Used:
⭐ Platinum customers generate the highest average sales per customer ($13.1K), making them the most valuable customer tier.
👥 Silver customers account for 63.5% of all customers (508), making them the largest customer segment.
💰 Only 21 customers are classified as High-Value Customers, indicating that a small group contributes disproportionately to revenue.
📈 Average Profit per Customer ($365.37) is higher than the Average Order Value ($225.82), suggesting customers generate profit across multiple purchases rather than single large orders.