Authors:

gede acintia udayana, I Made Yoga Mahendra, I Kadek Anom Sukawirasa, Gde Deva Dimastawan Saputra, Ida Bagus Made Mahendra

Abstract:

“A shop owner needs an information system to see sales conditions. However, PHI Minimart only provides sales information that is stored in a database so that it cannot provide or present information quickly. To solve this problem, a data warehouse was built at PHI Mart to get fast information. This research will carry out the implementation of data warehouse sales from data sources, the extraction, transformation, loading (ETL) process using Pentaho tools, making Starschema in the form of branch dimensions, product dimensions, employee dimensions, time dimensions connected to the sales fact table, dashboard using BI power. Then the results of the data warehouse are analyzed through the OLAP (On-line Analytical Processing) process, making a cube or schema workbench, and making a dashboard for visualization in presenting the expected information from PHI Minimart. The results in this study include sales data used in 2008 in the form of sales graphs or dashboards, goods sold, and total sales of each branch, which are obtained as the delivery of sales information at the store.”

Keywords

Keyword Not Available

Downloads:

Download data is not yet available.

References

References Not Available

PDF:

https://jurnal.harianregional.com/jlk/full-73555

Published

2021-08-31

How To Cite

UDAYANA, gede acintia et al. Implementasi Data Warehouse Dan Penerapannya Pada PHI-Minimart Dengan Menggunakan Tools Pentaho dan Power BI.JELIKU (Jurnal Elektronik Ilmu Komputer Udayana), [S.l.], v. 10, n. 1, p. 163-174, aug. 2021. ISSN 2654-5101. Available at: https://ojs.unud.ac.id/index.php/JLK/article/view/73555. Date accessed: 02 Jun. 2025. doi:https://doi.org/10.24843/JLK.2021.v10.i01.p19.

Citation Format

ABNT, APA, BibTeX, CBE, EndNote - EndNote format (Macintosh & Windows), MLA, ProCite - RIS format (Macintosh & Windows), RefWorks, Reference Manager - RIS format (Windows only), Turabian

Issue

Vol 10 No 1 (2021): JELIKU Volume 10 No 1, Agustus 2021

Section

Articles

Creative Commons License This work is licensed under a Creative Commons Attribution 4.0 International License