Implementasi Data Warehouse dan Business Intelligence Menggunakan Pentaho dan Metabase untuk Membuat Dahboard Visualisasi Kinerja Penjualan E-Commerce Wish

Murtiwiyati Murtiwiyati; Hansel Agathon; Leli Safitri

doi:10.54066/jptis.v2i4.2783

Authors

Murtiwiyati Murtiwiyati Universitas Gunadarma
Hansel Agathon Universitas Gunadarma
Leli Safitri Universitas Gunadarma

DOI:

https://doi.org/10.54066/jptis.v2i4.2783

Keywords:

Business, Intelligence, Metabase, Pentaho

Abstract

As a business develops, the volume of data generated also increases. With the amount of data that continues to grow, it is necessary to process data that can support the improvement of the quality of business processes. Data processing on Wish can be done by implementing the Extract, Transform, Load process in the data warehouse using Pentaho and visualizing business intelligence with a dashboard using Metabase. The data used in this research is Wish transaction data for the period 2020-2023. The results of this study are a data warehouse using a PostgreSQL database and a dashboard to display Wish's sales performance. The results of the analysis of Wish's sales performance show that during 2020-2023 sales have increased, but most of these sales only come from one country, namely the United States. Therefore, Wish needs to make new innovations to attract customers from other countries.

References

Adityo, R. R. (2022). Pengembangan Aplikasi Qiscus Meet Menggunakan Jitsi Open Source Framework.

Coursera. (2023, November 30). What Is a Data Warehouse? Definition, Concepts, and Benefits.

Knight, M. (2023, June 23). What Is a Data Warehouse?

Kurniawan, J., Hartoto, Fahmi, A. Z., Ahyani, H., Hikmah, Ridwan, M., Amane, A. P. O., Afnarius, S.,

Priyanda, R., Arnita, Yudawisastra, H. G., Rosmawati, A., & Hozairi. (2023). Analisis dan Visualisasi Data.

Muhammad Ariffudin (2021). Apa itu PostgreSQL? Mengenal Database PostgreSQL.

Postgres. (n.d.). What is PostgreSQL?

Puri, D. (2021, July 21). Mengenal apa itu ETL (Extract, transform, dan load) dan Toolsnya .

Ramya, S., & Prasad, S. (2021). The Evolution and Impact of OLAP Technology in Data Analysis.

Saraswati, N. W. S., & Martarini, N. M. L. (2020). Extract Transform Loading Data Absensi Stmik Stikom Indonesia Menggunakan Pentaho. MATRIK : Jurnal Manajemen, Teknik Informatika Dan Rekayasa Komputer, 19(2), 273–281. https://doi.org/10.30812/matrik.v19i2.564

Talaoui, Y., & Kohtamäki, M. (2021). 35 years of research on business intelligence process: a synthesis of a fragmented literature.