Article Per Year (5 Year)
p-Index From 2020 - 2025
1.048
P-Index
This Author published in this journals
All Journal Economic Education Analysis Journal INTECOMS: Journal of Information Technology and Computer Science Simtek : Jurnal Sistem Informasi dan Teknik Komputer Jurnal Teknologi Terapan Jurnal Bakti Masyarakat Indonesia Sepakat : Sesi Pengabdian Kepada Masyarakat @-Publik: Jurnal Administrasi Publik
Desi Arisandi
Program Studi Teknik Informatika, Universitas Tarumanagara
Agriculture, Biological Sciences & Forestry Humanities Computer Science & IT Control & Systems Engineering Economics, Econometrics & Finance Education Electrical & Electronics Engineering Engineering Environmental Science Law, Crime, Criminology & Criminal Justice Mechanical Engineering Social Sciences Other

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

Found 11 Documents
Search

 1   2 
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.
Co-Authors Anthony Gunawan, Anthony Arumsari, Chysanti Bernard Dean Sofli Denny Andreas, Denny Dharmawan, William Susanto Dinatha, Vienchenzia Oeyta Dwitama Edi Chandra, Edi Ery Dewayani Ery Dewayani Feni Suwanto, Feni Frans Lienardi, Frans Jap Tji Beng Jeffri Alfred, Jeffri Johyandi Lukmana Juwita Juwita, Juwita Lely Hiryanto Limbor, Ellen Gabriel Mat Syuroh Meilita Chintya Michael Andrian Mudasir Mudasir Muslimin, Murni Nagm, Fouad Nani Widya, Nani Noeratri Andanwerti Nurkholiza, Rahmiyana Nuuridha Matiin, Nuuridha Pakata, Rosmiati Pakata, Salsabila Qadriah, Sekar Aurannisa Ramdhani Richard Richard Ronald Chandra Salsabila, Tasya Mulia Sefira, Fasia Meta Sri Tiatri Sufisan Sufisan Tony Tony Vincentius Gunawan, Vincentius Wasino Wasino Wasino Wasino Wijaya, Angeline Carolina ZAHRO, TIARA