Jurnal Komputer Teknologi Informasi Sistem Komputer (JUKTISI)
Vol. 4 No. 2 (2025): September 2025

Analysing User Reviews with ETL using Pentaho Data Integration

Sugata, Tri Luhur Indayanti (Unknown)
Rafika Rahmawati (Unknown)
Tri Puspa Rinjeni (Unknown)
Virdha Rahma Aulia (Unknown)
Prasasti Karunia Farista Ananto (Unknown)
Iqbal Ramadhani Mukhlis (Unknown)



Article Info

Publish Date
07 Jul 2025

Abstract

User reviews are a crucial element in guiding the continuous improvement of mobile applications for developers. This research aims to utilize Extract, Transform, Load (ETL) techniques using Pentaho Data Integration to analyze user reviews of government mobile applications which is ‘Sentuh Tanahku’, focusing on improving service quality through actionable data insights. The ETL process involves collecting and cleaning data from the Google Play Store to derive valuable insights that inform recommendations for app improvement. After data extraction, text preprocessing steps, such as cleansing, case folding, and keyword filtering, were applied to prepare the data for analysis. By categorizing user reviews into key aspects such as user interface, performance, bug fixes, security, compatibility and feature development this research enables the identification of most frequently discussed and complained about by users. The output of this research includes a structured dataset in Excel format. By demonstrating the effectiveness of ETL and text analysis in transforming unstructured user reviews into strategic insights, this research contributes to utilizing Pentaho Data Integration as an alternative and effective tool for processing and analyzing user reviews.

Copyrights © 2025






Journal Info

Abbrev

juktisi

Publisher

Subject

Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Education Engineering

Description

Focus dan scope dari JUKTISI (Jurnal Komputer Teknologi Informasi Sistem Komputer) terbit pertama kali pada tahun 2022 yang dimaksudkan sebagai media kajian ilmiah dari hasil pemikirian yang dituangkan kedalam Jurnal. Jurnal JUKTISI Lembaga Kursus dan Pelatihan Karya Prima terbit 3 (tiga) kali ...