- 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.
