Otomatisasi Pengolahan Data dan Perancangan Dashboard di PT. X

Abstract

The problem faced by XYZ Department in PT. X is related to data processing of XYZ Program. Time to execute six processes, such as lookup data and data adjustment are 160,41 minutes or about 2,5 hours. Rate of data validation that should use historical default are still low where the data in the 19th week which used as samples, there are more than 5000 data or about 5% of the anomalous data. The root cause of these two problems are the absence of automation program for data processing and no historical default for certain mechanisms. XYZ Department also requires a dashboard that can display the entire data, from national level to store. Automation program and dashboard are created to accomplish problems and needs of the company. Time needs to do the six processes with the automation program becomes 9.2 minutes. The effort from the operator who processes the data is also reduced because they just copy data on the template that has been provided, enter the week to be processed, and click the required button. Anomalous data on mechanisms that should use historical defaults have also been facilitated with Adjustment buttons where there is no anomalous data after this process is executed. Dashboard can also facilitate in analyzing data about the achievement or performance of the existing mechanisms and see whether there is an enhancement in the percentage of business grow in accordance with the company objectives.