Skip to content
Project number
Project / 014
Year
2024
Category
Analytics
Status
Completed

Excel Bike Sales Dashboard

Cleaning a raw bike sales dataset in Excel so it is ready for analysis.

Stack
Excel
Tags
Dashboard

01 /Overview

The raw sales data had errors, duplicates, inconsistent formats and missing values.

02 /What I built

  • Cleaning functions: TRIM, CLEAN, IFERROR, ISNUMBER, TEXT
  • Cross-checks with lookup formulas (VLOOKUP, INDEX and MATCH)
  • Duplicates removed and missing values handled
  • Validation rules to prevent future entry errors

03 /Outcome

A clean, validated dataset with before-and-after versions published in the repository.

04 /What I learned

Most analysis time is spent before the first chart. Clean data makes every later step faster and more trustworthy.