BIKE SALES ANALYSIS USING EXCEL

Project: ANALYSIS OF BIKE SALES

Tool used: Excel

Description

The project is an analysis of the sales of bikes by company in relation to various customer dynamics. The objectives of the project was to determine:

• Total purchases
• Purchases trend depending on customer's gender, occupation, location, marital status, average income, commute distance, car ownership status, age bracket and level of education.

Project Execution

• Data cleaning using Excel to ensure correct formats
• Creation of pivot tables to show the various data relationships
• Creation of visualizations and use of slicers to establish relationships between various data sets, to answer the project objectives.