RANCANGAN E-REPORT REKONSILIASI PROHIBITED ITEMS BERBASIS LOOKER STUDIO UNTUK AKSES DATA PADA HBSCP DI UPBU KELAS I KALIMARAU

Keamanan penerbangan merupakan aspek krusial dalam operasional
bandara yang memerlukan sistem pencatatan dan pelaporan sesuai prosedur. Unit
Penyelenggara Bandar Udara (UPBU) Kelas I Kalimarau dengan kategori Sistem
Keamanan E menghadapi permasalahan dalam proses rekonsiliasi prohibited items
yang masih dilakukan secara manual di Hold Baggage Security Check Point
(HBSCP).
Penelitian ini bertujuan untuk merancang e-report rekonsiliasi prohibited
items berbasis Looker Studio, mengetahui cara kerja sistem e-report, dan
mengetahui kemampuannya dalam mengatasi permasalahan pencatatan dan
pelaporan data rekonsiliasi. Penelitian ini menggunakan metode Research and
Development (R&D) dengan model pengembangan ADDIE (Analysis, Design,
Development, Implementation, Evaluation). Sistem dikembangkan dengan
memanfaatkan Google Sheets sebagai basis data dan Looker Studio sebagai alat
visualisasi dan analisis data untuk mempermudah koordinasi antara petugas
AVSEC, airline, dan customer service.
Hasil evaluasi menunjukkan sistem sangat layak digunakan dengan validasi
ahli materi dan ahli desain/IT mencapai rata-rata persentase 91,7% dan usability
testing pengguna memperoleh persentase 95,27%, keduanya termasuk kategori
"sangat layak". Sistem e-report ini terbukti mampu menjadi solusi untuk
permasalahan pencatatan dan pelaporan rekonsiliasi prohibited items,
meningkatkan operasional bandar udara, keselamatan penerbangan, dan
pengelolaan arsip yang lebih baik di UPBU Kelas I Kalimarau.
Kata kunci : e-report, prohibited items, Looker Studio, HBSCP, Keamanan
Penerbangan
============================================================
Aviation security is a crucial aspect of airport operations that requires
proper recording and reporting systems according to established procedures. The
Airport Management Unit (UPBU) Class I Kalimarau with Security System
Category E faces challenges in the prohibited items reconciliation process that is
still conducted manually at the Hold Baggage Security Check Point (HBSCP).
This research aims to design a Looker Studio-based e-report for prohibited
items reconciliation, understand the working mechanism of the e-report system, and
determine its capability in addressing recording and reporting issues in
reconciliation data. This study employs Research and Development (R&D)
methodology with the ADDIE development model (Analysis, Design, Development,
Implementation, Evaluation). The system was developed utilizing Google Sheets as
the database and Looker Studio as the data visualization and analysis tool to
facilitate coordination among AVSEC personnel, airline staff, and customer
service.
The evaluation results demonstrate that the system is highly suitable for
implementation, with expert validation from subject matter experts and design/IT
experts achieving an average percentage of 91.7%, while usability testing from
users obtained a percentage of 95.27%, both categorized as "very worthy". This ereport system has proven capable of providing solutions for recording and
reporting issues in prohibited items reconciliation, improving airport operations,
aviation safety, and better archive management at Kalimarau Airport.
Keywords : e-report, prohibited items, Looker Studio, HBSCP, aviation
security