Strategi Business Process Improvement Melalui Basis Data Terintegrasi Airtable pada CV Nawasena Pangan Kreatif

Abstract

CV Nawasena Pangan Kreatif menghadapi kendala dalam pengelolaan data produksi dan distribusi yang belum terintegrasi. Penelitian menggunakan pendekatan Business Process Improvement dengan kombinasi BPMN, USE questionnaire yang bertujuan meningkatkan efisiensi proses bisnis melalui pemetaan proses bisnis awal, perancangan basis data terintegrasi menggunakan Airtable, dan evaluasi keseluruhan dari pengujian basis data dan perbaikan pada BPMN. Penelitian dilakukan Februari 2024-Juli 2025. Data diperoleh melalui observasi, wawancara, dan kuisioner pada tiga pimpinan CV Nawasena Pangan Kreatif. Hasil penelitian menunjukkan bahwa Airtable mampu menyederhanakan proses bisnis, meningkatkan ketertelusuran informasi, dan mengurangi duplikasi data. Hasil perbandingan kuesioner USE menunjukkan peningkatan pada aspek kegunaan, kepuasan, kemudahan penggunaan, dan kemudahan pembelajaran Airtable dibandingkan Google Spreadsheet. Pemanfaatan Airtable sebagai solusi manajemen data terintegrasi membuka peluang bagi UMKM untuk transformasi digital pada proses bisnis secara bertahap.

CV Nawasena Pangan Kreatif faces challenges in managing production and distribution data that are not yet integrated. The research employs a Business Process Improvement approach combined with BPMN and a USE questionnaire, aiming to enhance business process efficiency through initial business process mapping, designing an integrated database using Airtable, and a comprehensive evaluation of database testing and improvement napato the BPMN. The research was conducted from February 2024 to July 2025. Data was collected through observation, interviews, and questionnaires with three senior managers of CV Nawasena Pangan Kreatif. The results of the study indicate that Airtable can simplify business processes, improve information traceability, and reduce data duplication. The results of the USE questionnaire comparison show improvements in the aspects of usability, satisfaction, ease of use, and ease of learning Airtable compared to Google Spreadsheet. The use of Airtable as an integrated data management solution opens up opportunities for MSMEs to gradually transform their business processes digitally.