cover
Contact Name
ahmad gawdy prananosa
Contact Email
ahmadgawdynano@yahoo.com
Phone
-
Journal Mail Official
ipm2kpeintecoms@gmail.com
Editorial Address
-
Location
Unknown,
Unknown
INDONESIA
INTECOMS: Journal of Information Technology and Computer Science
ISSN : 26213249     EISSN : 26141574     DOI : -
Core Subject : Science,
Arjuna Subject : -
Articles 738 Documents
DESIGNING A DATA MART FOR OPTIMIZING CLOTHING SALES AT C STORE Limbor, Ellen Gabriel; Beng, Jap Tji; Arisandi, Desi; Tiatri, Sri; Nurkholiza, Rahmiyana; Salsabila, Tasya Mulia; Dinatha, Vienchenzia Oeyta Dwitama
INTECOMS: Journal of Information Technology and Computer Science Vol. 8 No. 5 (2025): INTECOMS: Journal of Information Technology and Computer Science
Publisher : Institut Penelitian Matematika, Komputer, Keperawatan, Pendidikan dan Ekonomi (IPM2KPE)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31539/7k3f3443

Abstract

Data plays a crucial role in supporting strategic decision-making, particularly in the retail sector like C Store. To enhance sales performance and understand purchasing trends, an effective system such as a data mart is needed. This study aims to design a data mart that can be used to analyze sales data at C Store to support data-driven decision-making. The methodology used is the nine-step Kimball approach in data mart design. The ETL (Extract, Transform, Load) process is used to manage sales transaction data collected from the period of 2021 to 2024. The result of this study is a data mart with a star schema, consisting of fact and dimension tables, enabling the analysis of sales performance based on product categories and time. The implementation of this data mart is expected to assist C Store in managing data efficiently, supporting strategic decision-making, and improving business operational effectiveness. Keywords: Data Mart, Kimball's Nine-Step Process, Clothing Sales.
DATA MART DESIGN FOR Y CLOTHING STORE SALES Wijaya, Angeline Carolina; Beng, Jap Tji; Arisandi, Desi; Tiatri, Sri; Dinatha, Vienchenzia Oeyta Dwitama; Nurkholiza, Rahmiyana; Sefira, Fasia Meta
INTECOMS: Journal of Information Technology and Computer Science Vol. 8 No. 5 (2025): INTECOMS: Journal of Information Technology and Computer Science
Publisher : Institut Penelitian Matematika, Komputer, Keperawatan, Pendidikan dan Ekonomi (IPM2KPE)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31539/qr7rg481

Abstract

The data mart design for Y Clothing store aims to integrate scattered sales data to simplify analysis and speed up business decision making. Using the Kimball Nine-Step method and ETL process, sales transaction data from 2019 to 2023 is managed in a star schema. As a result, these data marts enable faster and more accurate analysis, identifying customer purchasing patterns, sales trends and promotional effectiveness. Implementation of this data mart increased inventory management efficiency by 15% and reduced sales report generation time from hours to minutes. However, challenges such as significant resource allocation for initial implementation and a learning curve for employees slowed down the maximum benefit gain somewhat. However, overall, these data marts contribute greatly to improved business decisions and more effective sales strategies. Keywords: Data Mart, Y Clothing Store, Kimball Nine-Step Method, ETL Process, Star Schema.
DESIGNING A DATA WAREHOUSE FOR AIRLINE TICKET SALES AT PT ABC Qadriah, Sekar Aurannisa Ramdhani; Beng, Jap Tji; Arisandi, Desi; Nagm, Fouad; Salsabila, Tasya Mulia; Zahro, Tiara; Dinatha, Vienchenzia Oeyta Dwitama
INTECOMS: Journal of Information Technology and Computer Science Vol. 8 No. 5 (2025): INTECOMS: Journal of Information Technology and Computer Science
Publisher : Institut Penelitian Matematika, Komputer, Keperawatan, Pendidikan dan Ekonomi (IPM2KPE)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31539/hfhqv835

Abstract

