Perancangan dan Implementasi Dashboard Interaktif Menggunakan Microsoft Excel untuk Monitoring Penjualan Produk Fashion

Abstract

In today’s digital era, having a fast, accurate, and easy-to-understand sales monitoring system is crucial especially for small business owners like fashion shop operators. Many still rely on manual recording, which can be time-consuming and prone to errors. This final project presents the design and development of an interactive dashboard using Microsoft Excel, aimed at simplifying the monitoring process of fashion product sales in a more practical and efficient way. The dashboard is designed to be user-friendly, even for those with limited technical skills. Users only need to input their sales data into a ready-to-use form, and the system will automatically process it into reports and visual charts. Key features include an automated input form, a data-saving button, and interactive visualizations such as bar charts, pie charts, and financial summaries showing income, expenses, capital, and profit. The development process involves the use of VBA (Visual Basic for Applications) to automate workflows, as well as dynamic filters that allow users to view data by month or by product type. The system was tested using simulated fashion sales data, and the results showed that it could deliver faster and clearer insights compared to manual methods. Conclusion: this dashboard offers a practical solution for small fashion business owners to better understand their business performance. It not only simplifies the recording process but also helps users make smarter decisions based on well-structured, up-to-date data.