Article Per Year (5 Year)
p-Index From 2021 - 2026
9.303
P-Index
This Author published in this journals
All Journal snimed Seminar Nasional Aplikasi Teknologi Informasi (SNATI) Semantik JSI: Jurnal Sistem Informasi (E-Journal) Jurnal Kreativitas PKM JuSiTik : Jurnal Sistem dan Teknologi Informasi Komunikasi Zonasi: Jurnal Sistem Informasi Jurnal Informatika dan Rekayasa Perangkat Lunak Prosiding Seminar Nasional Multidisiplin Ilmu Jurnal Sistem Informasi dan Sains Teknologi MEANS (Media Informasi Analisa dan Sistem) Jurnal Pengkajian Dhamma Algor PROFICIO: Jurnal Pengabdian Masyarakat CITIZEN: Jurnal Ilmiah Mulitidisiplin Indonesia JURNAL PENDIDIKAN INDONESIA: Teori, Penelitian, dan Inovasi INTECH (Informatika dan Teknologi) Abdi-Dharma Jurnal Abdimas Musi Charitas Jurnal Sistem Informasi JSITP JSITIK: Jurnal Sistem Informasi dan Teknologi Informasi Komputer Jurnal Ilmiah Sistem Informasi MDP Student Conference Journal Of Informatics And Busisnes Jurnal Ilmiah Computer Science Masterpiece: Journal of Islamic Studies and Social Sciences Journal of Technology and System Information Jurnal Riset Teknik Komputer Jurnal Sains Sistem Informasi Inovasi Gagasan Abdimas & Kuliah Kerja Nyata Jurnal Dunia Peternakan Jurnal Riset Sistem Informasi Jurnal Sistem Informasi, Manajemen dan Teknologi Informasi Jurnal Sains dan Teknologi Jurnal Ilmu Komputer dan Informatika Seminar Nasional Riset dan Teknologi (SEMNAS RISTEK) Jurnal Riset Multidisiplin Edukasi INTECH (Informatika dan Teknologi) Sinergi : Jurnal Ilmiah Multidisiplin Ar-Rasyid: Jurnal Publikasi Penelitian Ilmiah
Andri Wijaya
Sistem Informasi, Sekolah Tinggi Teknik Musi, Palembang 30133
Religion Aerospace Engineering Agriculture, Biological Sciences & Forestry Humanities Biochemistry, Genetics & Molecular Biology Chemistry Civil Engineering, Building, Construction & Architecture Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Economics, Econometrics & Finance Education Electrical & Electronics Engineering Engineering Environmental Science Health Professions Immunology & microbiology Industrial & Manufacturing Engineering Languange, Linguistic, Communication & Media Library & Information Science Materials Science & Nanotechnology Mathematics Medicine & Pharmacology Nursing Physics Public Health Social Sciences Transportation Veterinary Other

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

Found 16 Documents
Search
Journal : Journal Of Informatics And Busisnes

 1   2 
Prototype Data Warehouse Kantor Penilai Publik XYZ Dengan Metode Nine-Step Kimball Ratu, Anggitta; Kusneti, Leni; Wijaya, Andri
Journal Of Informatics And Busisnes Vol. 1 No. 2 (2023): Juli - September
Publisher : CV. ITTC INDONESIA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.47233/jibs.v1i3.372

Abstract

In the era of information technology, data management has become crucial for organizations. The Public Appraisal Office (KJPP) XYZ in Palembang City, despite providing accurate property analysis, is still limited to the use of hard disks, hard copies, email, and Excel. This results in a lack of integration and efficiency in their operations. Therefore, this research proposes a solution in the form of designing a data warehouse prototype using the Nine-Step Kimball method. This method is employed as a systematic approach in designing and building a data warehouse, with the aim of ensuring effective and relevant development for business needs. The design will organize data into table components, creating regularity and centralization of data to facilitate search and analysis. The inspiration for this research comes from similar implementations in online market transactions and television editorial decisions using the snowflake schema and the successful Nine-Step Kimball method. It is hoped that through this approach, KJPP XYZ can optimize access, analysis, and use of the data.
Analisis Dan Perancangan Data Warehouse Untuk Pengelolaan Stok Barang Pada Cv Aneka Artha Niaga Septi Putri Azzahra; Yohanes Agung Apriyanto; Andri Wijaya
Journal Of Informatics And Busisnes Vol. 1 No. 2 (2023): Juli - September
Publisher : CV. ITTC INDONESIA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.47233/jibs.v1i2.375

Abstract

