Product data quality in supply chains: the case of Beiersdorf

A number of business requirements (e.g. compliance with regulatory and legal provisions, diffusion of global standards, supply chain integration) are forcing consumer goods manufacturers to increase their efforts to provide product data (e.g. product identifiers, dimensions) at business-to-business interfaces timely and accurately. The quality of such data is a critical success factor for efficient and effective cross-company collaboration. If compliance relevant data (e.g. dangerous goods indicators) is missing or false, consumer goods manufacturers risk being fined and see their company’s image damaged. Or if logistics data (e.g. product dimensions, gross weight) is inaccurate or provided not in time, business with key account trading partners is endangered. To be able to manage the risk of business critical data defects, companies must be able to a) identify such data defects, and b) specify and use metrics that allow to monitor the data’s quality. As scientific research on both these issues has come up with only few results so far, this case study explores the process of identifying business critical product data defects at German consumer goods manufacturing company Beiersdorf AG. Despite advanced data quality management structures such defects still occur and can result in complaints, service level impairment and avoidable costs. The case study analyzes product data use and maintenance in Beiersdorf’s ecosystem, identifies typical product data defects, and proposes a set of data quality metrics for monitoring those defects.

[1]  P. Mouncey Improving Data Warehouse and Business Information Quality , 2001 .

[2]  Diane M. Strong,et al.  AIMQ: a methodology for information quality assessment , 2002, Inf. Manag..

[3]  Stuart E. Madnick,et al.  Editorial for the Inaugural Issue of the ACM Journal of Data and Information Quality (JDIQ) , 2009, JDIQ.

[4]  Frank Y. Chen,et al.  Quantifying the Bullwhip Effect in a Simple Supply Chain: The Impact of Forecasting, Lead Times, and Information.: The Impact of Forecasting, Lead Times, and Information. , 2000 .

[5]  Narasimhaiah Gorla,et al.  INFORMATION QUALITY: MODELING ACCURACY-TIMELINESS IN TRANSACTION PROCESSING SYSTEMS , 2002 .

[6]  D. Harrison McKnight,et al.  Perceived Information Quality in Data Exchanges: Effects on Risk, Trust, and Intention to Use , 2006, Inf. Syst. Res..

[7]  Marcus Kaiser,et al.  DQ Metrics: A Novel Approach To Quantify Timeliness And Its Application In CRM , 2007, ICIQ.

[8]  Mario Piattini,et al.  MMPRO: A Methodology Based on ISO/IEC 15939 to Draw Up Data Quality Measurement Processes , 2008, ICIQ.

[9]  Martin J. Eppler,et al.  A Classification and Analysis of Data Quality Costs , 2004 .

[10]  Graeme G. Shanks,et al.  A semiotic information quality framework: development and comparative analysis , 2005, J. Inf. Technol..

[11]  Carlo Batini,et al.  Methodologies for data quality assessment and improvement , 2009, CSUR.

[12]  Richard Y. Wang,et al.  Anchoring data quality dimensions in ontological foundations , 1996, CACM.

[13]  Stuart E. Madnick,et al.  Integrating information from global systems: Dealing with the "on- and off-ramps"; of the information superhighway , 1995, J. Organ. Comput..

[14]  Shan Wang,et al.  An Exploratory Study of Electronic Marketplace Adoption: A Multiple Perspective View , 2006, Electron. Mark..

[15]  Carlo Batini,et al.  A Framework And A Methodology For Data Quality Assessment And Monitoring , 2007, ICIQ.

[16]  R. Yin Case Study Research: Design and Methods , 1984 .

[17]  Vineet Padmanabhan,et al.  Comments on "Information Distortion in a Supply Chain: The Bullwhip Effect" , 1997, Manag. Sci..

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

[19]  A. Weale Embedded Case Study Methods: Integrating Quantitative and Qualitative Knowledge , 2003 .

[20]  Yu Cai,et al.  Evaluating Completeness of an Information Product , 2003, AMCIS.

[21]  Huimin Zhao,et al.  Semantic matching across heterogeneous data sources , 2007, Commun. ACM.

[22]  Nick Kapnison,et al.  ANNUAL REPORT FOR 2010 , 2010 .

