On this episode, Gordon Hamilton and I discuss data quality key concepts, including those which we have studied in some of our favorite data quality books, and more important, those which we have implemented in our careers as data quality practitioners.
Gordon Hamilton is a Data Quality and Data Warehouse professional, whose 30 years’ experience in the information business encompasses many industries, including government, legal, healthcare, insurance and financial. Gordon was most recently engaged in the healthcare industry in British Columbia, Canada, where he continues to advise several health care authorities on data quality and business intelligence platform issues.
Gordon Hamilton’s passion is to bring together:
- Exposure of business rules through data profiling as recommended by Ralph Kimball.
- Monitoring business rules in the EQTL (Extract-Quality-Transform-Load) pipeline leading into the data warehouse.
- Managing the business rule violations through systemic and specific solutions within the statistical process control framework of Shewhart/Deming.
- Researching how to sustain data quality metrics as the “fit for purpose” definitions change faster than the information product process can easily adapt.
Gordon Hamilton’s moniker of DQStudent on Twitter hints at his plan to dovetail his Lean Six Sigma skills and experience with the data quality foundations to improve the manufacture of the “information product” in today’s organizations. Gordon is a member of IAIDQ, TDWI, and ASQ, as well as an enthusiastic reader of anything pertaining to data.
Studying Data Quality
Additional listening options:
Recommended Data Quality Books
By no means a comprehensive list, and listed in no particular order whatsoever, the following books were either discussed during this OCDQ Radio episode, or are otherwise recommended for anyone looking to study data quality and its related disciplines:
- Data Driven: Profiting from Your Most Important Business Asset by Thomas Redman
- The Practitioner’s Guide to Data Quality Improvement by David Loshin
- Information Quality Applied: Best Practices for Improving Business Information, Processes and Systems by Larry English
- Executing Data Quality Projects: Ten Steps to Quality Data and Trusted Information by Danette McGilvray
- The Data Governance Imperative by Steve Sarsfield
- Data Quality Assessment by Arkady Maydanchik
- Data Quality: The Accuracy Dimension by Jack Olson
- Entity Resolution and Information Quality by John Talburt
- Practical Data Migration by John Morris
- Customer Data Integration: Reaching a Single Version of the Truth by Jill Dyché and Evan Levy
- Master Data Management in Practice: Achieving True Customer MDM by Dalton Cervo and Mark Allen
- Journey to Data Quality by Yang Lee, Leo Pipino, Richard Wang, James Funk
- Quality Without Tears: The Art of Hassle-Free Management by Philip Crosby
- Out of the Crisis by W. Edwards Deming
- Juran’s Quality Handbook: The Complete Guide to Performance Excellence (Sixth Edition) by Joseph Juran
PLEASE NOTE: You are welcome to recommend additional books for this reading list by posting a comment below.