Joyce's_Portfolio

Excel Analytics Project #BIKE PURCHASE BEHAVIOUR ANALYSIS

This project analyzes a dataset of customer demographics and lifestyle data to identify patterns in bike purchasing behavior. It was completed using Microsoft Excel for data cleaning, visualization, and basic analysis.

---

Dataset Overview

The dataset includes the following features:

• ID
• Marital Status
• Gender
• Income
• Children
• Education
• Occupation
• Home Owner
• Cars
• Commute Distance
• Region
• Age Group
• Age
• Purchased Bike (Yes/No)

---

Project Goals

• Identify trends and patterns that influence bike purchases.
• Visualize relationships between commute distance, age, and bike purchases.
• Use Excel tools like pivot tables and charts to derive insights.

---

Tools Used

• Microsoft Excel
  • Pivot Tables
  • Bar/Column Charts
  • Slicers
  • Data Cleaning (Remove Duplicates, Formatting)

---

Key Visualizations

• Bike Purchases by Gender
• Bike Purchases by Commute Distance
• Bike Purchases by number of children
• Age Group vs Bike Purchase Status
• Occupation and Home Ownership Influence

---

Key Insights

• Customers with shorter commute distances are more likely to buy bikes.
• Customers with 0 children make the most bike purchases, with a steady decline in purchases as the number of children increases.
• Bike purchase likelihood varies across age groups and regions
• Slightly higher purchase rate among females,Gender does not show a strong influence on bike purchasing behaviour.