PERANCANGAN DATA WAREHOUSE SISTEM INFORMASI EKSEKUTIF (STUDI KASUS DATA AKADEMIK PRODI TEKNIK ELEKTRO FT UGM)

A university as an academic organizations requires a complete, rapid and accurate information to support the process and planning activities, evaluating, and making the right decision. Data is collected and abstracted from various operational data scattered in a variety of academic applications. This study 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, AMAI UGM questionnaires, FT UGM Dean�s annual reports, self-evaluation forms of Competitive Grant Program, features of the existing SIE UGM, and features of executive data on the UGM 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. In this thesis, researcher examined the data warehouse using static and adhoc reporting that can accommodate the needs of executives. In addition, the researchers suggest the existence of an integrated policy for the uniformity of data formats in a variety of academic applications. the need for completeness and validity of data will be determined by the discipline of users in updating the data correctly and regularly