Excel | Bike Sales Mini-project 

This is the final dashboard :

Data visualization:

This was my ideation process for creating the dashboard:

•  My goal was to create a one-sheet dashboard that tells the entire story

•  I wanted to create a few simple insights that would answer my questions

•  My goal was to create an interactive dashboard that would allow me to view the data from a broad perspective.

In the next video I created the pivot tables then I started preparing the dashboard :

Key Takeaways from the Data:

• North America has the highest bike sales of other regions which suggests that investing in bikes in that region could be highly profitable.

• The fact that those with good occupations and higher incomes are more likely to buy bikes implies that income level may play a role in the decision to purchase a bike.

• Both men and women are likely to purchase bikes, indicating that biking is a popular activity across genders.

Here is the final Excel workbook  :  Bike Sales Mini-Project.xlsx