IMPLEMENTATION OF BUSINESS INTELLIGENCE FOR SALES DATA ANALYSIS AND VISUALIZATION OF MSME’s BUKET_BYATIQ USING MICROSOFT POWER BI

Abstract

This study aims to implement Business Intelligence using Microsoft Power BI at Buket_Byatiq MSME to replace the less effective manual recording system. The research method used is a case study, processing 2024 sales data through the ETL process and developing an interactive dashboard visualization. This study employs the BI Roadmap (framework), a Business Intelligence system that guides the design and data analysis process in creating visualizations. The main stages include collecting historical sales and expense data, followed by processing and designing through data cleaning, transformation, loading, and relational table modeling. The process culminates in the development of an interactive dashboard that presents real-time sales information to support data-driven decision-making. The results of the study show that the implementation of Business Intelligence using Microsoft Power BI effectively supports Buket_Byatiq MSME in making more accurate and efficient business decisions. The developed interactive dashboard successfully presents key information such as revenue, profit, monthly and weekly sales trends, best-selling products, dominant sales platforms, purchasing methods, and ordering regions. This visualization not only simplifies analysis compared to manual record-keeping but also reveals that sales are still influenced by certain seasonal moments, with WhatsApp Business serving as the main sales channel and the market remaining limited to the Tasikmalaya area. With the application of BI, business owners can more easily understand sales patterns, determine production strategies, and design more targeted marketing efforts to enhance competitiveness in the digital era and achieve desired sales targets.