Business analysis glossary
Data Cleansing
What it is
Data cleansing is correcting or removing data that is wrong, incomplete, duplicated or badly formatted, for example merging duplicate customers, standardising date formats, fixing invalid codes or filling missing values from a trusted source. It can be done by rules, tools or manual review.
Why it matters
Poor data spreads into every report, interface and decision that uses it. Cleansing before a migration or a new report saves far more effort than fixing problems afterwards. Analysts define cleansing rules with data owners and decide which issues must be fixed before go live and which can wait.
Example
Before migrating vendor records, the finance team cleanses data the analyst flagged: two hundred duplicate vendors are merged by GSTIN, invalid IFSC codes are corrected from bank letters and vendors with no payment in five years are archived. The migration then loads clean master data into the new system.