Analytics Solution for Managing At-Risk Stock

This case study outlines the collaboration between GlaxoSmithKline and Thorogood to develop an analytics solution aimed at managing at-risk stock within the pharmaceutical supply chain. The document details the challenges faced by GlaxoSmithKline, particularly the financial losses incurred from expired inventory, and the need for a more proactive approach to inventory management. The solution involved the creation of a Power BI platform that automates data flow and provides real-time insights into inventory levels across various markets. The case study explains the iterative development process used to design a user-focused dashboard, allowing users to monitor stock levels, identify products at expiration risk, and conduct root cause analyses. Additionally, it highlights the innovative features that facilitate collaboration among users and the potential for future enhancements, including the integration of Machine Learning models to improve predictions of stock risks. The overall impact of the solution on GlaxoSmithKline's operations is also discussed.