Bike Sales Dashboard

Bike Sales Dashboard with Excel

This project focuses on analyzing bike sales data to understand the purchasing behavior of customers based on various demographics and commute patterns. The goal is to provide valuable insights for targeted marketing strategies and inventory management.

INSPIRATION:
Inspired by the need to delve deeper into consumer behavior and identify trends that can enhance sales strategies, I created this project to showcase my proficiency in data analysis using Excel.

CREATION PROCESS:
Data Collection:
Gathered bike sales data including customer demographics, income levels, and commute distances.

Data Preparation:
Cleaned and organized the data for analysis.

Dashboard Development:
Utilized Excel's advanced functions and features to create interactive visualizations, including bar charts, line graphs, and pie charts.

KEY INSIGHTS:
Gender Purchase Behavior:
Males have higher average incomes and are more likely to purchase bikes compared to females.

Commute Distance:
Customers commuting 0-1 miles or more than 10 miles are more likely to purchase bikes.

Purchase by Age:
Middle-aged individuals are the largest group of bike purchasers.

Bike Purchase Behavior with Occupation:
Professionals and those in skilled manual jobs constitute the highest percentage of bike purchasers.

CONCLUSION:
This project highlighted my ability to analyze and visualize data effectively using Excel. The dashboard provides actionable insights that can help businesses optimize their marketing and sales strategies by targeting specific customer segments based on demographics and commute patterns.

Feel free to explore the dashboard to see how different factors influence bike purchasing behavior and derive insights for strategic decision-making.