Article Per Year (5 Year)
p-Index From 2021 - 2026
6.968
P-Index
This Author published in this journals
All Journal snimed Seminar Nasional Aplikasi Teknologi Informasi (SNATI) Proceedings of KNASTIK Semantik Prosiding Seminar Nasional Sains Dan Teknologi Fakultas Teknik JSI: Jurnal Sistem Informasi (E-Journal) Jurnal SOLMA Jurnal Ilmiah Matrik JuSiTik : Jurnal Sistem dan Teknologi Informasi Komunikasi Progresif: Jurnal Ilmiah Komputer Zonasi: Jurnal Sistem Informasi Jurnal Informatika dan Rekayasa Perangkat Lunak Jurnal Sistem Informasi dan Sains Teknologi MEANS (Media Informasi Analisa dan Sistem) Jurnal Teknimedia: Teknologi Informasi dan Multimedia CITIZEN: Jurnal Ilmiah Mulitidisiplin Indonesia Jurnal Abdimas Musi Charitas Jurnal Sistem Informasi JSITP JSITIK: Jurnal Sistem Informasi dan Teknologi Informasi Komputer Jurnal Ilmiah Sistem Informasi MDP Student Conference Jurnal Sistem Informasi Journal Of Informatics And Busisnes Jurnal TEFSIN ( Jurnal Teknik Informatika dan Sistem Informasi) Scientica: Jurnal Ilmiah Sains dan Teknologi 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 Jurnal Riset Sistem Informasi Jurnal Sistem Informasi, Manajemen dan Teknologi Informasi INTECH - Informatika Dan Teknologi
Andri Wijaya
Universitas Katolik Musi Charitas
Religion Agriculture, Biological Sciences & Forestry Humanities 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 Industrial & Manufacturing Engineering Languange, Linguistic, Communication & Media Library & Information Science Medicine & Pharmacology Nursing Public Health Social Sciences Other

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

Found 7 Documents
Search
Journal : journal of informatics and busisnes

 1 
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 Data Warehouse Menggunakan Model Star Schema untuk Analisis Penjualan Retail Berbasis PostgreSQL Andri Wijaya; Alexander Novaldi
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.
Implementasi Metode Kimball dan Pendekatan Star Schema dalam Membangun Data Warehouse Analisis E-Commerce Theresia Oktarina; Aloisius Egi Sanjaya; Andri Wijaya
Journal Of Informatics And Busisnes Vol. 3 No. 4 (2026): Januari - Maret
Publisher : CV. ITTC INDONESIA

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

Abstract

Perkembangan platform e-commerce mendorong peningkatan volume data transaksi yang sangat besar dan kompleks. Namun, data tersebut umumnya masih tersimpan dalam sistem operasional yang belum optimal untuk kebutuhan analisis jangka panjang dan pengambilan keputusan strategis. Penelitian ini bertujuan untuk merancang dan mengimplementasikan data warehouse pada platform e-commerce VWX, khususnya pada kategori Pet Supplies, guna mendukung analisis bisnis secara multidimensi. Metode yang digunakan adalah pendekatan Kimball dengan model star schema, yang terdiri dari satu tabel fakta dan dua tabel dimensi. Data diperoleh dari hasil web scraping dan diproses melalui tahapan ETL (Extract, Transform, Load) menggunakan RapidMiner untuk memastikan kualitas, konsistensi, dan kesiapan data. Selanjutnya, data dianalisis menggunakan teknik OLAP seperti roll-up, drill-down, slice, dan dice untuk menggali informasi terkait performa produk, kategori, dan kualitas rating pelanggan. Hasil penelitian menunjukkan bahwa penerapan data warehouse dengan model star schema mampu menyajikan data secara terstruktur dan mempermudah proses analisis, sehingga menghasilkan informasi yang relevan dan dapat dimanfaatkan sebagai dasar pengambilan keputusan yang lebih efektif pada platform e-commerce VWX.
Implementasi Data Mining Dalam Mengkategorikan Produk Terlaris dan Kurang Laris Pada Toko Retail OPQ Menggunakan Metode Naive Bayes Theresia Oktarina; Ketut Agus Wiikananda; Andri Wijaya
Journal Of Informatics And Busisnes Vol. 3 No. 4 (2026): Januari - Maret
Publisher : CV. ITTC INDONESIA

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

Abstract

Pesatnya volume data transaksi menuntut efisiensi dalam pengelolaan stok dan rencana pemasaran di industri ritel. Riset ini mengevaluasi penggunaan algoritma Naive Bayes untuk memisahkan produk di Toko OPQ menjadi kategori "Unggulan" dan "Reguler". Dengan bantuan RapidMiner Studio, dataset diproses melalui fase pembersihan, standarisasi Z-score, serta pengujian dengan rasio data 70:30. Temuan eksperimen menunjukkan akurasi model mencapai 99%. Meski demikian, ditemukan kendala pada nilai presisi kelas "Unggulan" yang hanya sebesar 16,67% akibat adanya ketimpangan distribusi jumlah sampel. Studi ini menyimpulkan bahwa metode ini efektif untuk memetakan tren, namun memerlukan optimasi pada keseimbangan dataset
Co-Authors Aditya, Putra Adtiya, Setenilaus Afifah Azzahra Agnes Felicia Lubis Agustio Dwitama Agustio Dwitama Aguswan, Michael Junius Alessandro, Andreas Alexander Novaldi Alfonso Sitompul Aloisius Egi Sanjaya Andreas Alessandro Andreas Alessandro Fernando Putra Anggoro, Deo Ardi Riyadi Arif Aliyanto Arif Aliyanto Arif Aliyanto Arif Aliyanto Arif Aliyanto Arron Mosses Jhon Hadi Arron Mosses Jhon Hadi Ayu Elisya Natama Sianturi Ayu Elisya Natama Sianturi Azzahra, Afifah Azzahra, Violina Buchori Asyik Clara Nababan Crecia Crecia Crecia Crecia Crecia, Crecia Damayanti, Lily Daniawan, Benny Daniel Marcello Deo anggoro Dwitama, Agustio Effendy, Ellena Enjeli, Margareta Erwin Erwin Erwin erwin Filikano, Thomas Gunawan, Andronikus Hanna Christy Iskandar Syah Jacqueline Henny P Johan Abisay Tambunan Jonathan Supriadi Julian Masidin, Nevin Ketut Agus Wiikananda Kevin kevin Kusneti, Leni Latius Hermawan Maria Bellaniar Ismiati Martinus Ponco Pamungkas Masidin, Nevin Julian Meilinda Meilinda Meilinda Michael Junius Aguswan Michael Junius Aguswan Muhammad Basri Mutia Maharani Novaldi, Alexander P. Arindra Pratama Pamungkas, Martinus Ponco Petra Putri Ardika Pratama, Paskalis Arindra Putra, Steven Adi Ratu, Anggitta Rosana Rosana Seli Septi Putri Septi Putri Azzahra Septia Angelika Gettin daely, Septia Angelika Gettin daely Setenilaus Aditya Simbolon, Defrianti Simbolon, Defrianti Sri Andayani Sri Andayani Stefanus Agung Sagita Stefanus Charles Selvianto, Stefanus Charles Selvianto Steven Adi Putra Sugiarti, Sabar Sumual, Imanuel Marcell Supriadi, Jonathan Theresia Anita Theresia Oktarina Thomas Filikano Thomas Filikano VF Anindya W Wayan Pondra Lesmana Yakub, Handoyo Yohanes Agung Apriyanto