ANALYSIS OF BIKE SALES IN EXCEL

I got this raw dataset from Kaggle.com and took the following steps before visualization:

• I used Replace value function to format marital and gender columns by writing Male and Female in full, instead of M and F, I also replaced S and M with Single and Married.

• I formatted the Commute distance and income columns.

• I used the IF statement to break the age into 3 categories (young, adolescents and Old).

• I used the pivot table function to prepare for my dashboard.

• I used the slicers, so filtering can be much easier

INSIGHTS

• Customers within the middle age bracket purchased more bikes.

• The higher the average income per person, the higher the number of bikes purchased.

• The old category had the least number of bikes purchased.

• The shorter the distance, the lower the interest in purchasing bikes.