Enhancing Decision-Making Through Bi Automation

Every second, large volumes of data are generated which, if not properly interpreted, can lead to wrong decisions and undesirable consequences. Automating and optimising information processing enables faster handling and supports timely, informed decision-making. With the evolution of Business Intelligence tools, adopting data-driven solutions is essential for organisational competitiveness. This work tackles real-time management and analysis of strategic and operational industrial data through the design and development of the Unified Performance Metrics dashboard, which consolidates strategic information of internal business units via key metrics, and the improvement of the existing human resources dashboard. The system integrates a Power BI front-end with a Python- and SQL-based back-end for automation and the extract, transform and load process. The dashboards were successfully evaluated, approved, and deployed. By automating strategic and operational analyses, the dashboards effectively replaced inefficient manual error-prone procedures, demonstrating clear operational advantages.