Bike Sales Dashboard
Bike Sales Dashboard
Tools used:
Excel | Google Sheets
For this project, I examined the characteristics of customers for a bicycle shop.
This project began in Excel, where I cleaned the data by altering some of the labels for clarity and added customer age ranges using an IF formula.
Because the free version of Excel does not have the option to add slicers, I uploaded the workbook to Google Sheets to complete the project. The dashboard includes pivot charts, graphs, and slicers to help visualize the different characteristics of the customers, including marital status, education, and region.