ANALYSIS OF DATA ACCESS USING LOOKER STUDIO-BASED E-REPORT FOR PROHIBITED ITEMS RECONCILIATION AT HBSCP IN KALIMARAU AIRPORT

Abstract

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 e-report 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.