Bike Store Sales Analysis

Project Overview

This project seeks to analyze the Biker store's sales data to understand its performance, customer demograpgics, purchasing patterns, and key drivers of revenue.

Data Sources

The primary data source for this project is a dataset containing customer and sales information, including the following columns:

• Customer_ID
• Age Bracket
• Purchase Bike (Yes/No)
• Income
• Gender
• Marital Status
• commute_distance
• Region
• Cars (number of cars owned)
• occupation
• Education
• Home Owner (Yes/No)
• Children (number of children)

Tools

• Excel (for data exploration and visualization)

Data Cleaning/Preparation

In the initaial preparation phase, we performed the following task:

1. Removing duplicates
2. Data type conversion
3. Correcting inconsistent data
4. Creating the Age Bracket using the IF function

Exploratory Data Analysis