EUVIMEDEUVIMED entdecken
Crossref

Design of a Kimball-Based Data Warehouse for E-Learning Monitoring and Accreditation Reporting

Ubaidillah Umar, Rokhmatul Insani

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.

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →