Bike Sales Analysis

Photo from Outside

Data Analysis using Microsoft Excel

The Data

The public dataset, Bike_Sales, is provided.

Objectives

• To prepare the dataset by restructuring in a more logical manner.
• Seek out any trends or patterns in the sales data to influence key business decisions.

Project Activities

• Data Cleaning and Preparation
• Pivot Tables for quick summaries
• Data Visualization

Key Business Insights

• The Youth Age group are globally the poorest in orders & sales.
• Female Adults are buying the most products.
• The United Kingdom and Australia markets have orders from all the customer genders and age_groups.
• Only the UK, Australia and France have orders from the Youth age_group.

View Charts View live dashboard