Monitoring system of student performance using data warehouse (Case study: INSTITUT TEKNOLOGI SUMATERA)

Ahmad Luky Ramdani, Raidah Hanifah, Okta Pilopa


Improving the quality of learning is one of the things that must be achieved in the college academic process. To achieve this, monitoring and evaluation of the results of the learning process is needed, namely by looking at student performance. Based on this, the research aims to develop a university data warehouse with student performance objects that will be used by the board application for the monitoring process. The application was successfully developed with several main features, namely: a) displaying the number of students based on year, region and the entrance to college, b) displaying a comparison of the number of students in each academic year based on student status , d) display student performance every academic year and e) KPI values based on needs analysis. These features have been tested using the blackbox approach and the test results show that the features work properly and produce outputs in corresponding to the test scenario.


Student performance, Data Warehouse, Dashboard, Open Source Software

Full Text:



Asmawi, M. R. (2010). Strategi meningkatkan lulusan bermutu di perguruan tinggi. Hubs-Asia, 9(2).

Hariyanti, E. (2008). Metodologi Pembangunan Dashboard sebagai Alat Monitoring Kinerja Organisasi Studi Kasus Institut Teknologi Bandung. Institut Teknologi Bandung.

Suryani, K. N., & Laksmiwati, H. (2012). Evaluasi Teknik Optimalisasi Proses ETL dan Skema Data Warehouse untuk Mendukung Tactical Business Intelligence. Jurnal Sarjana ITB bidang Teknik Elektro dan Informatika, 1(2).

Warnars, S. (2010). Tata kelola database perguruan tinggi yang optimal dengan data warehouse. arXiv preprint arXiv:1006.1663.

Ranjan, J., & Khalil, S. (2008). Conceptual framework of data mining process in management education in India: An institutional perspective. Information Technology Journal, 7(1), 16-23.

Azimah, A., & Sucahyo, Y. G. (2007). Implementasi Data Warehouse Untuk Menunjang Kegiatan Akademik. In Seminar Nasional Sistem dan Informatika (Vol. 12, pp. 1-12).

Turban, E., Sharda, R., & Delen, D. (2014). Decision support and business intelligence systems (Vol. 9). Pearson.


Article Metrics

Abstract view : 394 times
PDF - 330 times


  • There are currently no refbacks.

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.

Conference SENATIK P-ISSN :2337-3881 and  E-ISSN : 2528-1666

Jumlah penggunjung = Web Analytics orang

Statistik Senatik

Flag Counter