Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Media of Computer Science
I Gde Eka Dharsika
Program Studi Informatika, Fakultas Teknologi dan Informatika, Institut Bisnis dan Teknologi Indonesia
Computer Science & IT Control & Systems Engineering Electrical & Electronics Engineering Languange, Linguistic, Communication & Media Library & Information Science

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

Found 1 Documents
Search

 1 
ETL Implementation with Pentaho for Sales Data Visualization: A Case Study of Lunabit Beauty Bar I Gde Eka Dharsika; Ni Kadek Ayu Sulistiawati; Ida Bagus Gede Sarasvananda
Media of Computer Science Vol. 2 No. 2 (2025): December 2025
Publisher : CV. Digital Innovation

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.69616/mcs.v2i2.239

Abstract

The rapid growth of information technology has encouraged businesses to optimize their data management through data warehousing and visualization. This study presents the implementation of the Extract, Transform, Load (ETL) process using Pentaho Data Integration (PDI) for the development of a sales data visualization dashboard at Lunabit Beauty Bar. The ETL process was carried out on sales transaction data originally stored in CSV format and later structured into a MySQL-based data warehouse. The stages of ETL include data extraction, transformation involving cleaning, integration, and validation to ensure consistency, and loading into the warehouse for further analysis. The visualization dashboard displays several analytical perspectives, including sales trends over time, sales performance by treatment, customer contributions, and treatment ranking from highest to lowest. To evaluate system performance and usability, a User Acceptance Test (UAT) was conducted involving 16 respondents, including the owner and staff. The results showed a satisfaction rate of 94%, indicating that the system met the company's needs in providing valid, clear, and easy-to-understand information. This research demonstrates that the integration of ETL processes with data visualization tools can support business decision-making, particularly in monitoring sales performance and designing promotional strategies.
Co-Authors Ida Bagus Gede Sarasvananda Ni Kadek Ayu Sulistiawati