Perancangan Purwampa data warehouse pada Warehouse Management System (WMS) di Surabaya Distribution Center

Kholil, Nurshiam (2006) Perancangan Purwampa data warehouse pada Warehouse Management System (WMS) di Surabaya Distribution Center. Masters thesis, Institut Teknologi Sepuluh Nopember.

Text 9103205409-Master_thesis.pdf Restricted to Repository staff only Download (27MB)

Abstract

Surabaya Distribution Center merupakan titik penting untuk distribusi produk buatan Procter & Gamble (P&G) di Indonesia, khususnya di Indonesia Timur. Operasional Surabaya Distribution Center dijalankan oleh APL Logistics (APLL) dengan Warehouse Management System (WMS) yang memiliki antarmuka dengan sistem ERP dari P&G, yaitu SAP R/3. Setelah beroperasi lebih dari 1,5 tahun, banyak dirasakan kebutuhan-kebutuhan analisis bisnis dan pembuatan laporan yang sumber datanya berasal dari database WMS. Kebutuhan analisis bisnis yang sering kali menuntut kecepatan waktu serta ketepatan data, serta pembuatan laporan yang dibutuhkan secara rutin, sering kali dihadapkan pada keterlambatan penyelesaian dan kadang kala kesalahan pengerjaan. Perancangan data warehouse didasarkan pada pendayagunaan infrastruktur dan teknologi yang ada. Perancangan yang dilanjutkan dengan pembuatan purwarupanya bertujuan mempercepat ketersediaan sumber data untuk analisis bisnis dan pembuatan laporan. Perancangan sistem dalam tesis ini melalui tahapan-tahapan: analisis kebutuhan keluaran sistem, perancangan sistem, pembuatan purwarupa, dan uji coba. Purwarupa pada penelitian ini terbukti mempercepat ketersediaan sumber data untuk kebutuhan pelaporan dan sumber data untuk analisis, berdasarkan uji coba dengan empat skenario kebutuhan bisnis yang pernah ada.
=================================================================================================================================
Surabaya Distribution Center is an important supply chain distribution point for Procter & Gamble products, especially in Eastern Indonesia. Surabaya Distribution Center is operated by APL Logistics (APLL) with its own developed Warehouse Management System (WMS), which has an interface process with P&G's ERP system, SAP R/3. After operating for more than a year and a half, many business analysis requirements and report generation needs have emerged, with data sources based on the WMS. Business analytical and decision-supporting data requirements must mostly be available in a short time and be accurate, while regular report requirements done manually using spreadsheets are often prone to delays and error-prone activities. Data warehouse design is based on the current infrastructure. The data warehouse and OLAP design, continued with the creation of a prototype, have proven to accommodate information needs for business analytics and report generation. The data warehouse design methodology consists of system requirement analysis, data warehouse design, prototype generation, and testing. Testing based on 4 actual business scenarios has proven that the system design can accelerate the availability of data sources for report generation and analytical requirements.

Item Type:	Thesis (Masters)
Additional Information:	RTMT 005.740 68 Kho p
Uncontrolled Keywords:	Data Warehouse, 01AP, Warehouse Management System, Logistik, Data Warehouse, OLAP, Warehouse Management System, Logistics
Subjects:	Q Science > QA Mathematics > QA76.9.D37 Data warehousing.
Divisions:	Interdisciplinary School of Management and Technology (SIMT) > 61101-Master of Technology Management (MMT)
Depositing User:	magang .
Date Deposited:	16 Sep 2026 07:18
Last Modified:	16 Sep 2026 07:18
URI:	http://repository.its.ac.id/id/eprint/144565

Actions (login required)

View Item