Compare buyers and non-buyers
Charts preserve the distinction between purchase outcomes across demographic dimensions.
Dashboard / Excel
Bike Sales Analysis
The patterns behind
a purchase.
Exceldashboard workspace
4comparison views
3slicer categories
An Excel dashboard exploring bike purchases across demographic groups, income, commute distance, and regional filters.
Understand who buys, and why.
Sales totals alone do not explain which groups purchase bikes or how commuting and income relate to demand.
A deliberate path through the problem.
The workbook puts purchase comparisons in one place, with views for commute distance, average income, age brackets, and individual ages. Slicers narrow the view by marital status, education, and region.
SYSTEM / BIKE-SALES01 → 04
01Sales recordsPurchase + demographics
02Pivot viewsGroup + compare
03SlicersSelect a segment
04DashboardRead demand patterns
The choices that shape the work.
Bring context into the view
Commute distance and average income sit beside age-based comparisons.
Explore a selected segment
Regional, education, and marital-status slicers support a narrower reading of the workbook.
What the project delivers.
The GitHub README publishes both a dashboard preview and the Excel workbook, making the analysis available for further exploration.
FROM THE REPOSITORYDashboard & workbook ↗
Give each segment a voice.
The useful unit is a comparison: a dashboard becomes more informative when a visitor can compare purchase behavior within a specific segment.