Development of Business Intelligence Solution for Personnel Administration

摘要

The purpose of this research is to develop a business intelligence (BI) solution for personnel planning, with a case study of Thai university. It is generalized such that educational institutes and personnel departments of armed forces can adopt to manage military staffs more effectively. This can support the managerial decision making, with analysis of personnel administration and guidelines for operation. Personal achievement evaluation process is necessary to understand each employees abilities, competencies, and relative merits, which are crucial for an organizational success. The proposed BI framework consists of creating a data warehouse upon existing information repository. It also includes the development of intelligent report capability that allows customization of views to analyze and meet the needs of the management and related users. This is implemented as a well-designed form of requirement-specific information, such that the executive is able to acquire the correct and updated data through the Internet to support analysis, planning, efficient following up of overall operation. It is developed as a web based application, where MySQL Server is exploited as database management system and a module of ETL (Extract, Transform and Load) to turn transactional data into a data warehouse. In addition, the Online Analytic Processing (OLAP) technique is used to present the summarized data as a multidimensional cube. The experiment concludes that the development of this BI system can help the executives to get hold of the data more quickly and timely as required. Moreover, based on the survey with a group of users who have experiences with the system, the level of satisfaction is high.