This Bike Sales Dashboard is an interactive Excel-based visualization tool designed to analyze and interpret customer purchasing behavior for bike sales. The dashboard provides insights into how demographics and regional factors affect bike purchases, helping businesses better understand their target market.
-
Marital Status:
- Married
- Single
-
Education:
- Graduate Degree
- Bachelors
- High School
- Partial College
- Partial High School
-
Region:
- Europe
- North America
- Pacific
- Purpose: Compare the average income of male and female customers.
- Insight:
- Male customers earn more on average (
$53,000) compared to females ($48,333). - A higher number of males purchased bikes.
- Male customers earn more on average (
- Purpose: Show bike purchases across different age groups.
- Brackets:
- Adolescent (0–31)
- Middle Age (31–56)
- Old (56–89)
- Insight:
- Middle-aged customers (31–56) are the largest group of buyers.
- Purpose: Analyze bike purchase behavior based on commute length.
- Categories:
- 0–1.1 Miles
- 1–2 Miles
- 2–5 Miles
- 5–10 Miles
- 10 Miles Plus
- Insight:
- Most purchases come from customers with the shortest commutes (0–1.1 miles).
- Sales decrease as commute distance increases.
- Open the Excel dashboard.
- Use slicers on the left to filter data by marital status, education level, and region.
- All charts update automatically to reflect filtered data.
- Higher income customers, especially males, are more likely to purchase bikes.
- Middle-aged individuals are the most active buyers.
- People with shorter commute distances are more inclined to buy bikes.
- Tool Used: Microsoft Excel
- Features: PivotTables, Slicers, Bar and Line Charts
- File Format:
.xlsx
This Bike Sales Report Analysis was created based on guidance from Alex The Analyst. His tutorial helped shape the dashboard and its features. You can find the original tutorial here.