Data cleansing: Used in the data preparation phase, this is when raw data is put in a format suitable for analysis by eliminating data that is incorrect, incomplete, or irrelevant.

Whether you call it data preparation, mining, extracting, cleaning, joining, blending, or masking, it’s all data transformation. Professionals can spend hours every week working with their data, ...