CV Aneka Artha Niaga is a developing company which operates in the field of kassemergud vesmuving distributor. Distributor means an actor who distributes finished products from factory production in the form of packaged snacks and drinks to shops that have registered as customers. As a business that operates in the distribution sector, stock management is an important factor in the success of selling the products they offer. From availability to distribution to customers. The large amount of data that is managed makes it difficult for CV Aneka Artha Niaga to process data analysis and make decisions. This research aims to overcome existing problems at CV Aneka Artha Niaga by implementing a data warehouse with the ITL (Extract, Transform, Load) process. The method used is Kimball's nine steps. Data was collected through field observations, interviews, and the company's ERP system. The result of this research is the implementation of a data warehouse which can be the answer to the problems and information that CV Aneka Artha Niaga needs.
Analisis Sentimen Review Pemain Teamfight Tactics dari Playstore untuk Meningkatkan Kualitas Game Deo anggoro; Andreas Alessandro Fernando Putra; Andri Wijaya
Journal Of Informatics And Busisnes Vol. 1 No. 3 (2023): Oktober - Desember
Publisher : CV. ITTC INDONESIA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.47233/jibs.v1i3.454

Abstract

Game online kini telah menjadi salah satu bentuk hiburan paling diminati di seluruh dunia. Teamfight Tactics (TFT) mencuat sebagai salah satu game online yang sedang populer saat ini. Tujuan dari penelitian ini adalah untuk mengevaluasi sentimen ulasan pemain TFT di Playstore dengan maksud meningkatkan mutu permainan. Metode klasifikasi Random Forest diterapkan dalam penelitian ini untuk mengategorikan ulasan sebagai negatif, netral, atau positif. Hasil analisis menunjukkan bahwa metode Random Forest mampu memberikan hasil yang akurat dalam menilai sentimen ulasan pemain TFT. Dengan demikian, penelitian ini diharapkan dapat memberikan pemahaman yang lebih mendalam mengenai sentimen pemain serta wawasan berharga bagi pengembang untuk meningkatkan kualitas game TFT..
Perancangan Data Warehouse Umat Lingkungan Gereja XYZ Menggunakan Metode Star Schema Andreas Alessandro; Deo Anggoro; Andri Wijaya
Journal Of Informatics And Busisnes Vol. 1 No. 3 (2023): Oktober - Desember
Publisher : CV. ITTC INDONESIA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.47233/jibs.v1i3.462

Abstract

The implementation of data warehouse technology at the Catholic Church XYZ, covering multiple regions, has become a common necessity. The use of a data warehouse aims to manage parishioner data more efficiently through a structured data warehouse system. The organized data integration process is the main focus, enabling church administrators to process data quickly and accurately in accessing the required information. By emphasizing the modeling process, the use of the Star Schema as a dimensional model provides ease in understanding data structures, serving as a key source of information for decision-making, especially regarding territorial allocations. This data warehouse design serves as a comprehensive solution for managing integrated parishioner data, supporting various information needs and decision-making processes. In addition to streamlining processes, the implementation of the data warehouse enhances the church's capabilities in addressing the increasingly complex dynamics of the environment.
Perancangan Rencana Strategis Sistem Informasi Pada PT XYZ Leni Kusneti; Bima Aprianto S; Stenilaus A; Andri Wijaya
Journal Of Informatics And Busisnes Vol. 2 No. 3 (2024): Oktober - Desember
Publisher : CV. ITTC INDONESIA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.47233/jibs.v2i3.2007

Abstract

This study develops a strategic plan for Information Systems/Information Technology (IS/IT) at PT XYZ, a distribution company in the plastic packaging sector. The primary objective of the research is to enhance operational efficiency and expand market reach through the optimal utilization of information technology. The methodology employed includes SWOT analysis, PESTLE, and the McFarlan Grid to evaluate the company's internal and external conditions and define the IS/IT implementation strategy. The findings highlight the need for additional features in the Enterprise Business System (EBS) to record retail transactions, the implementation of an e-commerce platform to broaden market access, and the adoption of automation technology in logistics processes to boost productivity. Moreover, the study recommends developing a Customer Relationship Management (CRM) system to strengthen relationships with business partners. A systematically designed five-year implementation roadmap ensures that this strategy supports the company's digital transformation and enhances its performance in the global market.
Analisis Ulasan Produk Amazon Menggunakan Random Forest Sentimen dan Probabilistic Retrieval Model Septi Putri Azzahra; Afifah Azzahra; Yohanes Agung Apriyanto; Andri Wijaya
Journal Of Informatics And Busisnes Vol. 2 No. 4 (2025): Januari - Maret
Publisher : CV. ITTC INDONESIA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.47233/jibs.v2i4.2070

