This project is part of the Alex The Analyst Excel Bootcamp. It involves cleaning, analyzing, and visualizing a bike sales dataset using Microsoft Excel.
The dataset contains customer demographic and lifestyle data, along with whether they purchased a bike or not.
Key goals:
- Understand which customer segments are most likely to purchase a bike.
- Explore trends by Gender, Age, Income, Commute Distance, and Region.
- Build an interactive dashboard to present insights.
| Column Name | Description |
|---|---|
| Marital Status | Married or Single |
| Gender | Male or Female |
| Income | Annual Income |
| Education | Education Level |
| Occupation | Job type |
| Home Owner | Yes or No |
| Cars | Number of cars owned |
| Commute Distance | Typical commute |
| Region | Geographic region |
| Age | Customer's age |
| Purchased Bike | Yes or No (Target variable) |
The Excel Dashboard provides:
- Average Income per Purchase by Gender
- Bike Purchases by Age Brackets
- Purchases Based on Commute Distance
- Interactive Slicers for:
- Marital Status
- Region
- Education
- Gender
- Commute Distance
- Microsoft Excel
- Pivot Tables
- Charts (Bar, Line)
- Slicers
- Dashboard Design
- Designing interactive dashboards in Excel
- Using slicers and pivot tables effectively
- Data-driven storytelling for business use cases
