Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Jurnal Ilmu Teknologi Informasi Indonesia (JITIFNA)
Farel Ega Nurroyan
UPN Veteran Jawa Timur
Chemical Engineering, Chemistry & Bioengineering Civil Engineering, Building, Construction & Architecture Computer Science & IT Engineering Industrial & Manufacturing Engineering

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Implementasi Arsitektur Data Warehouse Dan Dashboard Business Intelligence Untuk Analisis Performa Penjualan Ritel Elektronik Di Myanmar Menggunakan Pentaho Dan Tableau Taqiyuddin Ahmad Al Aufa; Adriano Femaz Rivaldy; Farel Ega Nurroyan; Muhammad Fawwaz Dhiaulhaq Hud; Amalia Anjani Arifiyanti
Jurnal Ilmu Teknologi Informasi Indonesia Vol. 2 No. 2 (2026): JITIFNA - Juli
Publisher : CV. SINAR HOWUHOWU

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.70134/jitifna.v2i2.1717

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.
Co-Authors Adriano Femaz Rivaldy Amalia Anjani Arifiyanti Muhammad Fawwaz Dhiaulhaq Hud Taqiyuddin Ahmad Al Aufa