Analisa Kategori Barang dengan Penjualan Terbanyak dalam Jangka Waktu 3 Bulan Menggunakan Data Warehouse
DOI:
https://doi.org/10.31961/eltikom.v6i1.457Keywords:
Data Warehouse, ETL, Multi Dimensional Data, Pentaho Data Integration, TableauAbstract
UD. Makmur Sejahtera as one of the largest distributors of daily necessities in Manokwari Papua has sales transaction data for each category of goods and types of goods. These data are still physically stored in the form of notes and have not been digitized so that they can be utilized optimally to help UD. Makmur Sejahtera increases sales. This research has the basic idea of using digital sales transaction data to find out which categories of goods have the most sales in a period of three months (July 2020 to September 2020) through the Extraction, Transformation, Loading (ETL) process based on Pentaho Data Integration, to then be stored in multi-dimensional data forms, categorized, and visualized using Tableau. The test results show that rice commodity is the category of goods with the most sales in a period of three months and the implementation of the Data Warehouse is very helpful for UD. Makmur Sejahtera in achieving its business goals.
Downloads
References
Downloads
Published
Issue
Section
License
Copyright (c) 2022 Jurnal ELTIKOM : Jurnal Teknik Elektro, Teknologi Informasi dan Komputer
This work is licensed under a Creative Commons Attribution-NoDerivatives 4.0 International License.
All accepted papers will be published under a Creative Commons Attribution 4.0 International (CC BY 4.0) License. Authors retain copyright and grant the journal right of first publication. CC-BY Licenced means lets others to Share (copy and redistribute the material in any medium or format) and Adapt (remix, transform, and build upon the material for any purpose, even commercially).
