DESIGNING A DATA WAREHOUSE FOR AIRLINE TICKET SALES AT PT ABC

Authors

Sekar Aurannisa Ramdhani Qadriah Universitas Tarumanagara, Jakarta, Indonesia
Jap Tji Beng Universitas Tarumanagara
Desi Arisandi Universitas Tarumanagara, Jakarta, Indonesia
Fouad Nagm BT Financial Group, Sydney, Australia
Tasya Mulia Salsabila Universitas Indonesia, Indonesia
Tiara Zahro Universitas Tarumanagara, Jakarta, Indonesia
Vienchenzia Oeyta Dwitama Dinatha INTI International University, Malaysia

DOI:

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.

References

Barahama, A. D., & Wardani, R. (2021, November). Utilization extract, transform, load for developing data warehouse in education using Pentaho Data Integration. In Journal of Physics: Conference Series (Vol. 2111, No. 1, p. 012030). IOP Publishing.

Beng, J. T., Amanto, A. F., Aurelia, A., Chandra, D., Mandey, K. Y. D., Ramadhani, L. A., ... & Tiatri, S. (2023, December). Designing mathematics, science, and reading competency dashboard using business intelligence algorithm. In AIP Conference Proceedings (Vol. 2680, No. 1, p. 020179). AIP Publishing LLC.

Dhaouadi, A., Bousselmi, K., Gammoudi, M. M., Monnet, S., & Hammoudi, S. (2022). Data warehousing process modeling from classical approaches to new trends: Main features and comparisons. Data, 7(8), 113.

Halim, N. A., Alhazmy, N. A., & Rasyad, M. A. (2024). Advanced Data Modeling dengan Metodologi Kimball: Systematic Literature Review. Jurnal Sosial Teknologi, 4(8), 639-650.

Lukas, K., Arisandi, D., & Jap, T. B. (2024). Perancangan Aplikasi Promosi dan Penjualan Produk Berbasis Website Pada Toko Baju Wearsarey. Jurnal Ilmu Komputer dan Sistem Informasi, 12(1).

Madhikerrni, M., & Främling, K. (2019, May). Data discovery method for extract-transform-load. In IEEE International Conference on Mechanical and Intelligent Manufacturing Technologies (pp. 174-181). IEEE.

Nambiar, A., & Mundra, D. (2022). An overview of data warehouse and data lake in modern enterprise data management. Big data and cognitive computing, 6(4), 132.

Peng, Y., Henke, E., Reinecke, I., Zoch, M., Sedlmayr, M., & Bathelt, F. (2023). An ETL-process design for data harmonization to participate in international research with German real-world data based on FHIR and OMOP CDM. International Journal of Medical Informatics, 169, 104925.

Pratama, I. P. A. E., & Raharja, I. M. S. (2023). Business Intelligence Based on Kimball Nine-Steps Methodology for Monitoring the Feasibility of Goods in Market. International Journal of Advances in Data and Information Systems, 4(2), 135-144.

Sihombing, D. J. C. (2022). Academic Data Warehouse Modeling In Higher Education Using Nine-Step Design Methodology. Journal Of Information Systems And Informatics, 4(4).

Subroto, V. K., & Endaryati, E. (2021). Business Intelligence Dan Kesuksesan Bisnis Di Era Digital. Dinamika: Jurnal Manajemen Sosial Ekonomi, 1(2), 41-47.

Utama, B. D., & Rezki, J. F. (2021). Perkembangan industri penerbangan dan pertumbuhan ekonomi di Indonesia. Jurnal Ilmu Pemerintahan Suara Khatulistiwa, 6(2), 213-223.