Abstract

In the digital era, product reviews on e-commerce platforms such as Amazon have become an important source of information for consumers and sellers. This study develops a system for sentiment analysis of reviews using the Random Forest algorithm and relevant information retrieval with a TF-IDF-based probabilistic model. The data used includes 568,454 product reviews from Amazon, which are processed through data cleaning, tokenization, lemmatization, and feature extraction stages. Sentiments are classified into positive, negative, and neutral. The Random Forest model shows reliable performance with precision, recall, and F1-score of 0.878. The probabilistic search system successfully sorts relevant reviews with a high level of accuracy, which is evaluated using the Mean Average Precision (MAP) metric of 0.878. The results of this study provide significant contributions to improving the e-commerce user experience and supporting data-driven decision making. The approach used opens up opportunities for further research in the fields of natural language processing and machine learning.
Implementasi dan Evaluasi Sistem Pencarian Informasi Ulasan Restoran India Menggunakan Algoritma VSM Ratu, Anggitta; Leni Kusneti; Thomas Filikano; Andronikus G; Andri Wijaya
Journal Of Informatics And Busisnes Vol. 2 No. 4 (2025): Januari - Maret
Publisher : CV. ITTC INDONESIA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.47233/jibs.v2i4.2128

Abstract

Online review platforms, such as restaurant search websites and apps, have become a primary source of information for consumers when choosing restaurants. The large number of reviews available provides insights into service quality, food taste, and previous customer experiences. However, the main challenge is managing and extracting relevant information from the diverse and unstructured reviews, which can make it difficult for users to find accurate and relevant information. This study implements an information retrieval system for Indian restaurant reviews using the Vector Space Model (VSM) algorithm to address this challenge. The dataset from Kaggle, containing 10,000 Indian restaurant reviews, was processed through tokenization, stopword removal, stemming, and text normalization. The TF-IDF method was applied for term weighting, and relevance between the user's query and reviews was calculated using VSM. The evaluation results showed a precision of 70.92%, recall of 84.81%, and F1-score of 77.25%, indicating that the system can provide relevant reviews accurately and efficiently. This system could serve as a reference for developing information retrieval systems in the culinary field and other sectors that require effective customer review analysis.
Perancangan Data Warehouse Menggunakan Model Star Schema untuk Analisis Penjualan Retail Berbasis PostgreSQL Wijaya, Andri; Novaldi, Alexander
Journal Of Informatics And Busisnes Vol. 3 No. 3 (2025): Oktober - Desember
Publisher : CV. ITTC INDONESIA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.47233/jibs.v3i3.3759

Abstract

The retail industry faces significant challenges in managing massive transaction data volumes. Reliance on operational systems (OLTP) often hinders complex historical data analysis. This study aims to design and implement a Data Warehouse using the Star Schema approach to support efficient retail sales analysis. Utilizing the Sample Superstore dataset, the development follows Kimball’s methodology with technical ETL implementation on PostgreSQL. The research produced a Star Schema architecture consisting of one fact table and five dimension tables. Validation testing confirmed complete data integrity during migration. The results demonstrate the system's capability to present rapid multidimensional insights, including positive annual sales trends and profitability disparities across product categories. This implementation proves that PostgreSQL effectively serves as a robust infrastructure for business intelligence, providing a solid foundation for strategic management decision-making.
Perancangan Data Warehouse Menggunakan Metode Nine Step Pada PT. XYZ Shevchenko, Angelus Galang; Maharani, Wianti; Wijaya, Andri
Journal Of Informatics And Busisnes Vol. 3 No. 3 (2025): Oktober - Desember
Publisher : CV. ITTC INDONESIA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.47233/jibs.v3i3.3796

Abstract

PT. XYZ operates in the food distribution sector and handles a large number of inbound and outbound goods transactions each day. The high transaction volume creates challengess in managing inventory effectively, highlighting the need for an integrated data management solution. This research aims to develop a data warehouse for PT. XYZ by applying the Kimball Nine-Step methodology. Data were collected through interviews, field observations, and a review of relevant literature. The data warehouse design process includes identifying fact tables and dimension tables related to receiving and shipping activities, followed by the implementation of the Extract, Transform, Load (ETL) process using SQL Server Management Studio 19. The findings indicate that the proposed data warehouse is capable of integrating operational data and presenting inventory information through reports generated using Microsoft Excel. The system supports improved stock control and enables management to make faster and more accurate decisions.
Perancangan Data Warehouse Untuk Analisis Peminjaman Dan Pengembalian Buku Di Perpustakaan Silaban, Bintang Jelita Nasrani; Zalukhu, Indri Feni Asih; Wijaya, Andri
Journal Of Informatics And Busisnes Vol. 3 No. 3 (2025): Oktober - Desember
Publisher : CV. ITTC INDONESIA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.47233/jibs.v3i3.3837

