QoX based ETL Design for Business Intelligence System of Lecturers’ Qualifications Analysis

QoX based ETL Design for Business Intelligence System of Lecturers’ Qualifications Analysis

연구 분야: Databases

학회: 2020 17th International Conference on Electrical Engineering/Electronics, Computer, Telecommunications and Information Technology (ECTI-CON)

Business Intelligence (BI) system for lecturer qualifications' analysis is based on Standard Criteria of the Graduate Studies Program (SCGSP) of the country. According to the SCGSP, the procedures to determine the lecturer's qualifications consists of several factors to be analyzed. The considered factors are involved with several data that is retrieved from various sources and has different data format types. To perform the analysis for BI systems, the integration of data is required through Extract, Transform, and Load, termed ETL workflow process to manage the relevant data. In fact, the ETL workflow process is very complicated, time consuming, and costly. Most ETL designers report that ETL workflow process accounts for 70% of the work in data warehouse development. Moreover, there is no systematic approach and supported tools to accomplish the quality requirement of ETL workflow design and most of them are based on experiences of developers and designers. This is actually affected the performance analysis of BI systems when implemented the poor ETL workflow. Therefore, this paper aims to design ETL workflow for BI of lecturers' qualifications analysis based on the standard criteria of SCGS. The study looks into identifying and found the Quality of Objectives (QoX) dimension aspects namely; completeness, efficiency, scalability, and accuracy as a quality metrics to measure the quality of ETL design of this research in the future work.