p-Index From 2021 - 2026
6.184
P-Index
Claim Missing Document
Check
Articles

Analysing User Reviews with ETL using Pentaho Data Integration Tri Luhur Indayanti Sugata; Rafika Rahmawati; Tri Puspa Rinjeni; Virdha Rahma Aulia; Prasasti Karunia Farista Ananto; Iqbal Ramadhani Mukhlis
Jurnal Komputer Teknologi Informasi Sistem Komputer (JUKTISI) Vol. 4 No. 2 (2025): September 2025
Publisher : LKP KARYA PRIMA KURSUS

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.62712/juktisi.v4i2.403

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.
PELATIHAN, PENDAMPINGAN MANAJEMEN, DAN DIGITALISASI DESA WISATA BRUMBUN KABUPATEN MADIUN MELALUI PENERAPAN APLIKASI E-COMMERCE Iqbal Ramadhani Mukhlis
Jurnal Pengabdian kepada Masyarakat Vol. 13 No. 1 (2026): JURNAL PENGABDIAN KEPADA MASYARAKAT 2026
Publisher : P3M Politeknik Negeri Malang

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33795/abdimas.v13i1.9108

Abstract

Traditional promotion (word of mouth) and booking management (via WhatsApp) are major challenges for MSMEs and Pokdarwis in Brumbun Tourism Village. This community service activity aims to bridge this digital problem by designing and implementing appropriate technological solutions. The method used was the participatory development of the WooCommerce-based e-commerce application "brumbun.deswita," designed to be simple and intuitive to meet partner needs. The development of this platform was accompanied by digital literacy training and intensive mentoring to improve human resource capacity. The program's success was measured using pre-test and post-test questionnaires to evaluate the training's effectiveness. The evaluation results showed a significant increase in participant understanding of 50.2%, with the highest increase in operational technical skills, specifically "Booking Confirmation and Management" (score increased from 0.65 to 1.00). The application received a positive response from participants and successfully transformed business processes from manual recording to a centralized digital dashboard. This activity successfully laid the foundation for digitalization, shifting partners' mindsets towards more professional business management in Brumbun Tourism Village.
Model View Controller Method For Animal Care (Petcare) Information System At Niz Petcare Lawang Iqbal Ramadhani Mukhlis; Deny Hermansyah; Tika Ayu Hariyanti
JEECS (Journal of Electrical Engineering and Computer Sciences) Vol. 8 No. 2 (2023): JEECS (Journal of Electrical Engineering and Computer Sciences)
Publisher : Fakultas Teknik Universitas Bhayangkara

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.54732/jeecs.v8i2.2

Abstract

Pet Care is a company that offers animal care services that are equipped with a variety of pet shop products such as food, vitamins and care. In addition to Daily Pet Care selling pet supplies and also offering animal medical and treatment services. on one computer. Pet sitting services are one of the best solutions for the majority of Indonesian people who have pets but have to travel far and cannot bring their pets with them. The owners of Niz Petcare see this as a great business opportunity. However, currently they still use manual recording in their business processes, sometimes resulting in loss of material and customer confidence. The purpose of this research is to solve this problem by designing a flow and design of a petcare application prototype that is integrated and more organized using information technology that is developing rapidly and makes it easier for customers to access online. Given these needs, the authors apply the prototyping method to accommodate these needs. The implementation of making software uses the model view controller (MVC) method which adopts the CodeIgniter framework. In this study, an evaluation was carried out using UAT and Usability Testing with ISO/IEC 9126. The evaluation results show that the application of the MVC method can produce good software products that work according to their functionality. Based on the ISO/IEC 9126 percentage, the criteria with the greatest value for understanding on P05, P07, and P09 is 89%, usability on P05 is 89%, and learning on P07 is 89% and 88% power handling at P10. From the results of the summary of the evaluation, it can be concluded that there are if the users of the system are owners, customers, administrators, fully aware of the ease of understanding, learning, use and attractiveness of the NIZ pet care information system created
Analyzing Customer Loyalty Levels through Segmentation in Aesthetic Clinics Using K-Means and RFAM Sinarring Azi Laga; Deny Hermansyah; Chitra Laksmi Rithmaya; Muhammad Zainuddin; Geo Ardana Ihsan Purnama Aji; Iqbal Ramadhani Mukhlis
IJID (International Journal on Informatics for Development) Vol. 13 No. 2 (2024): IJID December
Publisher : Faculty of Science and Technology, Universitas Islam Negeri (UIN) Sunan Kalijaga Yogyakarta

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.14421/ijid.2024.4841

Abstract

Effective customer segmentation is crucial in optimizing marketing strategies, particularly in customer-oriented aesthetic clinics. This research aims to enhance customer segmentation in aesthetic clinics using a K-Means approach based on the RFAM (Recency, Frequency, Average-Monetary) model. This approach is utilized to leverage historical customer data to identify customer segments based on their purchasing behavior, including visit frequency, average purchase amount, and the last time they visited the clinic. The K-Means clustering method maps customers into homogeneous groups, enabling aesthetic clinics to adapt more focused and personalized marketing strategies. The research results indicate insights obtained from the analysis and interpretation of RFAM conducted on 493 data points, resulting in the formation of two distinct clusters. In Cluster 1, denoting low loyalty, there are 156 customers, while Cluster 2 comprises 337 customers, reflecting high loyalty. Practical implications of this research include improvements in service customization and promotions tailored to customer needs and preferences. In conclusion, the K-Means approach based on the RFAM model can be utilized as an effective tool to enhance customer segmentation in the aesthetic clinic industry.
Perancangan Aplikasi Kegawatdaruratan Terintegrasi "Sigap 24/7" dengan Pendekatan User Centered Design Wahyu Pratama Andhika Maheswara; Muhammad Alvian Jaya; Anggoro Adit Haptono; Iqbal Ramadhani Mukhlis; Prasasti Karunia Farista Ananto
JSI (Jurnal Sistem Informasi) Universitas Suryadarma Vol. 12 No. 2 (2025): JSI (Jurnal sistem Informasi) Universitas Suryadarma
Publisher : Fakultas Ilmu Komputer dan Desain - Unsurya

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35968/jsi.v12i2.1576

