Executing Data Quality Projects: Ten Steps to Quality Data and Trusted Information TM

Information is currency. Recent studies show that data quality problems are costing businesses billions of dollars each year, with poor data linked to waste and inefficiency, damaged credibility among customers and suppliers, and an organizational inability to make sound decisions. In this important and timely new book, Danette McGilvray presents her ?Ten Steps? approach to information quality, a proven method for both understanding and creating information quality in the enterprise. Her trademarked approach-in which she has trained Fortune 500 clients and hundreds of workshop attendees-applies to all types of data and to all types of organizations. * Includes numerous templates, detailed examples, and practical advice for executing every step of the ?Ten Steps? approach. * Allows for quick reference with an easy-to-use format highlighting key concepts and definitions, important checkpoints, communication activities, and best practices. * A companion Web site includes links to numerous data quality resources, including many of the planning and information-gathering templates featured in the text, quick summaries of key ideas from the Ten Step methodology, and other tools and information available online. Table of Contents Introduction The Reason for This Book Intended Audiences Structure of This Book How to Use This Book Acknowledgements Chapter 1 Overview Impact of Information and Data Quality About the Methodology Approaches to Data Quality in Projects Engaging Management Chapter 2 Key Concepts Introduction Framework for Information Quality (FIQ) Information Life Cycle Data Quality Dimensions Business Impact Techniques Data Categories Data Specifications Data Governance and Stewardship The Information and Data Quality Improvement Cycle The Ten Steps? Process Best Practices and Guidelines Chapter 3 The Ten Steps 1. Define Business Need and Approach 2. Analyze Information Environment 3. Assess Data Quality 4. Assess Business Impact 5. Identify Root Causes 6. Develop Improvement Plans 7. Prevent Future Data Errors 8. Correct Current Data Errors 9. Implement Controls 10. Communicate Actions and Results Chapter 4 Structuring Your Project Projects and The Ten Steps Data Quality Project Roles Project Timing Chapter 5 Other Techniques and Tools Introduction Information Life Cycle Approaches Capture Data Analyze and Document Results Metrics Data Quality Tools The Ten Steps and Six Sigma Chapter 6 A Few Final Words Appendix Quick References Framework for Information Quality POSMAD Interaction Matrix Detail POSMAD Phases and Activities Data Quality Dimensions Business Impact Techniques The Ten Steps? Overview Definitions of Data Categories

[1]  Malcolm Chisholm Managing reference data in enterprise databases: binding corporate data to the wider world , 2000 .

[2]  Maydanchik Arkady,et al.  Data Quality Assessment , 2008 .

[3]  Michael H. Brackett Data Resource Quality: Turning Bad Habits into Good Practices , 2000 .

[4]  Ron Hoff I Can See You Naked: A Fearless Guide to Making Great Presentations , 1988 .

[5]  Peter S. Pande,et al.  The Six Sigma way , 2007 .

[6]  Martin J. Eppler Managing Information Quality , 2003 .

[7]  Michael J. Spendolini,et al.  The Benchmarking Book , 1992 .

[8]  John Guaspari I Know It When I See It: A Modern Fable About Quality , 1985 .

[9]  Mike Biere Business intelligence for the enterprise , 2003 .

[10]  Steven C. Hill,et al.  Enterprise Architecture Planning: Developing a Blueprint for Data, Applications and Technology , 1993 .

[11]  Joseph Moses Juran,et al.  Managerial Breakthrough: The Classic Book on Improving Management Performance , 1995 .

[12]  Robert B. Grady,et al.  Software Metrics: Establishing a Company-Wide Program , 1987 .

[13]  Malcolm Chisholm,et al.  How to Build a Business Rules Engine: Extending Application Functionality through Metadata Engineering (The Morgan Kaufmann Series in Data Management Systems) , 2003 .

[14]  David C. Hay,et al.  Data model patterns : a metadata map , 2006 .

[15]  David Loshin Enterprise knowledge management: the data quality approach , 2000 .

[16]  E. Ziegel Juran's Quality Control Handbook , 1988 .

[17]  David C. Hay,et al.  Data Model Patterns: Conventions of Thought , 1965 .

