Dirty data is a problem that costs businesses thousands, if not millions, every year. In organisations large and small across the globe you will hear talk of data quality issues. What you will rarely hear about is the consequences or how to fix it.
Between the Classifying and Fixing Dirty Data draws on classification expert Susan Walsh’s decade of experience in data classification to present a fool-proof method for cleaning and classifying your data. The book covers everything from the very basics of data classification to normalisation and taxonomies, and presents the author’s proven COAT methodology, helping ensure an organisation’s data is Consistent, Organised, Accurate and Trustworthy. A series of data horror stories outlines what can go wrong in managing data, and if it does, how it can be fixed.
After reading this book, regardless of your level of experience, not only will you be able to work with your data more efficiently, but you will also understand the impact the work you do with it has, and how it affects the rest of the organisation.
Written in an engaging and highly practical manner, Between the Spreadsheets gives readers of all levels a deep understanding of the dangers of dirty data and the confidence and skills to work more efficiently and effectively with it.
Pretty good if you happen to belong to the very niche audience of people willing to read a whole book about spreadsheets... And since I am the first person to give it a rating on Goodreads, I can only assume that that niche is tiny. I wrote a blog post about it too. I'm a slave to the data.
Ensuring your data are as clean as possible is essential for any analysis work, and this book is an excellent introduction to the topic. Walsh also gives excellent lectures on the topic, so avail of those too if you have the chance.