Abstract

The current library environment is experiencing rapid data collection, particulary from the daily activity of borrowing and returning books. This vast amount of data could potentially be utilized for analysis, but in practice, library information systems are often used solely for operational purposes. Consequently, opportunities to extract valuable insights from this data are limited. Given the situation, this study attempts to design and implement a data warehouse focused on analyzing book borrowing and returning patterns, utilizing PostgreSQL as the primary platform. The research process involved several stages, starting with data collection, needs analysis, data warehouse model design using the star schema, and implementation into PostgreSQL. Afterward, an ETL (Extraction, Transformation, and Loading) process was performed to able to combine library transaction data into a more structured and ready for analysis. From this data, the system was able to generate various insights, such as patterns of books that were borrowed most, medim, and least.
Co-Authors Adi Sucipto, Adi Aditiya Hermawan Aditya, Putra Adtiya, Setenilaus Afifah Azzahra Agustin, Evelyn Agustio Dwitama Aguswan, Michael Junius Alessandro, Andreas Alexander Chandra Alexius Hendra Gunawan Amat Basri Andreas Alessandro Andreas Alessandro Fernando Putra Andri Wijaya Andronikus G Anggoro, Deo Ardi Riyadi Ardika, Petra Putri Arif Aliyanto Arif Aliyanto Arif Aliyanto Arron Mosses Jhon Hadi Arvin Lawistra Asek, Ambo Ayu Elisya Natama Sianturi Azahra, Khalida Zia Fitrah Azzahra, Afifah Azzahra, Violina Baiturrahman, Ridwan Benny Daniawan Bima Aprianto S Br Hombing, Nova Magdalena Branchris Buchori Asyik Chintia Cantika cia, crecia Crecia Crecia Crecia, Crecia Daely, Septia Angelika Gettin Damayanti, Lily Daniawan, Benny Deo anggoro Desty Ervira Puspaningtyas Dwitama, Agustio Effendy, Ellena Endri Yuliati Enjeli, Margareta Erwin Erwin Filikano, Thomas Gunawan, Andronikus Halim, Ardie Hambali, M Syahbani Hans Rafael Gabriel Turnip IFAH KHADIJAH, IFAH Iskandar Mirza Iskandar Syah Jacqueline Henny P Jessen Laorenza Suwandi Johan Abisay Tambunan Julian Masidin, Nevin JUNAEDI Juni Lapita Hasugian Ketut Agus Wiikananda Kevin Alexander Yech Kevin kevin Kurniawan Maranto, Ardiane Rossi Kusneti, Leni Latius Hermawan Leni Kusneti Lily Damayanti Lusia Komala Widiastuti Maharani, Wianti Marcello, Daniel Maria Bellaniar Ismiati Masidin, Nevin Julian Mayer Dani Sitompul Meilinda Meilinda Meilinda Michael Imanuel Michael Junius Aguswan Muhamad Raka Nur Habibi Muhammad Basri Muhammad Firdaus Muhammad Raka Nur Habibi Mujiyanto Mujiyanto Mutia Maharani Nababan, Clara Nova Magdalena Br Hombing Novaldi, Alexander Nurhadi, M Wiran Jaya Oktarina, Theresia Pamungkas, Martinus Ponco Pratama, Paskalis Arindra Puspita Mardika Sari Putra, Steven Adi Raditya Rimbawan Raditya Rimbawan O Ratu, Anggitta Rika Solihah, Rika Riski Surya Saputra Rosana Rosana Samuel Dimas Sutikno Sanjaya, Aloisius Egi Seli Septi Putri Septi Putri Azzahra Septia Angelika Gettin daely Setiawan, Ferdy Shevchenko, Angelus Galang Silaban, Bintang Jelita Nasrani Simanjuntak, Welmi Simbolon, Defrianti Sri Andayani Sri Andayani Stefanus Charles Selvianto Stenilaus A Styaningrum, Silvia Dewi Sugiarti, Sabar Sumual, Imanuel Marcell Supriadi, Jonathan Suwitno Suwitno, Suwitno Thomas Filikano Turnip, Hans Rafael Gabriel Verri Kuswanto Welmi Simanjuntak Wikananda, Ketut Agus Wiyono Yakub, Handoyo Yo Ceng Giap Yoel, Yoel Marcelino Pribadi Yohanes Agung Apriyanto Yusuf Kurnia Zalukhu, Indri Feni Asih