Design and analysis on data warehouse of personnel administration system using time series algorithm

Abstract

The purpose of this study was to design and analysis on data warehouse of personnel administration system using time series. The success of the company in performing its business activities is definitely supported by reliable system administration job. Abundant data within the company; employee information, attendance data, leave the data, the increase in the classroom, increase salaries and allowances requires good management in the order. To assist in the management of personnel data in the study, analysis and design on data warehouse is done in the administration section personnel to facilitate the collection of employee data, monthly and annual reports. The method used in the data warehouse design, data retrieval is done form related sources through extraction, transforming, and loading (ETL) process. After the data warehouse is formed, then conducted data analysis of the presence of the employee with a period of time, either the monthly attendance data analysis as well as using the annual time series algorithm. Process analysis is used to look at trend data is the presence of any employee that can be used to analyze the performance of each employee. This process then continues with the creation of reports on performance of employees which can be used for strategic decisions at the management level. The results obtained from this study showed that the application of data warehouse in staffing information systems conducted to obtain information that can support strategic decisions at the management level. Thus, the design and implementation of data warehouse in power system can help collect data, analyze data, create a report and present the data in a form of employment that can be used to aid strategic decisions at the management level.