top of page

Create Your First Project

Start adding your projects to your portfolio. Click on "Manage Projects" to get started

Bike Sales Dashboard

Date

March 2023

Project type

Excel

Based on a guided project created by Alex Freburg, this dashboard displays data about potential customers for a fictional bike store. The original data was obtained from an Excel file through Github.

Through this project, I was able to
-Clean dirty data through the application of different functions and filters in Excel
-Create pivot tables based on customer information to analyze patterns in customer purchases
-Design an interactive dashboard to display the results of my analysis

Questions I answered with the data included:
-How does the location of a customer affect their needs when purchasing a bike?
-What age group is most likely to buy a bike? Least likely?
-Does the education level of a customer affect their likelihood of purchasing a bike?

bottom of page