Open AccessImplementing of Data Warehouse Data Alumni using the Single Dimensional Data Store method
Author(s) -
Titis Asroni,
Bimbi Arimbi,
Slamet Riyadi
Publication year - 2020
Publication title -
journal of physics. conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/1471/1/012021
Subject(s) - computer science , data warehouse , baseline (sea) , database , data processing , data management , geology , oceanography
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.