This project analyzes customer purchasing behavior in the bike market using Microsoft Excel. The dataset was cleaned and transformed to ensure data accuracy before performing exploratory data analysis. Interactive dashboards were developed to provide meaningful insights into customer demographics and purchasing trends.
- Data Cleaning and Preprocessing
- Pivot Tables for Data Analysis
- Interactive Dashboard Creation
- Dynamic Slicers for Filtering Data
- Customer Demographic Analysis
- Visual Insights through Charts and Graphs
- Relationship between age groups and bike purchases
- Regional distribution of bike buyers
- Impact of education level on purchasing decisions
- Analysis based on marital status
- Customer segmentation and trend identification
- Microsoft Excel
- Pivot Tables
- Pivot Charts
- Slicers
- Dashboard Design
Dashboard Screenshot: Dashboard View
Excel Workbook: Working Dataset View
Dataset Sheet: Raw Dataset View
The dashboard enables users to explore bike purchasing patterns across different customer segments and supports data-driven decision-making through interactive visualizations.