BIKE SALES DASHBOARD

An interactive Excel dashboard analysing bike purchase behaviour across customer demographics and key purchasing factors.

Bike Sales Excel Dashboard

PROJECT OVERVIEW

This project uses Microsoft Excel to analyse bike purchase behaviour across customer demographics. The dashboard transforms the underlying dataset into interactive visual insights using Pivot Tables, Slicers and dashboard visualizations.

KEY ANALYSIS

The analysis focuses on the relationship between income and purchase likelihood by gender, purchasing behaviour across different age brackets, and the impact of commute distance on bike purchase decisions.

TOOLS & TECHNOLOGIES

Microsoft Excel   |   Pivot Tables   |   Slicers   |   Interactive Dashboard Design

KEY INSIGHTS

  • Analysed income versus bike purchase likelihood across gender groups.
  • Compared bike purchasing behaviour across Adolescent, Middle Age and Old age brackets.
  • Examined the relationship between commute distance and bike purchase decisions.

DASHBOARD OVERVIEW

The interactive dashboard allows users to explore purchasing patterns across customer demographics and filter the analysis using Excel Slicers.

PROJECT REPOSITORY

The complete Excel workbook, dataset and dashboard preview are available on GitHub.