Perancangan Dashboard Dalam Meningkatkan Efektivitas Manajemen Penjualan Tiket Pesawat Pada PT JKL
Abstract
This study aims to design a data-driven dashboard to enhance the effectiveness of airline ticket sales management at PT JKL. The dashboard was developed using the Prototype method and the ETL (Extract, Transform, Load) process to construct a Star Schema, enabling efficient data integration from various sources. Leveraging Power BI, the dashboard provides interactive visualizations of sales data, including the number of flights, revenue, discounts, payment methods, and the most frequently booked airlines. The implementation of this dashboard not only simplifies data analysis but also supports faster and more accurate decision-making. Testing results showed that all dashboard features functioned as specified, with Black Box validation achieving "Pass" status across all tests and User Acceptance Testing (UAT) achieving "Success" status in all tested scenarios. The implementation of this dashboard streamlines data analysis, accelerates decision-making processes, and enables real-time monitoring of business performance. This study demonstrates that a data-driven dashboard can positively impact operational efficiency and support strategic decision-making for the business growth of PT JKL.
Keyword: Dashboard; Power BI; ETL.
Abstrak
Penelitian ini bertujuan untuk merancang sebuah dashboard berbasis data guna meningkatkan efektivitas manajemen penjualan tiket pesawat pada PT JKL. Dashboard ini dirancang menggunakan metode Prototype dan proses ETL (Extract, Transform, Load) untuk membangun Star Schema yang memungkinkan integrasi data dari berbagai sumber secara efisien. Dengan memanfaatkan Power BI, dashboard ini mampu menyajikan data penjualan secara interaktif, dan termasuk jumlah penerbangan, pendapatan, diskon, metode pembayaran, dan maskapai yang paling sering dipesan. Implementasi dashboard ini tidak hanya mempermudah analisis data tetapi juga mendukung pengambilan keputusan yang lebih cepat dan tepat. Hasil pengujian menunjukkan bahwa seluruh fitur dashboard berfungsi sesuai spesifikasi, dengan validasi Black Box menghasilkan status "Pass" untuk semua pengujian, dan User Acceptance Testing (UAT) menghasilkan status "Success" pada seluruh skenario yang diuji. Implementasi dashboard ini menyederhanakan analisis data, mempercepat pengambilan keputusan, dan mendukung pemantauan kinerja bisnis secara. Hasil penelitian ini menunjukkan bahwa dashboard berbasis data dapat memberikan dampak positif terhadap efisiensi operasional serta mendukung pengambilan keputusan strategis untuk pertumbuhan bisnis PT JKL.
Keywords
References
B. D. Utama dan J. F. Rezki, “Perkembangan industri penerbangan dan pertumbuhan ekonomi di Indonesia,” Jurnal Ilmu Pemerintahan Suara Khatulistiwa, vol. 6, no. 2, pp. 213–220, Des. 2021.
G. I. Setyawan, Kurniawan, and L. W. P. Suhartana, “Legal Protection Of Consumer Rights In The Purchase Of The Airplane’s Passengers Insurance Premiums Through Traveloka Sites,” Jurnal IUS Kajian Hukum dan Keadilan, vol. 7, no. 1, pp. 156–169, Apr. 2019, doi: 10.29303/ius.v7i1.632.
J. T. Beng et al., “Designing mathematics, science, and reading competency dashboard using business intelligence algorithm.” AIP Conf. Proc 2680, 020179 (2023)
N. Y. Arifin dan O. Veza, “Dashboard sistem aplikasi pengelolaan obat,” Engineering and Technology International Journal, vol. 1, no. 2, pp. 59–65, Nov. 2019.
P. Diana Nopianti, S. Dian Purnamasari, and M. Ariandi, “Dashboard Monitoring Pemesanan Produk Percetakan Dengan Pendekatan Key Performance Indikator,” Media Online), vol. 4, no. 1, pp. 497–505, 2023, doi: 10.30865/klik.v4i1.1155.
B. Y. Geni, O. Kurnia, R. R. S. Putra, dan R. Gunawan, “Perancangan sistem informasi dashboard BPJS berbasis Visual Basic,” Jurnal MBI, vol. 17, no. 12, pp. 2837–2845, Jul. 2023.
R. Sandi and D. Trisnawarman, “Desain Dasboard Untuk Analisis Harga Pangan Di Indonesia Dashboard Design For Food Price Analysis In Indonesia,” Journal of Information Technology and Computer Science (INTECOMS), vol. 7, no. 3, pp. 872–880, 2024.
M. Belghith, H. Ben Ammar, F. Masmoudi, and A. Elloumi, “Data Visualization for Industry 4.0: Developing Dashboards with Power BI – A Case Study in a Pharmaceutical Company,” in Lecture Notes in Mechanical Engineering, Springer Science and Business Media Deutschland GmbH, 2023, pp. 402–408. doi: 10.1007/978-3-031-14615-2_45.
C. Damar, S. Wardhana, and D. Trisnawarman, “Analitika Kejahatan: Memanfaatkan Metode Addie Untuk Merancang Dashboard Interaktif Tentang Tren Dan Analisis Kejahatan Crime Analytics: Utilizing Addie Methods To Design An Interactive Dashboard On Crime Trends And Analytics,” Journal of Information Technology and Computer Science (INTECOMS), vol. 7, no. 3, pp. 894–900, 2024,
Nurhadi and Muhammad Ridwan, “Sistem Informasi Inventaris Berbasis Web Menggunakan Metode Prototype,” Jurnal Multidisiplin Madani, vol. 2, no. 9, pp. 3543–3550, Sep. 2022, doi: 10.55927/mudima.v2i9.1143.
H. Huang, Z. Wu, W. Li, J. Huo, and Y. Gao, "Local descriptor-based multi-prototype network for few-shot learning," Pattern Recognition, vol. 116, no. 107935, pp. 1–10, Mar. 2021, doi: 10.1016/j.patcog.2021.107935.
A. D. Barahama and R. Wardani, “Utilization Extract, Transform, Load for Developing Data Warehouse in Education Using Pentaho Data Integration,” in Journal of Physics: Conference Series, vol. 2111, no. 1, pp. 012030, Dec. 2021, doi: 10.1088/1742-6596/2111/1/012030.
M. Madhikerrni and K. Främling, “Data discovery method for Extract- Transform-Load,” in 2019 IEEE 10th International Conference on Mechanical and Intelligent Manufacturing Technologies, ICMIMT 2019, Institute of Electrical and Electronics Engineers Inc., May 2019, pp. 174–181. doi: 10.1109/ICMIMT.2019.8712027.
A. S. R. M. Sinaga, "Data Mining Informasi Tingkat Kelulusan Mahasiswa STMIK Pelita Nusantara Medan," Jurnal Manajemen dan Informatika Komputer Pelita Nusantara, vol. 1, no. 1, pp. 27–35, Jul. 2017.
F. Z. D. Wardhani and J. Wiratama, “Improving the Quality of Service: ETL Implementation on Data Warehouse at Pharmacy Industry,” Jurnal TEKNO KOMPAK, vol. 18, no. 1, pp. 1–14, 2023.
How To Cite This :
Refbacks
- There are currently no refbacks.
