Analisis dan Perancangan Data Warehouse untuk Penjualan, Identifikasi Status Distributor, dan Perpanjangan Masa Aktif Distributor pada PT Harmoni Dinamik Indonesia

The purpose of this study is to analyze sales data from warehouse to distributors, identification of distributor status, and extension periods of active distributors. From the analysis, a data warehouse application is created with user interfaces that are easy to understand so as it can facilitate e...

Full description

Bibliographic Details
Main Author: Gredion Prajena
Format: Article
Language:English
Published: Bina Nusantara University 2013-06-01
Series:ComTech
Subjects:
Online Access:https://journal.binus.ac.id/index.php/comtech/article/view/2792
_version_ 1797706323451707392
author Gredion Prajena
author_facet Gredion Prajena
author_sort Gredion Prajena
collection DOAJ
description The purpose of this study is to analyze sales data from warehouse to distributors, identification of distributor status, and extension periods of active distributors. From the analysis, a data warehouse application is created with user interfaces that are easy to understand so as it can facilitate executive decision making. The analysis is done through the following steps: survey of the running system, analysis of the data obtained from the survey, identification of the information needed for data warehouse creation and identification requirements of the system to be built. Meanwhile, designing a data warehouse uses the Nine-Step Methodology of Ralph Kimball. The result is a data warehouse containing relevant and required information for executives to make decisions. The data warehouse application displays information to the user interface that is easy to understand and quick in making the report. The data needed by the company have been analyzed and produce useful information for executives. In addition, the reports can be generated quickly and the results of the analysis shown in the form of charts and pivot facilitate decision making more rapidly and precisely.
first_indexed 2024-03-12T05:50:30Z
format Article
id doaj.art-663dd995346643339508b16a7fc7210d
institution Directory Open Access Journal
issn 2087-1244
2476-907X
language English
last_indexed 2024-03-12T05:50:30Z
publishDate 2013-06-01
publisher Bina Nusantara University
record_format Article
series ComTech
spelling doaj.art-663dd995346643339508b16a7fc7210d2023-09-03T05:11:43ZengBina Nusantara UniversityComTech2087-12442476-907X2013-06-014147548310.21512/comtech.v4i1.27922183Analisis dan Perancangan Data Warehouse untuk Penjualan, Identifikasi Status Distributor, dan Perpanjangan Masa Aktif Distributor pada PT Harmoni Dinamik IndonesiaGredion Prajena0Bina Nusantara UniversityThe purpose of this study is to analyze sales data from warehouse to distributors, identification of distributor status, and extension periods of active distributors. From the analysis, a data warehouse application is created with user interfaces that are easy to understand so as it can facilitate executive decision making. The analysis is done through the following steps: survey of the running system, analysis of the data obtained from the survey, identification of the information needed for data warehouse creation and identification requirements of the system to be built. Meanwhile, designing a data warehouse uses the Nine-Step Methodology of Ralph Kimball. The result is a data warehouse containing relevant and required information for executives to make decisions. The data warehouse application displays information to the user interface that is easy to understand and quick in making the report. The data needed by the company have been analyzed and produce useful information for executives. In addition, the reports can be generated quickly and the results of the analysis shown in the form of charts and pivot facilitate decision making more rapidly and precisely.https://journal.binus.ac.id/index.php/comtech/article/view/2792data warehouse, sales, extension period of active distributors, identification of distributor status, Nine-Step Methodology
spellingShingle Gredion Prajena
Analisis dan Perancangan Data Warehouse untuk Penjualan, Identifikasi Status Distributor, dan Perpanjangan Masa Aktif Distributor pada PT Harmoni Dinamik Indonesia
ComTech
data warehouse, sales, extension period of active distributors, identification of distributor status, Nine-Step Methodology
title Analisis dan Perancangan Data Warehouse untuk Penjualan, Identifikasi Status Distributor, dan Perpanjangan Masa Aktif Distributor pada PT Harmoni Dinamik Indonesia
title_full Analisis dan Perancangan Data Warehouse untuk Penjualan, Identifikasi Status Distributor, dan Perpanjangan Masa Aktif Distributor pada PT Harmoni Dinamik Indonesia
title_fullStr Analisis dan Perancangan Data Warehouse untuk Penjualan, Identifikasi Status Distributor, dan Perpanjangan Masa Aktif Distributor pada PT Harmoni Dinamik Indonesia
title_full_unstemmed Analisis dan Perancangan Data Warehouse untuk Penjualan, Identifikasi Status Distributor, dan Perpanjangan Masa Aktif Distributor pada PT Harmoni Dinamik Indonesia
title_short Analisis dan Perancangan Data Warehouse untuk Penjualan, Identifikasi Status Distributor, dan Perpanjangan Masa Aktif Distributor pada PT Harmoni Dinamik Indonesia
title_sort analisis dan perancangan data warehouse untuk penjualan identifikasi status distributor dan perpanjangan masa aktif distributor pada pt harmoni dinamik indonesia
topic data warehouse, sales, extension period of active distributors, identification of distributor status, Nine-Step Methodology
url https://journal.binus.ac.id/index.php/comtech/article/view/2792
work_keys_str_mv AT gredionprajena analisisdanperancangandatawarehouseuntukpenjualanidentifikasistatusdistributordanperpanjanganmasaaktifdistributorpadaptharmonidinamikindonesia