Perancangan Dashboard Transaksi dan Segmentasi Pelanggan untuk Pemesanan Layanan Travel PT Y
Abstract
This research aims to design and implement an interactive dashboard to visualize transactions and customer segmentation in travel services at PT Y. The SDLC Waterfall method was chosen for system development in a structured manner, including requirement analysis, design, implementation, testing, and maintenance. Data collection is done using the ETL (Extract, Transform, Load) method to extract, transform, and load transaction and customer data into a database. The dashboard, built using Power BI, presents transaction information and customer segmentation based on purchasing patterns and demographic characteristics. The research results show that the developed system supports PT Y's management in making more efficient, data-driven decisions. The system also enhances operational efficiency and improves the customer experience in travel services by providing more accurate and timely information.
Keywords: SDLC Waterfall ; Dashboard, ETL ; Transactions ; Customer Segmentation ; Power BI.
Abstrak
Penelitian ini bertujuan merancang dan mengimplementasikan dashboard interaktif untuk memvisualisasikan transaksi dan segmentasi pelanggan pada layanan travel di PT Y. Metode SDLC Waterfall dipilih untuk pengembangan sistem secara terstruktur, meliputi analisis kebutuhan, desain, implementasi, pengujian, dan pemeliharaan. Proses pengumpulan data menggunakan metode ETL (Extract, Transform, Load) untuk mengekstraksi, mentransformasikan, dan memuat data transaksi serta pelanggan ke dalam database. Dashboard yang dibangun menggunakan Power BI ini menyajikan informasi transaksi pemesanan serta segmentasi pelanggan berdasarkan pola pembelian dan karakteristik demografis. Hasil penelitian menunjukkan bahwa sistem yang dikembangkan mendukung manajemen PT Y dalam pengambilan keputusan yang lebih efisien dan berbasis data. Sistem ini juga meningkatkan efektivitas operasional dan memperbaiki pengalaman pelanggan dalam layanan travel, dengan memberikan informasi yang lebih akurat dan tepat waktu.
Keywords
References
D. Ordóñez-Martínez, J. M. Seguí-Pons, and M. Ruiz-Pérez, "Toward Establishing a Tourism Data Space: Innovative Geo-Dashboard Development for Tourism Research and Management," Smart Cities, vol. 7, no. 1, pp. 633–661, Feb. 2024, doi: 10.3390/smartcities7010026.
N. Ibrahim, P. W. Handayani, B. Purwandari, I. Eitiveni, and F. Dzulfikar, "The Segmentation of Mobile Application Users in the Hotel Booking Journey," Interdisciplinary Journal of Information, Knowledge, and Management, vol. 18, pp. 667–689, 2023, doi: 10.28945/5190.
G. Balletto, A. Milesi, M. Ladu, and G. Borruso, "A dashboard for supporting slow tourism in green infrastructures. A methodological proposal in Sardinia (Italy)," Sustainability (Switzerland), vol. 12, no. 9, May 2020, doi: 10.3390/SU12093579.
H. Sutrisno, "Penggunaan dashboard interaktif untuk analisis data pelanggan," Jurnal Teknologi Informasi dan Komunikasi, vol. 11, no. 2, pp. 122-130, Mei 2021.
N. Fadilah Najwa, M. Sari Zulvi, and Y. D. Lulu, "The Market Segmentation Dashboard System Using the Customer Portfolio Management Method," Jurnal Sosioteknologi, vol. 22, no. 3, pp. 374–386, Dec. 2023, doi: 10.5614/sostek.itbj.2023.22.3.9.
Y. Afrianto Singgalen, K. Semanggi, K. Setiabudi, K. Jakarta Selatan, and D. Khusus Ibukota, "Hotel Customer Segmentation for Marketing Strategy Optimization Using CRAF Framework," Journal of Business and Economics Research (JBE), vol. 5, no. 2, pp. 188–200, 2024, doi: 10.47065/jbe.v5i2.5132.
S. Jha, P. Kumar, and R. Singh, "Role of Power BI in Effective Data Visualization and Business Intelligence," Journal of Data Science and Analytics, vol. 12, no. 3, pp. 155–165, 2022.
A. Ramesh, S. Patel, and K. Iyer, "Evaluating the Efficiency of Power BI in Data Analytics and Visualization," International Journal of Business Intelligence Research, vol. 14, no. 1, pp. 45–58, 2021.
Y. Zhang, H. Li, and T. Wang, "Cloud-Based Dashboard Design Using Power BI: A Case Study," International Conference on Data Science and Applications, pp. 387–395, 2020.
E. S. Dewi, E. A. M. Putri, D. Daniel, W. Wasino, and J. T. Beng, "Perbandingan Antara Metode Waterfall Dan Metode RAD Dalam Pembuatan Aplikasi E-Rekrutmen Berbasis Website: Studi Kasus PT XYZ," INTECOMS: Journal of Information Technology and Computer Science, vol. 202, no. 1, pp. 1-10, 2023.
J. A. Smith and R. L. Johnson, "Applying the waterfall model in software development: A case study in inventory management systems," International Journal of Software Engineering, vol. 30, no. 4, pp. 275-288, Dec. 2021.
S M. W. Anderson and L. T. Brown, "Waterfall model in traditional software development: An overview and case study," Journal of Software Engineering and Applications, vol. 34, no. 2, pp. 112-125, Feb. 2022.
J. K. Taylor, "The phases of the Waterfall model in software development," International Journal of Computer Science and Software Engineering, vol. 28, no. 1, pp. 15-22, Jan. 2021.
R. S. Williams, "A comprehensive guide to software development using the Waterfall model," Journal of Software Development Methods, vol. 35, no. 3, pp. 203-217, Mar. 2022.
A. P. Roberts and J. L. Green, "ETL process in data management: Extract, Transform, and Load," Journal of Data Engineering and Management, vol. 22, no. 4, pp. 345-358, Oct. 2021.
M. H. Zhang and T. F. Liu, "Star Schema design in data warehousing for efficient query processing," International Journal of Data Warehousing and Mining, vol. 18, no. 2, pp. 111-123, Apr. 2022.
How To Cite This :
Refbacks
- There are currently no refbacks.
