<![CDATA[Dapoer Mba Nina is a culinary micro, small, and medium-sized enterprise (MSME) that still relies on manual transaction recording using a cash book, which creates risks of recording errors, difficulties in monitoring sales trends, and challenges in making data-driven business decisions. This study aims to design and develop a web-based transaction system using Google Apps Script integrated with a Business Intelligence dashboard based on Chart.js to analyze sales trends at Dapoer Mba Nina. The study employed an applied research approach using the Waterfall system development model, which consists of requirements analysis, system design, implementation, testing, and evaluation. The developed system uses Google Apps Script for data processing and the web application, Google Sheets as a cloud-based data storage medium, and Chart.js for visualizing sales data on the dashboard. System testing was conducted using Black Box Testing to validate system functionality and User Acceptance Testing (UAT) to assess user acceptance and the suitability of the system for operational needs. The implementation results show that the system can automate sales transaction recording, generate daily, weekly, and monthly sales reports, and display sales trends and best-selling products through an interactive dashboard. The Black Box Testing results show that all tested scenarios operated as designed, while User Acceptance Testing achieved a score of 96%, categorized as very good. The developed system can help improve transaction data management efficiency and support data-driven business decision-making at Dapoer Mba Nina.]]>
Copyrights © 2026
