Data Warehouse Analysis and Design based on Research and Service Standards

Data are not easy to organize, especially if the data are big in quantity and stored manually and in a non-computerized way. Therefore, in the last few years, many organizations or companies used information systems to help their activities organize and manage the data. Universitas Jenderal Soedirman (UNSOED) is a state college that has existed for a long time and has many Study Programs and Faculties, including the Faculty of Engineering. Data organization in UNSOED is mainly performed through computerization. However, retrieving data needs to be improved because UNSOED has various information systems, and the data produced keeps increasing over time. The data have yet to be evaluated following the needs of Tri Dharma, with indicators of achievement as expressed in the Regulation of Minister of Education and Culture (PERMENDIKBUD) on the National Standard of Higher Education (SNDIKTI). Data warehouse technology can be applied to storing, collecting, and processing media within a specific time from various data sources. The data processing results in the data warehouse are later displayed using the tools Knowage which may help the executives of the Faculty of Engineering make a decision and monitor the businesses, mainly about research and service, by the society of academicians in the Faculty of Engineering regularly from time to time.