Data Aggregation for Data Analytics in Medical Device Supply Chains
Name
scm2020-lamas oporto-data-aggregation-for-data-analytics-in-medical-device-supply-chains-capstone.pdf
Description
Full capstone
Size
1.95 MB
Format
Adobe PDF
Checksum (MD5)
9709480678ee8b005fec40d41b7075a3
Author(s)
Lamas Oporto, Gabriela
Alhalafawy, Sherif
Date Issued
July 30, 2020
Abstract
Product visibility in the medical device supply chain is a challenge for suppliers, distributors, and hospitals. The lack of visibility makes managing inventory complex, and it is made more difficult when businesses have a segregated distribution model. In this model, a surplus of systems collects inventory data at the supply chain nodes, but the data is not integrated due to system barriers. This aspect of ‘big data’ is a current problem multiple supply chains are facing as they look towards future data analytic capabilities. In this capstone, we evaluated the potential of integrating the sponsoring company’s data sets from fragmented planning systems in enabling advanced data analytics and visualization that can improve inventory management. We successfully created a data aggregation tool after cleaning and transforming the data sets and performed data analysis on the aggregated data. SKU segmentation was completed, and their inventory distribution analyzed. Results support using aggregated data sets for data analytics in medical device supply chains. We recommend that the sponsoring company integrate the tool into their business processes and use customer centric data to enhance their inventory management. The medical device industry struggles with product visibility and the lack of connectivity is a barrier, but as companies continue to strive towards aggregated systems for data analytics, these capabilities would lay the framework for better inventory management in their distribution networks.
Subjects
inventory management
healthcare
data analytics
Persistent DSpace Link
