Analisis dan Perancangan Data Warehouse untuk Penjualan, Identifikasi Status Distributor, dan Perpanjangan Masa Aktif Distributor pada PT Harmoni Dinamik Indonesia
Keywords:data warehouse, sales, extension period of active distributors, identification of distributor status, Nine-Step Methodology
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.
Connoly, T.M. and Begg, C.E. (2005). Database Systems: a practical approach to design, implementation, and management (fourth edition). Harlow: Addison-Wesley.
Inmon, W.H. (2002). Building the Data Warehouse (third edition). New York: John Wiley & Sons.
Kimball, Ralph and Ross, Margy (2002). The Data Warehouse Toolkit: the complete guide to dimensional modeling (second edition). New York: John Wiley & Sons.
Ponniah, Paulraj. (2001). Data Warehousing Fundamentals. New York: John Wiley & Sons.
Authors who publish with this journal agree to the following terms:
a. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License - Share Alike that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
b. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
c. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
All articles published Open Access will be immediately and permanently free for everyone to read and download. We are continuously working with our author communities to select the best choice of license options, currently being defined for this journal as follows: