T The advancement of information technology has encouraged companies to utilize data as a foundation for more effective decision-making. at one of the mixue ice cream & tea outlets, product sales and raw material purchase data are still managed separately, resulting in an inefficient data analysis process. therefore, this study aims to develop a business intelligence dashboard capable of integrating both types of data to provide faster, more accurate information and support the decision-making process. this study employs a business intelligence approach consisting of the extract, transform, load (etl) process, data warehouse design using the kimball nine-step method, and dashboard development with microsoft power bi. the dataset consists of product sales and raw material purchase transactions collected during the 2022–2024 period. after completing the etl process, the data were organized into fact tables and dimension tables as the basis for data visualization.the results show that the developed dashboard is capable of presenting key information, including total sales, total raw material purchases, sales trends, purchase trends, best-selling products, raw material purchases, suppliers, and payment methods through interactive visualizations. in addition, the dashboard provides filtering features based on year, month, category, and supplier, enabling users to analyze data more efficiently according to their needs. the dashboard was evaluated by five respondents using twelve statements based on a five-point likert scale. the evaluation achieved a total score of 260 out of a maximum score of 300 (86.67%), which falls into the very good category. these findings indicate that the dashboard was well accepted by users and effectively supports the analysis of product sales and raw material purchases.