OPTIMALISASI ANALISIS PENDAPATAN NON-AERONAUTIKA BANDARA MELALUI PENGEMBANGAN DASHBOARD INTERAKTIF DAN SISTEM VERIFIKASI BERBASIS STREAMLIT

Abstract

Non-aeronautical revenue has become a strategic component for modern airport operators, yet at PT Angkasa Pura Indonesia’s Juanda International Airport branch the recording of tenant revenue, revenue sharing, accrual, and passenger traffic data was still performed manually through scattered Microsoft Excel files, making it prone to human error, duplication, and data discrepancy across terminals. This study aims to design and develop the Dashboard APS Non-Aeronautical, a web-based Business Intelligence system that integrates non-aeronautical revenue data into a single centralized platform using the Python Streamlit framework and a PostgreSQL database. The system was built following a system development life cycle, beginning with business-process analysis, the design of an Entity Relationship Diagram of seven entities, physical schema implementation through Data Definition Language, data cleansing and validation, and the construction of eight functional modules: Overview, Revenue Sharing, Accrual & Billing, Room Database, Lease Contract, Data Import Manager, Traffic Monitor, and Data Verification. A rule-based system applying forward chaining was implemented on the authentication module to enforce Role-Based Access Control, while anomaly-detection techniques were embedded in the Data Verification module to safeguard data integrity. The results show that the dashboard successfully replaces the fragmented manual process with a centralized, real-time, and auditable platform, presenting seven key performance indicators and enabling faster, data-driven decision making for airport management. The system also strengthens data accountability through tiered access rights and an audit trail of upload activity. Pendapatan non-aeronautika telah menjadi komponen strategis bagi pengelola bandar udara modern, namun pada PT Angkasa Pura Indonesia Kantor Cabang Bandar Udara Internasional Juanda Surabaya pencatatan data pendapatan tenant, bagi hasil (revenue sharing), akrual, serta lalu lintas penumpang masih dilakukan secara manual menggunakan berkas Microsoft Excel yang tersebar di berbagai terminal sehingga rawan terhadap galat manusia, duplikasi, dan selisih data antar-terminal. Penelitian ini bertujuan merancang dan mengembangkan Dashboard APS Non-Aeronautical, yaitu sistem Business Intelligence berbasis web yang mengintegrasikan data pendapatan non-aeronautika ke dalam satu platform terpusat dengan memanfaatkan framework Python Streamlit dan basis data PostgreSQL. Sistem dibangun melalui tahapan pengembangan yang sistematis, dimulai dari analisis proses bisnis, perancangan Entity Relationship Diagram tujuh entitas, implementasi skema fisik melalui Data Definition Language, pembersihan dan validasi data, hingga pembangunan delapan modul fungsional, yakni Overview, Revenue Sharing, Accrual & Billing, Room Database, Lease Contract, Data Import Manager, Traffic Monitor, dan Data Verification. Sistem berbasis aturan (rule-based) dengan penalaran maju (forward chaining) diterapkan pada modul otentikasi untuk menegakkan Role-Based Access Control, sementara teknik deteksi anomali ditanamkan pada modul Data Verification guna menjaga integritas data. Hasil penelitian menunjukkan bahwa dashboard berhasil menggantikan proses manual yang terfragmentasi menjadi platform terpusat yang real-time dan mudah ditelusuri, menyajikan tujuh indikator kinerja utama, serta mempercepat pengambilan keputusan berbasis data bagi manajemen bandara. Sistem juga memperkuat akuntabilitas data melalui hak akses berjenjang dan audit trail riwayat aktivitas unggahan.