Customer Purchase Analysis

This is a project created to showcase data analysis and dashboard design skills using Excel. The dataset is fictional and used for demonstration purposes only.

📂 Project Overview

The goal of this project is to analyze customer purchase behavior and extract insights that can support business decisions. I built an Excel Dashboard with interactive charts and pivot tables.

🔑 Key Analysis

👥 Customer Demographics → Average age, gender distribution

💰 Purchase Behavior → Total & average purchase amount

📅 Seasonal Trends → Purchase amount per season

🎯 Top Customers → Customers with the highest purchase amount

🔄 Purchase Frequency → Weekly, fortnightly, quarterly, annually

📊 Pareto Analysis (80/20 Rule) → High, Medium, Low value customers

📊 Dashboard Preview

🛠 Tools Used

Dataset Source : Kaggle.com

Microsoft Excel (Pivot Table, Charts, Vlookup, Dashboard Design)

Dummy Dataset (CSV/Excel format)

🚀 Insights

Majority of customers are in the 20–30 years old segment → campaigns can be targeted to millennials.

Clothing is the most popular category, while Outerwear generates the highest revenue.

20% of customers contribute ~80% of total purchases → loyalty program can focus on these VIP customers.