The high demand for airline ticket purchases in Indonesia and ticket sales being one of the important assets for companies in the aviation industry. PT ABC requires a system that can effectively manage this data to support business analysis and strategic decision-making. This research aims to design a data warehouse that can integrate airline ticket sales data, enabling more efficient data storage, processing, and analysis. The approach used in the design of this data warehouse is the star schema, which consists of one main fact table and several dimension tables. The fact table contains ticket sales transaction data, while the dimension tables include information about time, flight routes, airlines, and customers. This research provides a primary contribution in the form of a data warehouse design that integrates airline ticket sales data, enabling faster and more accurate analysis. The resulting business impact includes increased operational efficiency, more accurate data-driven decision-making, and the ability to monitor sales trends in real-time through interactive dashboards. With this data warehouse, PT ABC can reduce data analysis time and improve the accuracy of sales trend predictions. Keywords: Data warehouse, Star Schema, PT ABC plane ticket sales, Business Intelligence.
DESIGN OF A DATA WAREHOUSE FOR CUSTOMER SEGMENTATION PREDICTION AT PT X Lawrence, Valerie; Beng, Jap Tji; Wasino, Wasino; Tiatri, Sri; Nurkholiza, Rahmiyana; Salsabila, Tasya Mulia; Sefira, Fasia Meta
INTECOMS: Journal of Information Technology and Computer Science Vol. 8 No. 5 (2025): INTECOMS: Journal of Information Technology and Computer Science
Publisher : Institut Penelitian Matematika, Komputer, Keperawatan, Pendidikan dan Ekonomi (IPM2KPE)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31539/he6dx426

Abstract

With the rapid growth of the tourism industry, particularly within the hotel and airline sectors, understanding customer behavior and segmentation has become crucial for driving strategic decisions. However, customer segmentation in these sectors often faces challenges due to the complexity of transactional data and varying service demands. This study addresses these challenges by designing a data warehouse using a Star Schema architecture, aimed at integrating hotel and airline booking data from 2023 to 2024. The methodology follows the Nine-Step Kimball approach, coupled with the Extract, Transform, Load (ETL) process, to transform transactional data from OLTP systems into a format suitable for Online Analytical Processing (OLAP). The data warehouse features fact and dimension tables that support in-depth analysis of customer segments, booking trends, and performance across service categories and time periods. Key findings show that the data warehouse significantly improves the ability to segment customers based on booking behavior, seasonality, and service preferences, leading to more effective decision-making. This integrated system provides a robust foundation for data-driven strategies, allowing businesses in the tourism industry to optimize customer targeting, improve service offerings, and enhance operational efficiency. Keywords: Data Warehouse, Star Schema, ETL, Hotel Booking, Flight
ANALISIS OVERALL EQUIPMENT EFFECTIVENESS CONTINUOUS SHIP UNLOADER DENGAN PENERAPAN TOTAL PRODUCTIVE MAINTENANCE DI PT XYZ Vicky Ahmadi, Muhammad; Rizqi, Akhmad Wasiur; Priyana, Efta Dhartikasari
INTECOMS: Journal of Information Technology and Computer Science Vol. 8 No. 5 (2025): INTECOMS: Journal of Information Technology and Computer Science
Publisher : Institut Penelitian Matematika, Komputer, Keperawatan, Pendidikan dan Ekonomi (IPM2KPE)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31539/mh2d8056

Abstract

PT XYZ memiliki Terminal Untuk Kepentingan Sendiri (TUKS) dengan frekuensi tinggi aktivitas bongkar muat yaitu unloading yang dilakukan oleh continuous ship unloader.  Penelitian ini bertujuan menganalisis nilai Overall Equipment Effectiveness (OEE) dari continuous ship unloader dengan penerapan Total Productive Maintenance (TPM). Tingginya aktivitas unloading menimbulkan kemungkinan terjadinya kerusakan pada peralatan yang dapat memberhentikan unloading. Dalam menjaga kontinuitas unloading diperlukan pemeliharaan yang mampu memaksimalkan efektivitas dengan menerapkan TPM. Tujuan TPM adalah mengikutsertakan semua karyawan pada seluruh departemen untuk menyusun, memakai, atau memelihara peralatan dalam rangka meningkatkan sistem pemeliharaan produktif guna mengoptimalkan efektivitas peralatan. Hasil dari penerapan TPM diharapkan dapat meningkatkan efektivitas sekaligus nilai OEE dari continuous ship unloader. Dalam penelitian ini dihasilkan rata-rata OEE sebesar 72,88% tidak tergolong standar dunia OEE minimal 85%. Perlunya tindakan perbaikan yaitu memberikan buzzer di kabin operator ketika beban tinggi sebelum terjadi overload dan membuat sistem pelumasan otomatis pada setiap bagian mesin yang memerlukan pelumasan. Kata Kunci: TPM, OEE, Efektivitas, Continuous Ship Unloader
RANCANG BANGUN PROTOTYPE SISTEM RUMAH HEMAT ENERGI BERBASIS INTERNET OF THINGS Berliyanto, Berliyanto; Prabowo, Bagus; Hanifah, Nur; Lola, Lola; Riza, Faizal
INTECOMS: Journal of Information Technology and Computer Science Vol. 8 No. 5 (2025): INTECOMS: Journal of Information Technology and Computer Science
Publisher : Institut Penelitian Matematika, Komputer, Keperawatan, Pendidikan dan Ekonomi (IPM2KPE)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31539/1vefpp34

