Data Cleaning Exercises

Glossary

Outlier

A value far from the rest. Possibly an error, possibly the most important row.

Flag outliers for review; don't delete or cap them silently. Negative refunds are usually valid, not outliers to remove.

Related: Validation rule