ระบบธุรกิจอัจฉริยะสำหรับการวิเคราะห์ตัวชี้วัดคุณสมบัติของอาจารย์ตามเกณฑ์มาตรฐานหลักสูตรระดับบัณฑิตศึกษา

Abstract

According to the Higher Education Commission's Graduate Program Standard Criteria B.E. 2558 (2015), the procedures to determine teacher qualifications consist of several data from different sources to be analyzed. In fact, the different data sources can make process of analysis becomes difficult and more complex. Particularly, in the process of data preparation, if the process is performed manually, it will easily cause errors, difficult to verify accuracy, and the most importantly, it takes a very long time to operate the process. Therefore, this research study aims to design and develop ETL (Extract-Transform-Load) workflow in managing data from different sources and preparing data for analysis. The development of ETL workflow based on Quality Objectives Matrix (Qox) in order to evaluate the quality of data management and preparation for analysis in Business Intelligence (BI) system report. As a result, the evaluation of ETL workflow based on Qox revealed the accuracy at 99.99 percent, the completeness was equal to 1, the efficiency was an average of 17.15 seconds, and the scalability works well when testing with increasing the number of data to 5 times and 10 times respectively. Furthermore, the dashboard report for analyzing of teacher qualifications indicators based on criteria of the graduate studies program in Bl system responded to the needs of graduate studies program operation and management effectively. The results of technology acceptance showed the perceived usefulness is at 4.68. Information quality and perceived ease of use were 4.57 and 4.54 respectively. The technology acceptance evaluation indicates that the BI system helps to improve work performance and it is appropriated to be used for organizational work operation very well.