In this project we use Excel formula to clean the data, then create a pivot table for easy analysis and visualization, resulting in a presentable chart.
Click link to download the dataset on Kaggle.
Insights
- The majority of bike purchases occur in North America.
- Single individuals have a higher average income per bike purchase compared to married ones.
- Customers with a graduate degree make up the largest group of bike purchasers.
- 40-54 age group has the highest count of purchased bikes, closely followed by the 20-39 age group.
- A significant number of customers commute either 0-1 miles or more than 10 miles.
aCTIONABLE Insights
- Target North America: Focus marketing efforts on North America to capitalize on the existing interest in bikes in this region.
- Segmentation Strategy:
- Singles: Tailor advertising campaigns to target single individuals, as they represent a significant customer segment.
- Graduate Degree Holders: Develop special offers or promotions for customers with graduate degrees.
- Age Groups: Create targeted promotions for the 40-54 and 20-39 age groups to boost sales.
- Product Development:
- Consider developing products or services specifically catered to short-distance commuters (0-1 miles) and long-distance commuters (more than 10 miles).
