Customer Behaviour Analytics

How do purchase patterns and customer characteristics vary across categories, age brackets and subscription status?

Customer shopping records covering product categories, age brackets, subscription status, purchase amounts and review ratings.

1. 01Clean and prepare records
2. 02Compare segments in SQL and exploratory analysis
3. 03Build an interactive Power BI dashboard
4. 04Review category, age and subscription patterns

Compared revenue and purchase volume across Clothing, Accessories, Footwear and Outerwear, and examined results across age brackets and subscription status.

What I builtInteractive customer behavior dashboard with KPI, category, age and subscription views.

• 01

  Non-subscribers made up 73% of customers; subscribers made up 27%.

• 02

  Average purchase amount was $59.76; average review rating was 3.75.

• 03

  The dashboard compared category performance and customer patterns across four age brackets.