Data Cleaning Metode Participatory Action Research untuk Karyawan PT. Matahari Department Store

Abstract

Accurate and efficient data management is a critical requirement in the digital age, especially in the retail sector that relies on data analytics to support decision-making. However, many employees face obstacles in understanding and applying data cleaning techniques that hinder the optimization of their analytical performance. This community service activity aims to improve the ability of PT Matahari Department Store employees to perform data cleaning using Microsoft Excel. The Participatory Action Research (PAR) approach is applied so that participants can actively participate in every stage of the abdimas carried out. The results of the activity showed a significant increase in participants' understanding and skills with the average post-test score increasing by 20% compared to the pre-test. The greatest improvement was achieved in the use of the Power Query feature, with a 40% increase in understanding. Program evaluation through questionnaires and interviews showed that the relevant training structure and interactive tools played a major role in the success of this activity. The conclusion of this activity is that hands-on training designed with a PAR approach is effective in overcoming employees' technical obstacles and improving their analytical performance. Recommendations are given to continue similar programs with a focus on data automation and advanced analytics to support work efficiency in the retail sector.