Day 6 of 30

I did a project about a month or two ago following the YouTube video from Alex the Analyst. It is his full Excel Project Tutorial. I used his bike sales data set that can be found on his GitHub.

https://github.com/AlexTheAnalyst/Excel-Tutorial/blob/main/Excel%20Project%20Dataset.xlsx

I have been following Alex Freberg for a long time and he has the fantastic content about becoming a data analyst and also technical skills and tutorials to help become a data analyst.

I had a fun time doing this project. It was fast and pretty straight forward. I did decide to change a few things to make it easier for me to present. For instance, Alex had the age groupings at "adolescent", "middle age", and "old"to categorize the different age groups. I decided to write a different formula to make these age groups more intuitive. I used the following formula to create a new column for the age brackets:

=IF(L2>=60;"60 +";IF(AND(L2>=50)*(L2<60);"50 - 59";IF(AND(L2>=40)*(L2<50);"40 - 49";IF(AND(L2>=30)*(L2<40);"30 - 39";IF(L2<30;"20 - 29";"Invalid")))))

This allowed me to have the following age brackets: "20-29", "30-39", "40-49", "50-59", and "60+". This categorization of the age brackets make it more precise for marketing needs.

Here is the final dashboard for bike sales:

Conclusion:

It seems that there is a correlation with age and distance of commute that ought to be taken into consideration for future publicity campaigns and promotions. There is a strong correlation that people use bikes and purchase bikes when the commute is less than 1 mile. This would mean that future sells should be geared towards locations with high density population and short commutes.

I really enjoyed putting this dashboard together and also figuring out how to better my formulas to have more precise visuals.