PERANCANGAN DATA WAREHOUSE E-COMMERCE MENGGUNAKAN POSTGRESQL PADA PUBLIC DATASET OLIST

Arron Mosses Jhon Hadi
Ayu Elisya Natama Sianturi
Andri Wijaya

Jurnal Riset Sistem Informasi
Vol. 3 No. 1 (2026): Januari : Jurnal Riset Sistem Informasi

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