This project is a demo/portfolio dashboard built in Power BI using Power Query for data shaping and transformation. The goal of the dashboard is to segment customers based on their purchase behavior, frequency, and value, enabling better understanding of retention strategies and customer insights.
- Power BI – Dashboard creation, DAX measures, visuals
- Power Query – Data transformation and preprocessing
- Total Customers
- Average Lifetime Value
- Usual Tenure Length
- Purchase Rhythm (Days)
- Payment Method Trends → Line/area chart showing distribution across UPI, credit card, COD, wallet
- Customer Frequency Segmentation → Pie chart classifying customers into Low, Mid, High frequency
- Customers by Devices → Pie chart showing device preferences (Mobile, Desktop, Tablet)
- Customer Value by Age Group → Bar chart comparing average lifetime value across age groups
- Frequent Categories by Gender → Stacked bar showing product category distribution by gender
- Year filter (2023/2024)
- Seasonal segmentation (Autumn, Monsoon, Summer, Winter)
- Majority of customers fall under Mid Frequency (49.7%).
- Mobile dominates as the preferred device (~58%).
- Seniors and Young Adults show the highest average lifetime value.
- UPI is the most common payment method.
- Product preferences vary by gender, with notable differences across ethnic, casual, and sports categories.
Ashirbad Routray
September 2025