DATA-DRIVEN DECISION MAKING IN MANUFACTURING: LEVERAGING POWER BI AND SQL TO ENHANCE MANUFACTURING OPERATIONS IN ERP SYSTEM

Abstract

The contemporary manufacturing system is described by increasing complexity within the company as it is based on the business model, intense global competition and the critical need for operational agility and resilience which can take the different production schedules and can still maintain the productivity percentage to the full capacity which eventually reduces the overhead rate. Traditional decision-making processes, often relying on intuition and delayed report which makes it difficult to capture the opportunity to recover from the lost revenue opportunity. The adoption of the data driven decision making has become essential, transforming data from a passive record into strategic asset. This paper explores how Microsoft PowerBI and SQL, integrated within and alongside Enterprise Resource Planning (ERP) systems and internal adaptive manufacturing system which eventually helps every employee along with the management to watch what exactly is going on in the manufacturing plant.  ERP systems and adaptive manufacturing system serve as the central repositories for the vast amounts of operational and transactional data, while SQL provides robust capabilities for managing, querying, and transforming this data. PowerBI can be leveraged to develop real time reports and monitoring reports which can be very much helpful in building visualizations and dashboards, in depth-analysis and informed decision making across manufacturing operations. The usage of the different tools can increasingly help in revenue optimization by enhanced visibility, optimized production processes, improved quality control, and more strategic inventory and supply chain management. While challenges related to data quality, integration, technical complexity, scalability, talent gaps, and change management exist, the quantifiable benefits in terms of efficiency gains, cost reduction, and risk mitigation underscore the transformative potential of leveraging Power BI and SQL for data-driven decision making in manufacturing within the ERP context.