Tips for Fixing Dirty Data

Our today's guest is Susan Walsh, the Classification Guru, the Founder and Managing Director of The Classification Guru Ltd, and the author of "Between the Spreadsheets: Classifying and Fixing Dirty Data." In this episode we address: Tips on fixing dirty data;  The perfect date format;  Normalization, standardization, and taxonomies;  Procurement and spend data;  Mixing fruits with savory;  What is dirty data and how can you fix it? You're expected to cleanse data, but very few are trained on how to do it so here are some tips to get you started.