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

Anastasia Lidya  Maukar; Rayvaldi Hendra  Wardhana

doi:10.25139/inform.v11i1.11044

Anastasia Lidya Maukar Industrial Engineering Department, President University, Bekasi
Rayvaldi Hendra Wardhana Industrial Engineering Department, President University, Bekasi

https://doi.org/10.25139/inform.v11i1.11044

Abstract views: 268 ,

PDF downloads: 135

Keywords: Business Intelligence, Power BI, OEE, Centralized Database, Data-Driven Decision Making, Visualization Methodology

Abstract

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.

References

S. P. Sethi, E. A. Veral, H. J. Shapiro, and O. Emelianova, “Mattel, Inc.: Global Manufacturing Principles (GMP) – A Life-Cycle Analysis of a Company-Based Code of Conduct in the Toy Industry,” Journal of Business Ethics, vol. 99, no. 4, pp. 483–517, Apr. 2011, doi: 10.1007/s10551-010-0673-0.

A. U. Umana et al., “Data-Driven Project Monitoring: Leveraging Dashboards and KPIs to Track Performance in Technology Implementation Projects,” Journal of Frontiers in Multidisciplinary Research, vol. 3, no. 2, pp. 35–48, 2022, doi: 10.54660/.IJFMR.2022.3.2.35-48.

A. Sorour and A. S. Atkins, “Big data challenge for monitoring quality in higher education institutions using business intelligence dashboards,” Journal of Electronic Science and Technology, vol. 22, no. 1, p. 100233, Mar. 2024, doi: 10.1016/j.jnlest.2024.100233.

K. Das Malakar, S. Roy, and M. Kumar, “Database Management System: Foundations and Practices,” 2025, pp. 191–255. doi: 10.1007/978-3-031-92017-2_7.

S. M. Kumar and M. Belwal, “Performance dashboard: Cutting-edge business intelligence and data visualization,” in 2017 International Conference On Smart Technologies For Smart Nation (SmartTechCon), IEEE, Aug. 2017, pp. 1201–1207. doi: 10.1109/SmartTechCon.2017.8358558.

M. Attobrah, “ETL Pipeline,” in Essential Data Analytics, Data Science, and AI, Berkeley, CA: Apress, 2024, pp. 27–46. doi: 10.1007/979-8-8688-1070-1_3.

R. Bhimanpallewar, D. Jagtap, V. Raut, and P. Tonge, “OEE Dashboard using Data Analytics,” in 2024 4th Asian Conference on Innovation in Technology (ASIANCON), IEEE, Aug. 2024, pp. 1–6. doi: 10.1109/ASIANCON62057.2024.10838144.

L. J. Basile, N. Carbonara, R. Pellegrino, and U. Panniello, “Business intelligence in the healthcare industry: The utilization of a data-driven approach to support clinical decision making,” Technovation, vol. 120, p. 102482, Feb. 2023, doi: 10.1016/j.technovation.2022.102482.

J. Wang, A. H. Omar, F. M. Alotaibi, Y. I. Daradkeh, and S. A. Althubiti, “Business intelligence ability to enhance organizational performance and performance evaluation capabilities by improving data mining systems for competitive advantage,” Inf Process Manag, vol. 59, no. 6, p. 103075, Nov. 2022, doi: 10.1016/j.ipm.2022.103075.

A. Walha, F. Ghozzi, and F. Gargouri, “Data integration from traditional to big data: main features and comparisons of ETL approaches,” J Supercomput, vol. 80, no. 19, pp. 26687–26725, Dec. 2024, doi: 10.1007/s11227-024-06413-1.

R. I. Esmaeel, N. Zakuan, N. M. Jamal, and H. Taherdoost, “Understanding of business performance from the perspective of manufacturing strategies: fit manufacturing and overall equipment effectiveness,” Procedia Manuf, vol. 22, pp. 998–1006, 2018, doi: 10.1016/j.promfg.2018.03.142.

Z. Allahkarami and A. Skoogh, “Environmental Impacts of Production Disturbances in Manufacturing from an OEE Perspective,” Procedia CIRP, vol. 134, pp. 331–336, 2025, doi: 10.1016/j.procir.2025.03.039.

S. Singh and D. Singh, “Effect of Overall Equipment Effectiveness on Performance of Indian Sugar Industry: A Case Study,” Journal of The Institution of Engineers (India): Series C, vol. 106, no. 5, pp. 1675–1686, Oct. 2025, doi: 10.1007/s40032-025-01253-1.

T. Ylipää, A. Skoogh, J. Bokrantz, and M. Gopalakrishnan, “Identification of maintenance improvement potential using OEE assessment,” International Journal of Productivity and Performance Management, vol. 66, no. 1, pp. 126–143, Jan. 2017, doi: 10.1108/IJPPM-01-2016-0028.

