Skip to content

FaithKangogo/bike-sales-dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

6 Commits
Β 
Β 
Β 
Β 

Repository files navigation

🚲 Bike Sales Dashboard (Excel Project)

Welcome! This is my first portfolio project, where I used Microsoft Excel to analyze a bike sales dataset and build an interactive dashboard.

πŸ”— Full Walkthrough & Insights β†’ Read the full article on Medium


πŸ” Project Overview

Using Excel, I:

  • Cleaned and transformed raw data
  • Created pivot tables to analyze key trends
  • Built charts to visualize gender, income, commute distance, and age-related purchase behaviors
  • Developed an interactive dashboard with slicers for deeper exploration

πŸ’‘ Key Skills Demonstrated

  • Data Cleaning & Transformation
  • Pivot Table Design
  • Chart Formatting & Visualization
  • Interactive Dashboard Development with Slicers

πŸ“‚ Files Included

  • Bike_Sales_Dashboard.xlsx – Final Excel file with pivot tables, charts, and dashboard

πŸ“Œ What's Next

I’m actively working on projects using:

  • SQL
  • R
  • Python
  • Power BI

Stay tuned!

πŸ“¬ Feedback is always welcome!