Designing Data Warehouse in Purchasing Department Using Dimensional Modeling

Authors

  • Defina Iskandar*, Galih Rizka Darmawan, Nindya Puspitasari, Raafi’ud Darajaat, Murnawan

Abstract

This study aims to design a data warehouse used to present operational information related to purchase prices, price increases, purchase values ??for parts, currency, and vendor performance evaluation at PT. XYZ, especially in the purchasing department. The problem is the difficulty obtaining the desired data because of the large amount of operational data that must be processed and combined from several sources. When the purchasing department has to decide which vendor to use for purchasing raw materials, it must look at data from each vendor, which takes a long time. The process of designing a data warehouse is done using top-down. The top-down method is a method where a series of processes begins by analyzing the problems that exist in the company. The data warehouse architecture that will be used is a centralized data warehouse. This architecture contains a collection of several separate sources and is put together into one centralized place. The data collected will be distributed into their respective functions for further use by the divisions—certain according to need. With the design of this data warehouse, it is hoped that PT. XYZ, especially the purchasing department, can easily get operational information needs without looking at data from several sources.

Published

2020-12-04

Issue

Section

Articles