Shopping Behavior Trend
About
This tableau project was conducted using shopping behavior dataset from Kaggle. This dataset contains Customer ID, Age, Gender, Item Purchased, Category, Purchase Amount (USD), Location, Size, Color, Season, Review Rating, Subscription Status, Shipping Type, Discount Applied, Promo Code Use, Previous Purchases, Payment Method, Frequency of Purchases columns. This project aimed to glean insightful information about trends in shopping behavior that can help with business strategies and stock of items sold to meet customer needs.
Insights
- Item Purchased by Season
- Item Color by Season
- Average Purchase Amount Per Location
- Frequency Purchases Per Item
- Percentage of Payment Methods
- Percentage of Discount Applied
Stacked bar chart to visualize the number of items purchased based on season. This visualization can help businesses with stock of each item for a specific season.
Stacked bar chart to visualize the amount of color purchased based on season. This visualization can help the producer to create product based on the most sold item color for a specific season.
Line chart visualized average purchase amount per location. Alaska had the highest purchase amount. This visualization can help businesses enhance marketing strategies to get better sales for other locations and to evaluate locations with the lowest purchase amount.
Stacked bar chart visualized frequency purchases per item. The frequencies are annually, bi-weekly, every 3 months, fortnightly, monthly, quarterly, and weekly. This frequency can help businesses to enhance sales to customers and do strategies marketing.
The table showed about percentage of each payment method. 6 methods have similar percentages. This table can help businesses to provide methods based on customer needs.
The discount applied table showed the percentage of using discount was lower than not using. This data can be used for businesses to create marketing strategies about this discount data.
