Rancangan dan Pembuatan Data Warehouse untuk Kebutuhan Sistem Pendukung Keputusan (Studi Kasus: Departemen Marketing dan Komunikasi Universitas Dr Soetomo Surabaya)

Kacung, Slamet and Sumirat, Lambang Probo (2014) Rancangan dan Pembuatan Data Warehouse untuk Kebutuhan Sistem Pendukung Keputusan (Studi Kasus: Departemen Marketing dan Komunikasi Universitas Dr Soetomo Surabaya). Palimpsest, 5 (1). pp. 1-10. ISSN 2086-0994

Preview

Text slamet_kacung_palimpsest_PALIM7762-4d7ffeae4dfullabstract.pdf - Published Version Download (937kB) | Preview

Abstract

Information about the distribution of data and supporting students is needed by marketing and communications department (markom) Dr. Soetomo University (Unitomo) of Surabaya. On the other hand, the data distribution information markom students rely on the IT Department. To overcome these problems need to developed data warehouse applications in order to support environmentally markkom routine activities and faculty in promoting Unitomo to the wider community. The data warehouse is a data set that is subject-oriented, integrated, time variant, and nonvolatile which helps management in decision making process. The method of data warehouse started from collecting the data needed to build a data warehouse, the next process is the star schema created, extraction and data transformation (ETL). Data extraction is the process of selecting the data to be inserted into the data warehouse. Once the transformation is done, the data is inserted into the data warehouse. Existing data in the data warehouse with OLAP processed (Online Analytical Processing) to produce information. The purpose of a data warehouse is to provide early information to markom in conducting an analysis of the distribution of the data’s student performance is measured and in accordance with the scheme or plan that you want to work in the promotion for the next year.

Actions (login required)

View Item