Publisher's Synopsis
A fully revised and updated edition, this book will guide the reader through topics such as what dirty data is, its consequences and importance in AI, the significance of data quality, and how to ensure data accuracy. Authored by a data expert, this book will guide the reader through an accurate and efficient process to classify and cleanse data of different types, such as financial data, material master data and address data, as well as demonstrate how to automate the process for data refreshes, all using Excel. In this new edition, new topics are tackled particularly around GenAI and real-life examples.This is an essential read for anyone working with data who is looking to have cleaner and more accurate data in order to improve efficiency.