O. T. Al Meanazel, A. Almotari, M. M. Dabobash, S. S. Al-Nashash, and H. A. Al-Buhaisi, “Developing a Model for Integrating Market Metrics with Overall Equipment Efficiency,” Journal of The Institution of Engineers (India): Series C, Nov. 2025, doi: 10.1007/s40032-025-01285-7.

N. T. Huong, L. D. Dao, and L. D. Hanh, “Achieving operational excellence: quality improvement in the automation assembly industry,” The International Journal of Advanced Manufacturing Technology, vol. 140, no. 11–12, pp. 6711–6728, Oct. 2025, doi: 10.1007/s00170-025-16612-6.

R. K. Singh, E. J. Clements, and V. Sonwaney, “Measurement of overall equipment effectiveness to improve operational efficiency,” International Journal of Process Management and Benchmarking, vol. 8, no. 2, p. 246, 2018, doi: 10.1504/IJPMB.2018.090798.

P. Muchiri and L. Pintelon, “Performance measurement using overall equipment effectiveness (OEE): literature review and practical application discussion,” Int J Prod Res, vol. 46, no. 13, pp. 3517–3535, Jul. 2008, doi: 10.1080/00207540601142645.

M. Staron, W. Meding, K. Niesel, and A. Abran, “A Key Performance Indicator Quality Model and Its Industrial Evaluation,” in 2016 Joint Conference of the International Workshop on Software Measurement and the International Conference on Software Process and Product Measurement (IWSM-MENSURA), IEEE, Oct. 2016, pp. 170–179. doi: 10.1109/IWSM-Mensura.2016.033.

S. H. Steiner and R. Jock MacKay, “Effective Monitoring of Processes with Parts Per Million Defective. A Hard Problem!,” in Frontiers in Statistical Quality Control 7, Heidelberg: Physica-Verlag HD, 2004, pp. 140–149. doi: 10.1007/978-3-7908-2674-6_10.

C. K. Sivashankari and R. Valarmathi, “Optimal pricing and production lot-size policies in imperfect production system with price-sensitive demand, reworking, scrap, and sales return,” Operational Research, vol. 23, no. 3, p. 43, Sep. 2023, doi: 10.1007/s12351-023-00779-5.

J. C. Nwokeji and R. Matovu, “A Systematic Literature Review on Big Data Extraction, Transformation and Loading (ETL),” 2021, pp. 308–324. doi: 10.1007/978-3-030-80126-7_24.

X. Li, Y. Dong, and Z. Ai, “Path to intelligent evaluation: Utilizing power BI for enhanced performance insights,” Computers and Education Open, vol. 9, p. 100271, Dec. 2025, doi: 10.1016/j.caeo.2025.100271.

A. Villar, M. T. Zarrabeitia, P. Fdez-Arroyabe, and A. Santurtún, “Integrating and analyzing medical and environmental data using ETL and Business Intelligence tools,” Int J Biometeorol, vol. 62, no. 6, pp. 1085–1095, Jun. 2018, doi: 10.1007/s00484-018-1511-9.

M. Miskuf and I. Zolotova, “Application of business intelligence solutions on manufacturing data,” in 2015 IEEE 13th International Symposium on Applied Machine Intelligence and Informatics (SAMI), IEEE, Jan. 2015, pp. 193–197. doi: 10.1109/SAMI.2015.7061874.

M. Hamzehi and S. Hosseini, “Business intelligence using machine learning algorithms,” Multimed Tools Appl, vol. 81, no. 23, pp. 33233–33251, Sep. 2022, doi: 10.1007/s11042-022-13132-3.

N. A. H. M. Rodzi, M. S. Othman, and L. M. Yusuf, “Significance of data integration and ETL in business intelligence framework for higher education,” in 2015 International Conference on Science in Information Technology (ICSITech), IEEE, Oct. 2015, pp. 181–186. doi: 10.1109/ICSITech.2015.7407800.

H. Lasi, “Industrial Intelligence - A Business Intelligence-based Approach to Enhance Manufacturing Engineering in Industrial Companies,” Procedia CIRP, vol. 12, pp. 384–389, 2013, doi: 10.1016/j.procir.2013.09.066.

S. Bussa, “Enhancing BI Tools for Improved Data Visualization and Insights,” International Journal of Computer Science and Mobile Computing, vol. 12, no. 2, pp. 70–92, Feb. 2023, doi: 10.47760/ijcsmc.2023.v12i02.005.

Z. Zhou, Q. Zhi, S. Morisaki, and S. Yamamoto, “A Systematic Literature Review on Enterprise Architecture Visualization Methodologies,” IEEE Access, vol. 8, pp. 96404–96427, 2020, doi: 10.1109/ACCESS.2020.2995850.

B. Bach et al., “Dashboard Design Patterns,” IEEE Trans Vis Comput Graph, pp. 1–11, 2022, doi: 10.1109/TVCG.2022.3209448.