DESISGN OF BUSINESS INTELLIGENCE SYSTEM FOR MONITORING PROCUREMENT, INVENTORY MANAGEMENT, AND SALES ACTIVITIES IN PT BIO FARMA (PERSERO)

• Main Author: YUANISA NIM 13413055, ZELIANA
• Format: Final Project
• Language: Indonesia
• Online Access: https://digilib.itb.ac.id/gdl/view/31897
• Institution: Institut Teknologi Bandung

PT Bio Farma (Persero) is a State-Owned Enterprise (SOE) that engages in <br /> <br /> pharmaceutical products and medical devices field. As an effort to handle the risk <br /> <br /> of vaccine supply delay, which is one of the company's highest corporate risk, PT <br /> <br /> Bio Farma (Persero) seeks to optimize information technology-based supply <br /> <br /> chain management (SCM). In 2015, PT Bio Farma (Persero) has implemented <br /> <br /> Enterprise Resource Planning (ERP) system, but currently the system is still a <br /> <br /> transaction processing system (TPS) so that the company has not been able to <br /> <br /> perform direct monitoring of SCM activities that will enable the company to <br /> <br /> perform analysis and make decisions quickly, accurately, and effectively. One of <br /> <br /> the impacts that can arise is the emergence of material supply shortages. <br /> <br /> This research is directed to design business intelligence (BI) system as a solution <br /> <br /> to solve the company problem. Outputs that will be obtained through this research <br /> <br /> are: (1) the functional and non-functional requirements of the BI system are <br /> <br /> identified; (2) the design of BI system components (data warehouse, extract <br /> <br /> process, transform, load (ETL), Online Analytical Processing (OLAP) and <br /> <br /> dashboard) are made; and (3) make a prototype of BI system that can assist PT <br /> <br /> Bio Farma (Persero) in monitoring SCM activities, especially in anticipation of <br /> <br /> material supply shortages cases. <br /> <br /> The results of BI system design are then verified, validated, and evaluated. <br /> <br /> Verification and validation results indicate that the BI system design meets the <br /> <br /> functional and non-functional requirements, compatible with software and <br /> <br /> hardware owned by the company, and can be utilized to help solve the problem of <br /> <br /> the company. Meanwhile, based on the results of the advantages and <br /> <br /> disadvantages evaluation, BI system design can be developed to be improved <br /> <br /> according to the needs of company in the future.