Design and Evaluation of an Integrated BI Solution with Centralized Data Architecture

This study develops an integrated Business Intelligence (BI) dashboard to address inefficiencies in monitoring key performance indicators (KPIs) at a toy manufacturing company. The previous system required monitoring 48 separate dashboards, used over 25 data sources, and suffered from inconsistent formats that caused frequent errors and delayed reporting. Using a visualization methodology, KPI data for OEE, Quality Performance, and Scrap were standardized and integrated into a centralized SQL Server database via an automated ETL pipeline. The resulting Power BI dashboard improved operational performance by reducing monitoring time from 107.1 minutes by three workers to 78.7 minutes by one staff member (26% reduction), decreasing data inconsistencies by eliminating redundant fields, and enabling near real-time monitoring. These improvements strengthened decision-making accuracy and provided a scalable blueprint for continuous improvement.