Perancangan Data Warehouse Sistem Informasi Eksekutif untuk Data Akademik Program Studi

  • Eko Prasetyo Universitas Muhammadiyah Yogyakarta
  • Lukito Edi Nugroho Universitas Gadjah Mada
  • Marcus Nurtiantara Aji Universitas Gadjah Mada
Keywords: Data warehouse, executive information system, data history, data mart, metrics architecture bus, star schema, extract transform load (ETL)

Abstract

This research examines the design of data warehouse that are the result of data integration and abstraction from various academic applications that accommodate the needs of history and archiving data to support executive information systems in the academic field. Identification of the executive reports use reference of the program accreditation forms, internal academic quality audit questionnaires, Dean’s annual reports, self-evaluation forms of Competitive Grant Program, features of the existing EIS, and features of executive data on the university academic administration website. The subject of this research is student data based on chronological stages starting from candidates selection process, new students, and students during lectures. The success of data warehouse design is determined by the right description of the business events, data completeness and validity, data mart design using metrics bus architecture, star schema design and ETL process to integrate, extract, cleanse, transform and load it into the data warehouse.

References

Pervan,P.P.; & Phua, R. 1996. Executive Information System in Australia: Current Status and Some Historical Comparisons. IEEE.

Inmon, W.H. 2005. Building the Data Warehouse, Fourth Edition. Indianapolis. Wiley Publishing, Inc.

Bouman,R.; & van Dongen, J. 2009. Pentaho® Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL®. Indianapolis. Wiley Publishing, Inc.

Kimball, R.; & Ross, M. 2004. The Data Warehouse Toolkit -Second Edition : The Complete Guide to Dimensional Modeling. Canada. John Wiley & Sons, Inc.

Kimball, R.; & Caserta, J. 2004. The Data Warehouse ETL Toolkit : Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data. Indianapolis. Wiley.

How to Cite
Eko Prasetyo, Lukito Edi Nugroho, & Marcus Nurtiantara Aji. (1). Perancangan Data Warehouse Sistem Informasi Eksekutif untuk Data Akademik Program Studi. Jurnal Nasional Teknik Elektro Dan Teknologi Informasi, 1(3), 13-20. Retrieved from https://dev.journal.ugm.ac.id/v3/JNTETI/article/view/3180
Section
Articles