Proposal and Development of a BI Solution to Improve Supply Chain Performance

Abstract

This study describes the design and implementation of a business intelligence (BI) solution for Merinal's pharmaceutical supply chain, specifically targeting the scheduling and stock management departments. The aim is to enhance transparency and decision-making within the scheduling and stock management processes. The development of this solution comprised several key stages: data collection from, data warehousing for centralized storage, data transformation and data visualization. The objective is to create an efficient dashboard for the Scheduling and Stock management departments within Merinal's pharmaceuticals to help decision-makers get useful insights and optimize the overall performance of their supply chain.