Example Dataset
|
Customer |
City |
Product |
Quantity |
Sales |
|
Amit |
sirsa |
Keyboard |
5 |
4000 |
|
Neha |
Hisar |
Mouse |
10 |
5000 |
|
Rahul |
SIRSA |
Monitor |
3 |
25500 |
|
Neha |
Hisar |
Mouse |
10 |
5000 |
The dataset contains:
- Extra spaces
- Inconsistent capitalization
- Duplicate records
Transformation 1 — Remove Duplicates
Remove the repeated Neha record.
Transformation 2 — Clean Text
Use Power Query transformations to clean unnecessary spaces.
Transformation 3 — Standardize Text
Convert city names to a consistent format.
For example:
sirsa
SIRSA
Sirsa
should become consistently represented.
Transformation 4 — Change Data Types
Set:
- Quantity → Whole Number
- Sales → Decimal/Currency as appropriate
- Date → Date
Transformation 5 — Filter Rows
Keep only:
City = Sirsa
Result
|
Customer |
City |
Product |
Quantity |
Sales |
|
Amit |
Sirsa |
Keyboard |
5 |
4000 |
|
Rahul |
Sirsa |
Monitor |
3 |
25500 |
Practice
Take a deliberately messy dataset and perform at least five Power Query transformations.