Skip to content

Latest commit

 

History

History
68 lines (47 loc) · 2.9 KB

README.md

File metadata and controls

68 lines (47 loc) · 2.9 KB

Bike Purchase Analysis in Excel

Overview

This repository contains an in-depth analysis of bike purchases based on a comprehensive dataset. The analysis includes customer demographics and purchasing details, presented through interactive visualizations in an Excel dashboard.

Dataset

The dataset, stored in an Excel file named bike_purchase_data.xlsx, encompasses vital information on bike purchases, including customer demographics and purchasing details.

Key Data Columns:

  • ID: Unique identifier for each customer.
  • Marital Status: Marital status of the customer.
  • Gender: Gender of the customer.
  • Income: Customer's income.
  • Children: Number of children.
  • Education: Customer's education level.
  • Occupation: Customer's occupation.
  • Home Owner: Indicates whether the customer owns a home.
  • Cars: Number of cars owned by the customer.
  • Commute Distance: Distance of the customer's commute.
  • Region: Geographic region.
  • Age: Customer's age.
  • Age Range: Categorized age range.
  • Purchased Bike: Indicates if a bike was purchased.

Visualizations

Explore the dataset through the following interactive visualizations:

  1. Occupation by Count of ID and Sum of Cars - Clustered Bar Chart:

    • Visual representation of the count of IDs and the sum of cars based on occupation.

  2. Age Range by Sum of Cars - Clustered Column Chart:

    • Clustered column chart displaying the sum of cars for each age range.

  3. Miles by Purchased Bike Count - Line with Markers:

    • Line chart with markers depicting the correlation between miles and the count of purchased bikes.

  4. No. of Cars by No. of Bikes Purchased - Line with Markers:

    • Line chart with markers illustrating the relationship between the number of cars and the count of bikes purchased.

  5. Region by Purchased Bike - Stacked Line with Markers:

    • Stacked line chart with markers showcasing bike purchases in different regions.

  6. Average Income by Region - Clustered Bar Chart:

    • Clustered bar chart presenting the average income in each region.

  7. Home Owners by Count of Children - Clustered Bar Chart:

    • Clustered bar chart indicating the count of home owners based on the number of children.

  8. Count of Home Owners by Education and Occupation - Clustered Column Chart:

    • Clustered column chart illustrating the count of home owners categorized by education and occupation.

Slicers

Two slicers are available for interactive exploration:

  • Gender Slicer: Allows users to filter data based on gender.
  • Marital Status Slicer: Enables users to focus on specific marital statuses.

How to Use:

  1. Clone or download this repository.
  2. Open the Excel file bike_purchase_analysis.xlsx.
  3. Navigate to the "Dashboard" sheet to access the interactive visualizations.
  4. Use the slicers to dynamically control the visuals based on gender and marital status.