Coping with demand volatility in retail pharmacies with the aid of big data exploration


Data management tools and analytics have provided managers with the opportunity to contemplate inventory performance as an ongoing activity by no longer examining only data agglomerated from ERP systems, but also, considering internet information derived from customers’ online buying behaviour. The realisation of this complex relationship has increased interest in business intelligence through data and text mining of structured, semi-structured and unstructured data, commonly referred to as “big data” to uncover underlying patterns which might explain customer behaviour and improve the response to demand volatility. This paper explores how sales structured data can be used in conjunction with non-structured customer data to improve inventory management either in terms of forecasting or treating some inventory as “top-selling” based on specific customer tendency to acquire more information through the internet. A medical condition is considered - namely pain - by examining 129 weeks of sales data regarding analgesics and information seeking data by customers through Google, online newspapers and YouTube. In order to facilitate our study we consider a VARX model with non-structured data as exogenous to obtain the best estimation and we perform tests against several univariate models in terms of best fit performance and forecasting.

Publication DOI:
Divisions: College of Engineering & Physical Sciences > School of Infrastructure and Sustainable Engineering
Additional Information: © 2017, Elsevier Ltd. All rights reserved.
Uncontrolled Keywords: Big data,Data mining,Demand uncertainty,Forecasting,Retail pharmacy,Time series,Computer Science(all),Modelling and Simulation,Management Science and Operations Research
Publication ISSN: 1873-765X
Last Modified: 15 Apr 2024 07:43
Date Deposited: 17 Oct 2022 13:00
Full Text Link:
Related URLs: https://www.sci ... 2162?via%3Dihub (Publisher URL)
PURE Output Type: Article
Published Date: 2018-10
Published Online Date: 2017-08-30
Accepted Date: 2017-08-13
Authors: Papanagnou, Christos I. (ORCID Profile 0000-0002-5889-4209)
Matthews-Amune, Omeiza

Export / Share Citation


Additional statistics for this record