This project analyzes customer behavior to uncover patterns in purchasing, revenue distribution, and customer segmentation. The goal is to provide actionable insights for business decision-making.
- Python (Pandas)
- SQL
- Power BI
- Revenue comparison by gender
- Customer segmentation (New, Returning, Loyal)
- Impact of discounts on purchasing behavior
- Subscription vs non-subscription analysis
- Top-performing products by category
- Revenue contribution by age group
The Power BI dashboard provides interactive visualizations of key metrics such as:
- Total revenue
- Customer segmentation
- Product performance
- Subscription trends
customer_shopping_behavior.csv→ Datasetcustomer_behavior.sql→ SQL queriescustomer_behavior_dashboard.pbix→ Power BI dashboardCustomer_Behavior_Analysis_Report.pdf→ Final report
- Loyal customers contribute significantly to total revenue
- Subscribed customers tend to spend more
- Discounts influence both low and high-value customers
- A few products dominate sales across categories
This project demonstrates how data can be transformed into meaningful insights using data analysis and visualization tools.
Vishal Biswas