Abstract

Penelitian ini bertujuan untuk memberikan kemudahan dan efisiensi bagi user atau pemilik rumah dalam mengendalikan dan me-monitoring peralatan elektronik yang digunakan dirumah dengan pemanfaatan teknologi smartphone dan koneksi internet agar dapat melakukan pengendalian dari jarak jauh. Dengan tujuan tersebut, maka dibuatlah perancangan sistem Rumah Hemat Energi dengan konsep Internet of Things (IoT). Metode yang digunakan dalam penelitian ini adalah metode simulasi prototyping. Hasil dari penelitian ini adalah prototype sistem alat rumah hemat energi yang terdiri dari beberapa komponen seperti sensor gerak, dan modul relay. Sistem ini dapat dikendalikan melalui internet menggunakan aplikasi pada smartphone. Diharapkan sistem ini dapat membantu pengguna dalam mengontrol perangkat-perangkat di rumah secara efisien dan mudah.
ANALISIS PERAWATAN GENSET DENGAN MENGGUNAKAN METODE RELIABILITY CENTERED MAINTENANCE DI PT PERTAMINA EP PRABUMULIH Arifin, Fuadil; Kusmindari , CH. Desi; Anwar , Andries; Makmuri, M. Kumroni
INTECOMS: Journal of Information Technology and Computer Science Vol. 8 No. 5 (2025): INTECOMS: Journal of Information Technology and Computer Science
Publisher : Institut Penelitian Matematika, Komputer, Keperawatan, Pendidikan dan Ekonomi (IPM2KPE)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31539/dy057870

Abstract

Penelitian ini bertujuan untuk menganalisis keandalan genset dan menyusun strategi perawatan berbasis metode Reliability Centered Maintenance (RCM) di PT Pertamina EP Prabumulih. Komponen yang paling kritis berdasarkan hasil FMEA adalah valve, dengan nilai Risk Priority Number (RPN) tertinggi sebesar 256 dan tergolong hidden failure. Kerusakan komponen ini tercatat dua kali selama tahun 2024 dan menyebabkan downtime selama 144 jam. Nilai Mean Time To Failure (MTTF) sebesar 1.288 jam dan Mean Time To Repair (MTTR) sebesar 35,33 jam menghasilkan nilai availability sistem sebesar 97,33%. Strategi perawatan yang diterapkan terdiri dari kombinasi Condition Directed (CD), Failure Finding (FF), dan Run to Failure (RTF), dengan jadwal disusun menggunakan distribusi Weibull. Hasil penerapan metode RCM terbukti menurunkan downtime rata-rata dari 18 jam menjadi 7,3 jam per kejadian, serta meningkatkan keandalan dan efisiensi operasional sistem genset di lingkungan kerja migas.
IMPLEMENTASI ALGORITMA FLOYD-WARSHALL UNTUK OPTIMASI RUTE TERPENDEK ANTAR KOTA DI JAWA TIMUR Sumunarsih, Sumunarsih; Fachrie, Muhammad
INTECOMS: Journal of Information Technology and Computer Science Vol. 8 No. 5 (2025): INTECOMS: Journal of Information Technology and Computer Science
Publisher : Institut Penelitian Matematika, Komputer, Keperawatan, Pendidikan dan Ekonomi (IPM2KPE)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31539/zja1j550

