Optimized Demand Forecasting by Cross-Validation

  • Răzvan Daniel ZOTA The Bucharest University of Economic Studies, Bucharest, Romania
  • Yasser AL HADAD The Bucharest University of Economic Studies, Bucharest, Romania
Keywords: Demand forecasting, BI (Business intelligence), SAS (SQL analysis services), cross-validation, data analysis


Sales forecasting plays an important role in business strategy. An appropriate demand forecasting model is necessary for reducing the cost of storage. At a company level, lowering the warehouse costs and optimizing the value chain is a prominent requirement for an optimum stock management. In this paper a demand forecasting model is built to support the stock management activity of medium enterprises by means of data mining algorithms. SQL server analysis service is used for implementing the demand forecasting model. The paper studies a list of available algorithms that are offered by SQL server analysis service and the performance of the aforementioned algorithms is tested using the cross-validation feature that is provided by SQL server analysis service to optimize the performance of the model. We also aim to explore in our research the ability of RMSE (Root mean Squared Error) to include time series algorithms in the cross-validation phase. The proposed model is tested based on a dataset of a timber export company and the output is used for analysing the performance of the proposed model. The paper reached a group of conclusion and one of most the importance conclusion is neural network algorithms performance was the better in adapting our tested dataset comparing with the other algorithms.



[1] Claudimar P. D., Cassia R. P., Anderson C., Ubirata T., & Wesley V. D. Demand forecasting in food retail: a comparison between the Holt-Winters and ARIMA models. WSEAS TRANSACTIONS on BUSINESS and ECONOMICS. 2014 (11). pp. 608-614
[2] Meek C., Chickering D. M., & Heckerman D. Autoregressive tree modes for time-series analysis. SIAM International Conference on Data Mining. 2002. (2). pp. 229-244
[3] Kochak A., & Sharma S. Demand forecasting using neural network for supply chain managemnt. IJMERR. 2015 Jan, 4(1). pp. 96-104
[4] Dobrican, O. Forecasting Demand for Automotive Aftermarket Inventories. Informatica Economică. 2013. 17(2). pp. 119-129
[5] Stepanov O. A, & Amosov O. S. The Comparison of the Monte-Carlo method and neural networks algorithms in nonlinear estimation problems. IFAC Proceedings. 2007. 9(1) pp. 392-397
[6] Pang-Ning T., Michael S., & Kumar V. Chapter 4: Classification: Basic Concepts, Decision Trees, and Model Evaluation. Introduction to Data Mining. Boston, MA, USA: Addison-Wesley Longman Publishing Co. 2005. p. 157
[7] ***, SQL Server 2012 Tutorials: Analysis Services - Data Mining [Internet]. SQL Server 2012 Books Online. 2012. (cited 2017 Jun 05). P. 55
[8] Buongiorno J. Global modelling to predict timber production and prices:the GFPM approach.. Forestry. 2014 Dec 4, 88. pp. 291–303. Available from: https://doi.org/10.1093/forestry/cpu047
How to Cite
ZOTA, R. D., & AL HADAD, Y. (2018). Optimized Demand Forecasting by Cross-Validation. LUMEN Proceedings, 3, 563-574. https://doi.org/10.18662/lumproc.nashs2017.50