[23]  Wenfei Fan,et al.  Conditional functional dependencies for capturing data inconsistencies , 2008, TODS.

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

[25]  Boris Otto,et al.  Identification of Business Oriented Data Quality Metrics , 2009, ICIQ.

[26]  Diane M. Strong,et al.  Beyond Accuracy: What Data Quality Means to Data Consumers , 1996, J. Manag. Inf. Syst..

[27]  James D. McKeen,et al.  Developments in Practice XXX: Master Data Management: Salvation Or Snake Oil? , 2008, Commun. Assoc. Inf. Syst..

[28]  Geoff Walsham,et al.  Interpretive case studies in IS research: nature and method , 1995 .

[29]  Christine Legner,et al.  Toward the Inter-organizational Product Information Supply Chain - Evidence from the Retail and Consumer Goods Industries , 2008, J. Assoc. Inf. Syst..

[30]  Yu Cai,et al.  Supporting data quality management in decision-making , 2006, Decis. Support Syst..

[31]  Roland W. Scholz,et al.  Embedded Case Study Methods , 2002 .

[32]  Marshall L. Fisher,et al.  Supply Chain Inventory Management and the Value of Shared Information , 2000 .

[33]  W. Douglas Maughan,et al.  DNSSEC: a protocol toward securing the internet infrastructure , 2007, CACM.

[34]  Felix Naumann,et al.  Data fusion , 2009, CSUR.

[35]  Felix Naumann,et al.  Rule-Based Measurement Of Data Quality In Nominal Data , 2007, ICIQ.

[36]  Marcus Kaiser,et al.  A Procedure to Develop Metrics for Currency and its Application in CRM , 2009, JDIQ.

[37]  Carol V. Brown,et al.  Designing data governance , 2010, CACM.

[38]  Elie Ofek,et al.  Manufacturer Benefits from Information Integration with Retail Customers , 2004, Manag. Sci..

[39]  George Q. Huang,et al.  Web‐based simulation portal for investigating impacts of sharing production information on supply chain dynamics from the perspective of inventory allocation , 2002 .

[40]  Hans Lehmann,et al.  An Object-Oriented Architecture Model for International Information Systems? , 2003, J. Glob. Inf. Manag..

[41]  Richard L. Baskerville,et al.  Distinguishing action research from participative case studies , 1997 .

[42]  Duanning Zhou,et al.  Data Synchronization Technology: Standards, Business Values and Implications , 2006, Commun. Assoc. Inf. Syst..

[43]  Graeme G. Shanks,et al.  Developing a Measurement Instrument for Subjective Aspects of Information Quality , 2008, Commun. Assoc. Inf. Syst..

[44]  Stéphane Bressan,et al.  Context Interchange: New Features and Formalisms for the Intelligent Integration of Information Context Interchange: New Features and Formalisms for the Intelligent Integration of Information , 1997 .

[45]  Bas H. P. J. Vermeer,et al.  How important is data quality for evaluating the impact of EDI on global supply chains? , 2000, Proceedings of the 33rd Annual Hawaii International Conference on System Sciences.

[46]  David Loshin Master Data Management , 2008 .

[47]  Bernd Heinrich,et al.  A novel data quality metric for timeliness considering supplemental data , 2009, ECIS.

[48]  Boris Otto,et al.  One Size Does Not Fit All---A Contingency Approach to Data Governance , 2009, JDIQ.

[49]  P. Burger Embedded Case Study Methods: Integrating Quantitative and Qualitative Knowledge , 2001 .

[50]  Richard Y. Wang,et al.  Manage Your Information as a Product , 1998 .

[51]  Jan Schemm Stammdatenmanagement zwischen Handel und Konsumgüterindustrie - Referenzarchitektur für die überbetriebliche Datensynchronisation , 2008 .

[52]  Roman Beck,et al.  Some Economics of Vertical Standards: Integrating SMEs in EDI Supply Chains , 2005, Electron. Mark..

[53]  H. Yen,et al.  Determinants of supplier‐retailer collaboration: evidence from an international study , 2006 .

[54]  HEICO VAN DER BLONK Writing case studies in information systems research , 2003, J. Inf. Technol..