Implementation of Data Cleansing Pattern Module for Data Quality Management Application using Open Source Tools

In today’s digital world, maintaining the quality of the data is emerging as the keystone of business to obtain high quality data to make sure that the organizations create accurate and wise decision-making. Data were taken from various applications and mostly still raw and to transform the data into valuable and valid information, we need the data quality management in an organization is required to maintain its quality. The insight of the data is an essential tool for decision-makers. Good quality data exists when the data has been processed with data quality management. Good quality data has several beneficial impacts on organizations, and the ever-increasing amount of data in the rapidly expanding technological world of today makes analyzing it much more exciting. Therefore, this research will discuss one of the methods in data quality management that are data cleansing. We propose the design and implementation of pattern modules in data cleansing processing using open source tools to make the process of data cleansing of food and drug distribution permits in Indonesian government agencies more flexible and also create uniformity of the pattern data to obtain more insight to explore.