Data Warehouse Rancang Bangun Monitoring PA Berbasis OLAP (Studi Kasus : Jurusan Teknologi Informasi)
AbstractThe Final Project (PA) is one of the requirements for graduation at the Polytechnic Caltex Riau. During the process, students are required to complete PA on time. The PA Guidance Process is organized in a system still in the form of description data. The data are in the form of PA progress percentage data and also description of activities during PA. Therefore, to facilitate PA Coordinators and Supervisors in monitoring the development of PA, a system is needed to be able to produce PA progress in the form of dashboards, using dashboard visualization that can facilitate users in monitoring PA processes. The dashboard is formed by the OLAP technology approach, which then PA data is modeled into a multidimensional form of data. Based on several tests that have been done, the results obtained are, in testing the quality of data transformation, there is duplication of data in the guidance data, this is influenced by the number of columns, and rows on the type of data (.xls) imported. Functional testing obtained an average value of 1 based on 3 types of factors, so that obtained features that have been implemented on the system and used correctly, the results that have been issued in accordance with the needs of the system. OLAP testing is in accordance with the needs based on the subject of analysis, in this test displays a graph using Higchart with drilldown and slice operations to be displayed as a dashboard visualization. The data transformation test found that PA progress descriptions can be calculated and displayed in the form of numbers.
Copyright info for authors
1. Authors hold the copyright in any process, procedure, or article described in the work and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
2. Authors retain publishing rights to re-use all or portion of the work in different work but can not granting third-party requests for reprinting and republishing the work.
3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) as it can lead to productive exchanges, as well as earlier and greater citation of published work.