Ep. 4: A Deepdive into dirty data and why Excel cannot get you out

The podcast session begins with introductions and housekeeping, followed by a discussion on the problem of dirty data and the recognition and addressing of dirty data. The conversation then delves into the challenges of merging companies, the role of AI in data quality, and the importance of data ownership. It further explores the understanding and verification of AI output, category management, and data streams, as well as ownership and responsibility for data quality. The discussion emphasizes data quality as an investment and return on investment, the challenges of dealing with existing dirty data, and the complexity of data quality and people's role in data management. The conversation covers the challenges of undocumented processes and hidden heroes, the importance of knowledge sharing and continuity, the impact of bad data on business, the implementation of AI and its challenges, and the comparison between centralized data governance and departmental decision making.Key Takeaways:Dirty data is a common problem across all industries and organizations.Data quality is an investment in the organization's efficiency and profitability. Undocumented processes and hidden heroesData quality and AI implementationCentralized data governance and operational partChapters:06:00 Challenges of Merging Companies and Change Management11:51 Data Quality as an Investment and Return on Investment22:02 The Complexity of Data Quality and People's Role in Data Management32:44 Undocumented Processes and Hidden Heroes51:06 Centralized Data Governance vs. Departmental Decision Making