Design of a Kimball-Based Data Warehouse for E-Learning Monitoring and Accreditation Reporting
Journal of Computer Electronic and Telecommunication · 20.07.2026 · 6 (1)
DOI: 10.52435/complete.v6i1.11040 ↗Kurz gefasst
Fachartikel in der Zeitschrift Journal of Computer Electronic and Telecommunication, online erschienen am 20.07.2026. Verfasst von Ubaidillah Umar und 1 weiteren Autor:innen.
Abstract (Originalsprache)
E-learning platforms record course delivery, learning materials, assessment activities, and student interactions, but many higher education institutions still prepare e-learning monitoring and accreditation reporting by querying operational databases manually. This practice may limit historical analysis, indicator consistency, and reporting reuse under flexible academic service conditions. This study proposes a domain-specific Kimball-based dimensional data warehouse model for accreditation-oriented e-learning reporting. The method analyzes reporting requirements, characterizes generic LMS data sources, prepares a staging and ETL workflow, defines slowly changing dimension policies, declares formal fact grains, constructs star schemas, and evaluates reporting scenarios. Three business processes are modeled: teaching delivery, assessment records, and activity logs. The result is a reporting-oriented schema consisting of three fact tables and eleven dimension tables, supported by representative pseudo-DDL, an example accreditation monitoring query, and a limited proof-of-concept evaluation using synthetic LMS-like records. The evaluation indicates that the reference schema represents selected structured indicators for active course monitoring, learning material availability, assessment evidence, and student participation. It also reports limited ETL and query feasibility metrics and provides dashboard prototype mapping with review criteria, while full accreditation evidence remains partially covered because qualitative documents require integration with document management metadata.
Zitieren
APA
Umar, U., & Insani, R. (2026). Design of a Kimball-Based Data Warehouse for E-Learning Monitoring and Accreditation Reporting. Journal of Computer Electronic and Telecommunication, 6(1). https://doi.org/10.52435/complete.v6i1.11040
Vancouver
Umar U, Insani R. Design of a Kimball-Based Data Warehouse for E-Learning Monitoring and Accreditation Reporting. Journal of Computer Electronic and Telecommunication. 2026;6(1). doi:10.52435/complete.v6i1.11040
BibTeX
@article{Umar2026,
author = {Umar, Ubaidillah and Insani, Rokhmatul},
title = {Design of a Kimball-Based Data Warehouse for E-Learning Monitoring and Accreditation Reporting},
journal = {Journal of Computer Electronic and Telecommunication},
year = {2026},
volume = {6},
number = {1},
doi = {10.52435/complete.v6i1.11040}
}
EUVIMED