This Customer Purchase Analysis dashboard analyzes 500K customer purchase patterns, demographics, and behavior from an e-commerce platform. Built in Microsoft Power BI, it reveals mobile dominance, loyalty program impact, and regional insights to support data-driven e-commerce optimization decisions.
Key Features & Capabilities
Customer Demographics
Age distribution, regional analysis, and device preferences with interactive filters
Purchase Behavior
Product categories, session-purchase correlation, and loyalty program impact analysis
Customer Segmentation
Regular, Premium, and VIP customer analysis with conversion rates and satisfaction metrics
Business Insights
Mobile dominance (54.43%), loyalty impact (8.4% higher conversion), and regional patterns
Technical Implementation
- Data Source: Kaggle – Customer Purchase Behavior Dataset (500K records)
- Model: Customer segmentation with demographic and behavioral analysis
- Visuals: Interactive charts, donut charts, scatter plots, gauge charts, and KPI cards
- Filters: Customer segment, loyalty program, region, device, and referral source
Key Findings
- Mobile Dominance: 54.43% of customers prefer mobile devices over desktop (31.2%) and tablet (14.36%)
- Loyalty Impact: Loyalty program members convert 8.4% higher than non-members (46.0% vs 37.6%)
- Regional Patterns: South region has highest customer concentration, followed by North, West, and East
- Product Performance: Fashion (22.27%) and Kitchen (21.54%) categories perform best