Implementasi Data Warehouse Dan Penerapannya Pada PHI-Minimart Dengan Menggunakan Tools Pentaho dan Power BI

  • gede acintia udayana universitas udayana
  • I Made Yoga Mahendra Universitas Udayana
  • I Kadek Anom Sukawirasa Universitas Udayana
  • Gde Deva Dimastawan Saputra Universitas Udayana
  • 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.

Downloads

Download data is not yet available.
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: 05 nov. 2024. doi: https://doi.org/10.24843/JLK.2021.v10.i01.p19.

Most read articles by the same author(s)

1 2 > >>