RANCANG BANGUN SISTEM ANALISIS NILAI SISWA SDN 13 PAGI DUREN SAWIT BERBASIS ETL DAN OLAP

Agus Wismo Widodo; Dian  Gustina; Muhammad Ichsan Fikri

Agus Wismo Widodo Universitas Persada Indonesia Y.A.I
Dian Gustina Universitas Persada Indonesia Y.A.I
Muhammad Ichsan Fikri Universitas Persada Indonesia Y.A.I

Abstrak

Rapid information technology growth prompts the integration of information systems for managing
student grades as a basis for learning evaluation. Currently, SDN 13 Pagi Duren Sawit manages these
grades manually, separating the odd and even semesters, which hinders teachers from performing
systematic analysis and comparisons. This study designs an analytical system using Extract, Transform,
Load (ETL) and Online Analytical Processing (OLAP) to integrate and structure student grade
management. Utilizing an applied research method with the Waterfall SDLC approach, the ETL process
ensures data consistency, while OLAP enables multidimensional analysis by student, subject, and
semester. The web-based system was verified through Black Box Testing and evaluated using the System
Usability Scale (SUS)