Each episode puts the lights on various data topics with renowned industry experts. We cover the following topics in a fun and informative interview format: data science, data analytics, machine learning, artificial intelligence, data visualization, data storytelling, data governance, data management, data quality, data strategy, and much more.
https://www.lightsondata.com/
episode 5: 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.