This Excel project involves creating a comprehensive dashboard for bike sales, utilizing data cleaning, pivot tables, and visualizations. The goal is to provide a user-friendly dashboard where users can interact with the data, exploring bike sales insights based on various demographics.
- Average Income per Purchase: Income distribution of customers based on purchase status.
- Conversion Rate by Gender: Percentage of male and female customers who purchased bikes.
- Purchase Trends by Age Bracket: Comparison of purchases between middle-aged and older customers.
- Commute Distance vs. Purchases: Insights into commute distances of customers who purchased bikes.
- Regional Purchase Analysis: Bike purchase trends across Europe, North America, and Pacific regions.
- Data Cleaning: Identify and remove duplicates, standardize categorical data (e.g., marital status, gender).
- Create Working Sheet: Copy raw data to a working sheet for manipulation, keeping the original data intact.
- Pivot Tables: Utilize pivot tables to summarize and analyze data for visualization.
- Visualizations: Build visualizations using recommended charts to represent key insights, such as average income, commute distance, and age brackets.
- Dashboard Creation: Copy visualizations onto a dashboard sheet for a consolidated view.
- Chart Customization: Adjust chart titles, axis labels, and formatting for better clarity.
- Download the dataset from the provided GitHub repository link.
- Explore the interactive dashboard to gain insights into bike sales based on various demographics.
- Contribute or modify the project as needed for your specific requirements.