Dashboard design and development for data analysis of products and services utilizing Power BI

Abstract

The design and development of a product and service reporting dashboard aim to create an instrument that enables executives and staff at the National Laboratory Animal Center to analyze product and service data efficiently. The Power BI software was utilized to present historical data spanning five years, thereby allowing users to compare sales trends from past to present and forecast future data. To develop this dashboard to support executive decision-making and improve the efficiency of operators so that information can be used to improve service efficiency for customers. This study involved testing the dashboard by having ten executives and staff members use it while providing instructional materials on its functionality. The main objectives were: 1) to develop a dashboard reporting sales of products and services using the Power BI program and 2) to study the effectiveness of sales and service reporting dashboards using the Power BI program. The tools included the Power BI-based dashboard and a user satisfaction survey, with data analyzed using mean. The results indicated that the ten personnel from the National Laboratory Animal Center expressed the highest level of satisfaction with the dashboard’s usability, with a mean score of 4.70. The overall satisfaction score for the dashboard’s design and functionality was also at the highest level, with a mean of 4.75. In conclusion, the developed dashboard effectively supports executives in analyzing and forecasting data for decision-making.