A complete end-to-end analysis of 3,900 customer shopping transactions to uncover insights into spending patterns, product preferences, discount effectiveness, and subscription behavior. This project demonstrates skills in Python, SQL, Power BI, and business analytics with actionable recommendations.
-
Total Records: 3,900
-
Features: 18
-
Average Purchase Amount: $59.76
-
Average Rating: 3.75
-
Customer demographics (Age, Gender, Location)
-
Purchase details (Category, Item, Price, Season)
-
Shopping behavior (Discounts, Ratings, Frequency)
-
Subscription status
-
Shipping type
-
Python (Pandas, feature engineering, cleaning)
-
SQL (Customer analysis, segmentation, revenue queries)
-
Power BI (Dashboard and visual insights)
-
Loaded and explored data using Python
-
Handled missing values (37 Review Rating entries)
-
Created new features:
-
Age groups
-
Purchase frequency
-
-
Loaded cleaned dataset into SQL for deeper analysis
- Revenue Insights
-
Male customers generate 2.1× more revenue than female customers
-
Subscribers and non-subscribers have similar average spend
- Customer Segmentation
-
Loyal Customers: 3,116
-
Returning Customers: 701
-
New Customers: 83
- Product Performance
-
Top-rated products: Gloves, Sandals, Boots
-
Category leaders include Blouse, Jewelry, Sandals, Jacket
- Discount Strategy
-
Highest discount usage on: Hat, Sneakers, Coat
-
863 customers used discounts but still spent above average
- Shipping & Subscription
-
Express shipping customers spend slightly more
-
72% of repeat buyers are not subscribed → strong conversion potential
The interactive dashboard includes:
-
Revenue by gender & category
-
Customer segmentation
-
Top-performing products
-
Discount dependency analysis
-
Shipping & subscription behavior
-
Encourage subscription among repeat buyers
-
Optimize discount offers to protect margins
-
Promote top-rated/high-demand products
-
Target young adults and express shipping users
-
Personalize marketing based on customer segments
Customer-Behavior-Analysis/
│── data/
│── python-notebook/
│── sql-queries/
│── powerbi-dashboard/
│── report.pdf
└── README.md
Jnana Pravallika Kandiboyina
Aspiring Data Analyst | Python | SQL | Power BI