SPROCKET CENTRAL BIKE SALES DASHBOARD (VIRTUAL INTERNSHIP WITH FORAGE AND KPMG)

As part of my virtual internship project, I obtained this dataset from forage.com. The dataset was presented to me in a dirty format, with the expectation that I would check for data quality, clean it, and visualize it. I went through the data and found many missing, irrelevant values, and unnecessary abbreviations within cells, so I used Power Query to clean up with the following steps:

• I removed the missing values.

• Replaced cell abbreviations with full values.

• I eliminated outliers and irrelevant columns.

• I added new columns for age bins and birth years.

• I added new measures to calculate total cost of production, total profit, and profit margin; and finally, I loaded the cleaned data into my PowerBi report page for visualization.

INSIGHTS

• The manufacturing industry provided the highest number of bike sales.

• Customers within the age of 40 accounted for the total number of sales, resulting in the highest profit generated from this age bracket.

• Customers aged 70 to 90 recorded a low number of bike sales, as expected.

• By wealth segment, mass customers provided us with the most sales.

• The total profit for the period is around ten million dollars.

RECOMMENDATIONS

• The marketing team should focus more on IT industry customers, who accounted for the lowest sales.

• More marketing awareness should be directed toward Queensland, which had the lowest sales volume in the state category.