Skip to content

Latest commit

 

History

History
27 lines (20 loc) · 1.09 KB

README.md

File metadata and controls

27 lines (20 loc) · 1.09 KB

Bike Sales Analysis

Mountain Bikes

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