[18]  Janet Wilmoth,et al.  The elementary forms of statistical reason , 1995 .

[19]  William E. Winkler,et al.  Data quality and record linkage techniques , 2007 .

[20]  Geary A. Rummler,et al.  Improving Performance: How to Manage the White Space on the Organization Chart , 1990 .

[21]  Thomas H. Lee,et al.  A New American Tqm: Four Practical Revolutions In Management , 1993 .

[22]  Len Silverston,et al.  The Data Model Resource Book , 1997 .

[23]  W. H. Inmon,et al.  Business Metadata: Capturing Enterprise Knowledge: Capturing Enterprise Knowledge , 2007 .

[24]  Jack E. Olson,et al.  Data Quality: The Accuracy Dimension , 2003 .

[25]  Peter S. Pande,et al.  The Six Sigma Way Team Fieldbook: An Implementation Guide for Process Improvement Teams , 2001 .

[26]  Masaaki Imai,et al.  Gemba Kaizen: A Commonsense, Low-Cost Approach to Management , 1997 .

[27]  Greg Brue,et al.  Design for Six Sigma , 2005 .

[28]  Roger B. Brooks,et al.  Inventory Record Accuracy: Unleashing the Power of Cycle Counting , 1992 .

[29]  M. Larry Shillito,et al.  Value: Its Measurement, Design, and Management , 1992 .

[30]  Larissa Terpeluk Moss,et al.  Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications , 2003 .

[31]  James W. Cortada,et al.  Qualitrends: 7 Quality Secrets That Will Change Your Life , 1996 .

[32]  Thomas C. Redman,et al.  Data Quality: The Field Guide , 2001 .

[33]  W. Edwards Deming,et al.  Out of the Crisis , 1982 .

[34]  Chip Conley,et al.  Peak : how great companies get their mojo from Maslow , 2007 .

[35]  Pete S. Pande,et al.  What Is Six Sigma , 2001 .

[36]  Thomas Redman,et al.  Data quality for the information age , 1996 .

[37]  Richard Y. Wang,et al.  Journey to Data Quality , 2006 .

[38]  Graeme Simsion,et al.  Data Modeling Essentials, Third Edition (Morgan Kaufmann Series in Data Management Systems) (The Morgan Kaufmann Series in Data Management Systems) , 2004 .

[39]  Thomas C. Redman,et al.  Data Quality Management and Technology , 1992 .

[40]  Ronald G. Ross,et al.  Principles of the business rule approach: Ronald G. Ross, Addison-Wesley Information Technology Series, February 2003, 256pp., price £30.99, ISBN 0-201-78893-4 , 2004, Int. J. Inf. Manag..

[41]  Latif Al-Hakim Preface to [Challenges of managing information quality in service organizations] , 2006 .

[42]  Larry P. English Improving Data Warehouse and Business Information Quality: Methods for Reducing Costs and Increasing Profits , 1999 .

[43]  M. Parker,et al.  Information Economics: Linking Business Performance to Information Technology , 1988 .

[44]  Larry Gonick,et al.  Cartoon Guide to Statistics , 1993 .

[45]  Roger C. Swanson,et al.  The Quality Improvement Handbook: Team Guide to Tools and Techniques , 1995 .

[46]  Steve Hoberman,et al.  Data Modeling Made Simple: A Practical Guide for Business and IT Professionals, , 2009 .

[47]  Dave McComb Semantics in Business Systems: The Savvy Manager's Guide , 2003 .

[48]  Edward R. Tufte,et al.  The Visual Display of Quantitative Information , 1986 .

[49]  David Loshin,et al.  Business Intelligence: The Savvy Manager's Guide , 2003 .

[50]  Carlo Batini,et al.  Data Quality: Concepts, Methodologies and Techniques (Data-Centric Systems and Applications) , 2006 .

[51]  Richard Y. Chang,et al.  Performance Scorecards: Measuring the Right Things in the Real World , 2000 .

[52]  Carol O'Rourke,et al.  Enterprise Architecture Using the Zachman Framework , 2003 .

[53]  Wayne W. Eckerson Performance Dashboards: Measuring, Monitoring, and Managing Your Business , 2005 .