Implementing of Data Warehouse Data Alumni using the Single Dimensional Data Store method

Abstract

Abstract Data is Information that has not been processed or manipulated, which is not enough for some users. So that the info is useful, the data needs to be prepared and integrated first to become Information. Universitas Muhammadiyah Yogyakarta has a tool to monitor data on Alumni, namely Tracer Study. The data currently available is still not integrated and processed correctly. Now there is a solution for processing data and data by making base data. The purpose of creating this database is to facilitate users in checking data, data that will be stored neatly and integrated into the computer. The method in this study uses the Single DDS method. Methodology This research starts from determining the subject of investigation, primary needs, creating baseline data, analyzing results. The backstage of need is carried out with two data analyzes, and interviews with LPKA (Lembaga Pengelola Kemahasiswaan dan Alumni) or Students and Alumni Management Institutions. Baseline data making in this study is single DDS, which has two data stores, namely Stage and DDS. Data analysis is done by creating reports with Microsoft Office Excel according to user needs. The testing phase is carried out with two processes, namely: ETL Testing and Functional Testing.