Abstract

Sektor transportasi memiliki peran krusial dalam mengoptimalkan aktivitas ekonomi dan pergerakan masyarakat, terutama di daerah dengan konektivitas yang baik seperti Provinsi Jawa Timur. akan tetapi, lonjakan jumlah kendaraan serta kerumitan jaringan jalan sering kali mengakibatkan ketidakefisienan dalam memilih rute perjalanan antar kota. masalah ini berdampak pada peningkatan biaya operasional, lama perjalanan yang tidak esifien, serta penurunan kualitas layanan transportasi. untuk mengatasi masalah ini, penelitian ini bertujuan untuk merancang dan mengembangkan sistem pengoptimalan rute antar kota di Jawa Timur dengan memanfaatkan algoritma floyd-warshall. metode yang diterapkan dalam penelitian ini mencakup pengumpulan data jarak antar kota menggunakan platform kaggle yang diverifikasi melalui Google Maps. selanjutnya, proses dirancang dengan algoritma floyd-warshall untuk menentukan jarak terpendek antara setiap pasangan kota. sistem ini dibangun berbasis web dengan menggunakan bahasa pemrograman python dan framework Flask untuk memungkinkan interaksi langsung dengan pengguna. hasil dari pengujian menunjukkan bahwa penerapan algoritma floyd-warshall secara independen menghasilkan akurasi sebesar 87%. selain itu, sistem ini juga menampilkan rute yang dioptimalkan secara visual melalui integrasi dengan Google Maps, sehingga pengguna dapat lebih memahami jalur yang disarankan dalam konteks geografis. sebagai kesimpulan, penelitian ini berhasil menciptakan sistem pengoptimalan rute berbasis algoritma floyd-warshall yang mampu memberikan hasil perhitungan rute terpendek dengan tingkat akurasi yang lumayan baik. diharapkan, implementasi sistem ini dapat berkontribusi pada penerapan intelligent Transportasi System (ITS

Filter by Year

2018 2025


Filter By Issues
All Issue Vol. 8 No. 5 (2025): INTECOMS: Journal of Information Technology and Computer Science Vol. 8 No. 4 (2025): INTECOMS: Journal of Information Technology and Computer Science Vol. 8 No. 3 (2025): INTECOMS: Journal of Information Technology and Computer Science Vol. 8 No. 2 (2025): INTECOMS: Journal of Information Technology and Computer Science Vol 8 No 2 (2025): INTECOMS: Journal of Information Technology and Computer Science Vol 8 No 1 (2025): INTECOMS: Journal of Information Technology and Computer Science Vol 7 No 6 (2024): INTECOMS: Journal of Information Technology and Computer Science Vol 7 No 5 (2024): INTECOMS: Journal of Information Technology and Computer Science Vol 7 No 4 (2024): INTECOMS: Journal of Information Technology and Computer Science Vol 7 No 3 (2024): INTECOMS: Journal of Information Technology and Computer Science Vol 7 No 2 (2024): INTECOMS: Journal of Information Technology and Computer Science Vol 7 No 1 (2024): INTECOMS: Journal of Information Technology and Computer Science Vol 6 No 2 (2023): INTECOMS: Journal of Information Technology and Computer Science Vol 6 No 1 (2023): INTECOMS: Journal of Information Technology and Computer Science Vol 5 No 2 (2022): INTECOMS: Journal of Information Technology and Computer Science Vol 5 No 1 (2022): INTECOMS: Journal of Information Technology and Computer Science Vol 4 No 2 (2021): INTECOMS: Journal of Information Technology and Computer Science Vol 4 No 1 (2021): INTECOMS: Journal of Information Technology and Computer Science Vol 3 No 2 (2020): INTECOMS: Journal of Information Technology and Computer Science Vol 3 No 1 (2020): INTECOMS: Journal of Information Technology and Computer Science Vol 2 No 2 (2019): INTECOMS: Journal of Information Technology and Computer Science Vol 2 No 1 (2019): INTECOMS: Journal of Information Technology and Computer Science Vol 1 No 2 (2018): INTECOMS: Journal of Information Technology and Computer Science Vol 1 No 1 (2018): INTECOMS: Journal of Information Technology and Computer Science More Issue