Bike Sales Analysis Dashboard using Excel

To achieve the goal of this project, I have completed several tasks.

✅ Firstly, Understanding the provided dataset.

✅ Then I performed data cleaning to remove any duplicates, spaces, and special characters, find and replace, and formatting.

✅ Created custom columns (Age Brackets) to extract additional information from the dataset.

✅ Created Pivot tables, Charts, and Graphs 📊 to summarize the data and visually get quick information and make it easier to understand.

✅ Finally, I built a dashboard in Excel with slicers, which allows users to interact with the data and view it in different ways.

Key insights :

✅ The maximum average income of Males is $60,124. So, they purchased bikes more as compared to females who got 7% less average income than males.

✅ People in the Middle Age group (31-54 years) purchased 4 times more bikes as compared to the Adolescent and Old age groups.

✅ Customers tend to purchase bikes more for shorter commutes (0-1 miles) than longer commutes (10 miles +)