University of Twente Student Theses

Login

Productattribute approach to total data quality management : assuring high data quality in the productattributes of the Oracle database at Honeywell Emmen

Boelens, Roy (2006) Productattribute approach to total data quality management : assuring high data quality in the productattributes of the Oracle database at Honeywell Emmen.

[img] PDF
2MB
Abstract:Data is an important aspect in keeping companies competitive. Within Honeywell Emmen there are however numerous customer complaints, and internal reports of problems with the quality of data in the database. For example, shipments were delayed because of missing data, transfer prices were outdated and bills of materials were not accurate. These problems have lead to the start of this project. The planned implementation of SAP has also contributed to the importance of the productattribute quality. Interviews with stakeholders from the different departments involved with productattribute data quality resulted in the identification of three main causes of the problems: · No structured way to analyze and improve productattribute data quality, · No structured way to analyze and improve the division of responsibilities in the productattributes manufacturing process, and · Lack of a structured way to communicate problems about quality of productattributes To eliminate these causes a literature research has been conducted and based on these findings a method has been designed. This method was adapted to handle the productattributes Honeywell Emmen uses, and the redesigned method was tested on two of these productattributes (Country of Origin, Product Family Code). Based on this data quality theory and the tests of the designed method the following recommendations are formulated: · Form a data quality improvement team, with: · A team leader, who is responsible (process owner) of the productattributes and has the power to implement solutions · A team engineer who can facilitate the team meetings · A data manufacturer who has extensive knowledge about the database system · A financial team member, who understands financial consequences of proposed solutions · Productattribute data suppliers, selected on the chosen productattribute to handle · Productattribute data users, selected on the chosen productattribute to handle · Introduce the designed method as a tool the data quality improvement team can use. · Institutionalize the data quality team and assign data quality responsibilities to the team leader. · Facilitate the data quality improvement efforts and make hours available for the team members. The recommendations are based on the Total Data Quality Management methodology designed by Wang [22]. The goal of this method is to improve the quality of data. The method is based on the Total Quality Management principals of, customer satisfaction, continues improvement, teamwork and participation. Using the method should provide a structured way to analyze and improve the quality of the productattributes. The description of the data manufacturing process provides a way to analyze and improve the division of responsibilities in each productattribute data manufacturing process. Working in a team with all involved departments can shorten communication chains and therefore increase the quality of communication. Implementing the data quality improvement team costs the chosen team members time and therefore money. Cycles of the method can however be planned in periods of less workload. The two group meetings of the team both take an average of two hours. The time required to implement the solution depends on the agreed actions that have to be taken. After the actions are implemented and the involved employees follow the described data manufacturing process the quality of the productattribute will be, and remain at, the level the users of the productattributes require. The quality of the database will therefore increase when more productattributes are handled with the method.
Item Type:Essay (Bachelor)
Clients:
Honeywell Emmen
Faculty:BMS: Behavioural, Management and Social Sciences
Subject:85 business administration, organizational science
Programme:Industrial Engineering and Management BSc (56994)
Link to this item:https://purl.utwente.nl/essays/57694
Export this item as:BibTeX
EndNote
HTML Citation
Reference Manager

 

Repository Staff Only: item control page