Abstract

Tingginya tingkat kegawatdaruratan di Indonesia, dengan rata-rata 2.500 bencana alam dan 18.000 kasus kecelakaan lalu lintas per tahun (BNPB, 2023), menuntut sistem penanganan yang responsif. Penelitian ini mengembangkan "Sigap 24/7", aplikasi kegawatdaruratan berbasis Android yang diuji coba pada 150 pengguna dengan pendekatan User-Centered Design (UCD). Hasil pengujian menunjukkan peningkatan efisiensi respon darurat sebesar 65% dibanding sistem konvensional, dengan waktu rata-rata pelaporan berkurang dari 4,2 menit menjadi 1,5 menit. Aplikasi ini menawarkan dua mode pelaporan: (1) layanan SOS dengan akurasi GPS 98,7% dalam radius 50 meter, dan (2) layanan Non-SOS yang meningkatkan kelengkapan data insiden sebesar 80% melalui formulir terstruktur. Uji coba multi-instansi melibatkan 5 lembaga darurat menunjukkan peningkatan koordinasi sebesar 72% dalam simulasi penanganan bencana. Evaluasi SUS (System Usability Scale) menghasilkan skor 86,4/100, menunjukkan tingkat penerimaan pengguna yang sangat baik. Solusi ini berpotensi mengurangi waktu respon darurat hingga 40% sekaligus meningkatkan akurasi data insiden untuk penanganan yang lebih tepat.
Penerapan Metode Design Thinking dalam Perancangan UI/UX Aplikasi Pendakian Gunung Berbasis Mobile di Jawa Timur Rio Alghaniy Putra; Abdul Rezha Efrat Najaf; Iqbal Ramadhani Mukhlis
MDP Student Conference Vol 5 No 2 (2026): The 5th MDP Student Conference 2026
Publisher : Universitas Multi Data Palembang

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35957/mdp-sc.v5i2.15434

Abstract

The increasing interest of the people of East Java in mountain hiking activities has created a need for digital solutions that can integrate information, preparation, and hiking safety. This study aims to design the user interface and user experience of a mobile-based mountain hiking application called Mountzy using the Design Thinking method. The stages applied include empathize, define, ideate, prototype, and test, with a focus on the needs of hikers in East Java. The design results are realized in the form of information architecture, wireframes, and high-fidelity prototypes that include key features such as Pantau Langit, Hiking Planning, Sewa Aja (equipment rental), and Community Forum. Usability testing was conducted using Maze and the System Usability Scale (SUS). The results show a Maze score of 83 and an average SUS score of 83.20, which fall into the excellent and acceptable categories. These results indicate that the Mountzy application has good usability and is feasible for further development.
Co-Authors Abdul Rezha Efrat Najaf Afandi, Haekal Ridho Africa, Laely Aghe Aji, Geo Ardana Ihsan Purnama Alya Rizky Natasya Alya Rizky Natasya Anggoro Adit Haptono Aqil, Zharif Ra'is Arif Z Djunaedi Arif Zeinfiki Djunaedi Barmin, Aidah Maryam Chitra Laksmi Rithmaya Deny Hermansyah Dewi Murdiawati Diah Ekaningtias Diah Ekaningtyas Ellen Theresia Sihotang Farras Hafish Zidane Gaguk Suprianto Geo Ardana Ihsan Purnama Aji Gumelar, Mustofa Maulana Lingga Hariadi Yutanto Heri Suprianto Heri Supriyanto Iswanda F. Satibi Iswanda F. Satibi Jonathan Gerry Joy Christianto Kadek Pranetha Prananjaya, Kadek Pranetha Kartika Marta Budiana Khuzaini Khuzaini khuzaini, Khuzaini Maharani, Ganestiana Diah Marya Mujayana Meilisa Lantang, Vanessa Mellyza Silvy Moch. Anang Karyawan Mochammad Vaif Dwi Alifkhan Mohammad Syarrafah Muhammad Alvian Jaya Muhammad Rafi Arganta Muhammad Zainuddin Muhammad Zainuddin Mustofa Maulana Lingga Gumelar Nambi Sembilu Nasution, Zubaidah Natasya, Alya Rizky Naufal Nur Ahmad Nur Rochmah Prasasti Karunia Farista Ananto Rafika Rahmawati Rafika Rahmawati Rafika Rahmawati Rio Alghaniy Putra Riski Aprillia Nita Rithmaya, Chitra Laksmi Rizka Hadiwiyanti Robiah Al Adawiyah Rudi Santoso, Rudi Salsabilla, Kharisma Agustya Zahra Satibi, Iswanda Fauzan Sembilu, Nambi Sihotang, Ellen Theresia Sinarring Azi Laga Suhartono Suprianto, Gaguk Thomas Aquino Berno Doduk Tika Ayu Hariyanti Tri Luhur Indayanti Sugata Tri Puspa Rinjeni Virdha Rahma Aulia Wahyu Pratama Andhika Maheswara Wati, Seftin Fitri Ana Yani, Prawita Yudha Herlambang Cahya Pratama Yudi Sutarso Zharif Ra'is Aqil