Implementasi Arsitektur Data Warehouse Dan Dashboard Business Intelligence Untuk Analisis Performa Penjualan Ritel Elektronik Di Myanmar Menggunakan Pentaho Dan Tableau

Abstract

This study aims to implement a Data Warehouse architecture and a Business Intelligence dashboard to analyze the electronic retail sales performance in Myanmar. Raw data sourced from the Electronic Retail Dataset (2020–2023) has high complexity and poor quality (dirty data). The methods used include building a data pipeline with PostgreSQL as a staging area, the Extract, Transform, Load (ETL) process using Pentaho Data Integration, Star Schema modeling, and interactive visualization using Tableau via a Virtual Datamart. The results show that the ETL process successfully cleaned data anomalies and produced an integrated schema. The resulting dashboard reveals strategic insights, such as the revenue dominance of "Laptop" products versus the high sales volume of "Desks", and the market's reliance on physical B2B channels. Furthermore, spatial disparities were identified, with Yangon and Bago serving as revenue centers, while other regions require strategic intervention. This implementation proves that the integration of Pentaho and Tableau can transform complex transactional data into visual information that effectively supports data-driven business decision-making.