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

Taqiyuddin Ahmad Al Aufa (UPN Veteran Jawa Timur)
Adriano Femaz Rivaldy (UPN Veteran Jawa Timur)
Farel Ega Nurroyan (UPN Veteran Jawa Timur)
Muhammad Fawwaz Dhiaulhaq Hud (UPN Veteran Jawa Timur)
Amalia Anjani Arifiyanti (UPN Veteran Jawa Timur)

Jurnal Ilmu Teknologi Informasi Indonesia (JITIFNA)
Vol. 2 No. 2 (2026): JITIFNA - Juli

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.