PERANCANGAN DATA WAREHOUSE E-COMMERCE MENGGUNAKAN POSTGRESQL PADA PUBLIC DATASET OLIST
DOI:
https://doi.org/10.69714/8dwt6j74Keywords:
data warehouse, e-commerce, ETL , star schema, OLAPAbstract
This study designs a PostgreSQL-based data warehouse using the Olist public dataset to address fragmented and unstructured e-commerce transactional data. The research process includes ETL (Extract, Transform, Load), data cleaning and standardization, table consolidation, and the development of a star schema consisting of a sales fact table and multiple dimension tables. OLAP analysis reveals key patterns such as annual sales trends, top product categories, seller performance, preferred payment methods, and customer geographic distribution. The results demonstrate that the data warehouse improves analytical efficiency and provides strategic insights to support business intelligence in the e-commerce environment
References
M. S. Farhan, A. Youssef, and L. Abdelhamid, “A Model for Enhancing Unstructured Big Data Warehouse Execution Time,” Big Data Cogn. Comput., vol. 8, no. 2, 2024, doi: 10.3390/bdcc8020017.
A. Shahid, T. A. N. Nguyen, and M. T. Kechadi, “Big data warehouse for healthcare-sensitive data applications,” Sensors, vol. 21, no. 7, 2021, doi: 10.3390/s21072353.
L. Dinesh and K. G. Devi, “An efficient hybrid optimization of ETL process in data warehouse of cloud architecture,” J. Cloud Comput., vol. 13, no. 1, 2024, doi: 10.1186/s13677-023-00571-y.
S. Fugkeaw, P. Suksai, and L. Hak, “SSF-CDW: achieving scalable, secure, and fast OLAP query for encrypted cloud data warehouse,” J. Cloud Comput., vol. 13, no. 1, 2024, doi: 10.1186/s13677-024-00692-y.
A. Cakir, Ö. Akın, H. F. Deniz, and A. Yılmaz, “Enabling real time big data solutions for manufacturing at scale,” J. Big Data, vol. 9, no. 1, 2022, doi: 10.1186/s40537-022-00672-6.
S. Azzabi, Z. Alfughi, and A. Ouda, “Data Lakes: A Survey of Concepts and Architectures,” Computers, vol. 13, no. 7, 2024, doi: 10.3390/computers13070183.
T. Luhur, Rafika Rahmawati, Tri Puspa Rinjeni, Virdha Rahma Aulia, Prasasti Karunia Farista Ananto, and Iqbal Ramadhani Mukhlis, “Analyzing User Reviews with ETL using Pentaho Data Integration,” J. Komput. Teknol. Inf. Sist. Inf., vol. 4, no. 2, pp. 451–458, 2025, doi: 10.62712/juktisi.v4i2.403.
J. M. Hesekiel, I. Arwani, and D. E. Ratnawati, “Pengembangan Data Warehouse untuk Evaluasi Pembelajaran Matakuliah Berdasarkan Data Kuesioner Mahasiswa di SIAM dan Rekapitulasi Presensi Dosen ( Studi Kasus Teknologi Informasi Fakultas Ilmu Komputer ),” … Inf. dan Ilmu Komput. e-ISSN, vol. 4, no. 7, pp. 2172–2177, 2020, [Online]. Available: http://j-ptiik.ub.ac.id/index.php/j-ptiik/article/download/7564/3589
I. Thoib, B. P. Candra, F. B. Firmansyah, D. S. Nugraha, and N. Sururi, “Perancangan Data Warehouse Sebagai Penunjang Strategi Penerimaan Mahasiswa Baru,” J. Komput. Teknol. Inf. Sist. Inf., vol. 4, no. 1, pp. 98–108, 2025, doi: 10.62712/juktisi.v4i1.346.
I. G. N. A. T. Putra, I. N. A. Mahendra, and I. M. S. Putra, “Implementasi ETL Data Warehouse Dengan Konsep Fitur Metadata Dan Cleansing Data,” J. Sist. Inf., vol. 9, no. 2, pp. 274–289, 2020.
Y. Aisyah, S. Anwar, and - Samidi, “Pembuatan Data Warehouse secara Berjenjang dari Data Transaksi dengan ETL Script PHP,” Techno.Com, vol. 22, no. 3, pp. 609–621, 2023, doi: 10.33633/tc.v22i3.8084.
G. Bagus, A. Tama, N. Putu, M. Krisnayanti, P. Studi, and T. Informatika, “Penerapan Teknologi Datawarehouse Nosql Dan Business,” vol. 3, no. 2, pp. 120–127, 2020.
A. R. Nurridwan Firdaus and D. Firmansyah, “Implementasi Business Intelligence pada Data Pendapatan studi kasus (PT. Pos Indonesia),” J. Esensi Infokom J. Esensi Sist. Inf. dan Sist. Komput., vol. 7, no. 2, pp. 33–39, 2023, doi: 10.55886/infokom.v7i2.686
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Jurnal Riset Sistem Informasi
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
