Bike Sales Dashboard Project(Interactive Dashboard creation using MS Excel)

Project Overview

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.

DataSet Used

• DataSet

KPIs

• 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.

Key Steps in the Project

1. Data Cleaning: Identify and remove duplicates, standardize categorical data (e.g., marital status, gender).
2. Create Working Sheet: Copy raw data to a working sheet for manipulation, keeping the original data intact.
3. Pivot Tables: Utilize pivot tables to summarize and analyze data for visualization.
4. Visualizations: Build visualizations using recommended charts to represent key insights, such as average income, commute distance, and age brackets.
5. Dashboard Creation: Copy visualizations onto a dashboard sheet for a consolidated view.
6. Chart Customization: Adjust chart titles, axis labels, and formatting for better clarity.

Dasboard

Instructions for Use

1. Download the dataset from the provided GitHub repository link.
2. Explore the interactive dashboard to gain insights into bike sales based on various demographics.
3. Contribute or modify the project as needed for your specific requirements.