IDEAS home Printed from https://ideas.repec.org/a/prg/jnlcbr/v2024y2024i5id371p51-69.html
   My bibliography  Save this article

Data Analysis in Demand Forecasting: A Case Study of Poetry Book Sales in the European Area

Author

Listed:
  • Andrea Kolková

Abstract

Logistics concepts are becoming less functional nowadays. The successful concept of just-in-time manufacturing seems untenable for 21st-century Europe. New ideas and new practices are emerging. One of the major trends in contemporary logistics is the demand-driven enterprise. Managing supply, fields and other processes in a company based on demand requires accurate demand forecasting at the relevant time. Relevant data are necessary for this forecasting. In the time of big data, the problem is not collecting data but evaluating them correctly. Data analytics is of great interest in business. The aim of the paper is to verify the possibilities of demand forecasting using traditional statistical methods (exponential smoothing, ARIMA), more advanced statistical methods (TBATS, etc.), methods based on artificial neural networks and a hybrid method. This is in conjunction with thorough data preparation, especially data normality testing. My research question is to provide, on data that contain a number of outliers, the results and the accuracy of the models when the data are or are not normalized. Demand forecasting for poetry books was chosen for the case study. The data were obtained from Google Trends data, i.e., searches for the topic of poetry for the period from 1 September 2013 to 31 September 2023. The results showed that the selected data contain a number of outliers that recur at regular intervals and are the result of a logical order of demand. The expected result was that data normalization increases the accuracy of the model. A method based on artificial neural networks provided significantly more accurate results. However, the resulting estimated underlying trend remained very similar. The article thus opens a discussion about the necessity of excluding outlying observations in time series where outliers exist at regular intervals. Implications for Central European audience: The article poses fundamental scientific questions for Central Europe. Logistics concepts are developing rapidly in this area and Europe is the creator of significant innovations. Europe is currently facing great competition from foreign companies and new logistics concepts are becoming a necessity. Therefore, many European companies now feel the need to change their logistics processes. One of them may be to switch to an adaptive enterprise based on demand. The practical implications are also based on data from Europe.

Suggested Citation

  • Andrea Kolková, 2024. "Data Analysis in Demand Forecasting: A Case Study of Poetry Book Sales in the European Area," Central European Business Review, Prague University of Economics and Business, vol. 2024(5), pages 51-69.
  • Handle: RePEc:prg:jnlcbr:v:2024:y:2024:i:5:id:371:p:51-69
    DOI: 10.18267/j.cebr.371
    as

    Download full text from publisher

    File URL: http://cebr.vse.cz/doi/10.18267/j.cebr.371.html
    Download Restriction: free of charge

    File URL: http://cebr.vse.cz/doi/10.18267/j.cebr.371.pdf
    Download Restriction: free of charge

    File URL: https://libkey.io/10.18267/j.cebr.371?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Peter R. Winters, 1960. "Forecasting Sales by Exponentially Weighted Moving Averages," Management Science, INFORMS, vol. 6(3), pages 324-342, April.
    2. Wu, Cong & Li, Jiaxuan & Liu, Wenjin & He, Yuzhe & Nourmohammadi, Samad, 2023. "Short-term electricity demand forecasting using a hybrid ANFIS–ELM network optimised by an improved parasitism–predation algorithm," Applied Energy, Elsevier, vol. 345(C).
    3. Scott R. Baker & Andrey Fradkin, 2017. "The Impact of Unemployment Insurance on Job Search: Evidence from Google Search Data," The Review of Economics and Statistics, MIT Press, vol. 99(5), pages 756-768, December.
    4. Hyndman, Rob J. & Koehler, Anne B. & Snyder, Ralph D. & Grose, Simone, 2002. "A state space framework for automatic forecasting using exponential smoothing methods," International Journal of Forecasting, Elsevier, vol. 18(3), pages 439-454.
    5. Assimakopoulos, V. & Nikolopoulos, K., 2000. "The theta model: a decomposition approach to forecasting," International Journal of Forecasting, Elsevier, vol. 16(4), pages 521-530.
    6. Sean J. Taylor & Benjamin Letham, 2018. "Forecasting at Scale," The American Statistician, Taylor & Francis Journals, vol. 72(1), pages 37-45, January.
    7. Sivarajah, Uthayasankar & Kamal, Muhammad Mustafa & Irani, Zahir & Weerakkody, Vishanth, 2017. "Critical analysis of Big Data challenges and analytical methods," Journal of Business Research, Elsevier, vol. 70(C), pages 263-286.
    8. Swaminathan, Kritika & Venkitasubramony, Rakesh, 2024. "Demand forecasting for fashion products: A systematic review," International Journal of Forecasting, Elsevier, vol. 40(1), pages 247-267.
    9. Hyndman, Rob J. & Koehler, Anne B., 2006. "Another look at measures of forecast accuracy," International Journal of Forecasting, Elsevier, vol. 22(4), pages 679-688.
    10. Holt, Charles C., 2004. "Author's retrospective on 'Forecasting seasonals and trends by exponentially weighted moving averages'," International Journal of Forecasting, Elsevier, vol. 20(1), pages 11-13.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Meira, Erick & Cyrino Oliveira, Fernando Luiz & de Menezes, Lilian M., 2022. "Forecasting natural gas consumption using Bagging and modified regularization techniques," Energy Economics, Elsevier, vol. 106(C).
    2. Theodosiou, Marina, 2011. "Forecasting monthly and quarterly time series using STL decomposition," International Journal of Forecasting, Elsevier, vol. 27(4), pages 1178-1195, October.
    3. Petropoulos, Fotios & Apiletti, Daniele & Assimakopoulos, Vassilios & Babai, Mohamed Zied & Barrow, Devon K. & Ben Taieb, Souhaib & Bergmeir, Christoph & Bessa, Ricardo J. & Bijak, Jakub & Boylan, Joh, 2022. "Forecasting: theory and practice," International Journal of Forecasting, Elsevier, vol. 38(3), pages 705-871.
      • Fotios Petropoulos & Daniele Apiletti & Vassilios Assimakopoulos & Mohamed Zied Babai & Devon K. Barrow & Souhaib Ben Taieb & Christoph Bergmeir & Ricardo J. Bessa & Jakub Bijak & John E. Boylan & Jet, 2020. "Forecasting: theory and practice," Papers 2012.03854, arXiv.org, revised Jan 2022.
    4. Winita Sulandari & Yudho Yudhanto & Sri Subanti & Crisma Devika Setiawan & Riskhia Hapsari & Paulo Canas Rodrigues, 2023. "Comparing the Simple to Complex Automatic Methods with the Ensemble Approach in Forecasting Electrical Time Series Data," Energies, MDPI, vol. 16(22), pages 1-16, November.
    5. Petropoulos, Fotios & Makridakis, Spyros & Assimakopoulos, Vassilios & Nikolopoulos, Konstantinos, 2014. "‘Horses for Courses’ in demand forecasting," European Journal of Operational Research, Elsevier, vol. 237(1), pages 152-163.
    6. Jan G. De Gooijer & Rob J. Hyndman, 2005. "25 Years of IIF Time Series Forecasting: A Selective Review," Monash Econometrics and Business Statistics Working Papers 12/05, Monash University, Department of Econometrics and Business Statistics.
    7. Trond Husby & Hans Visser, 2021. "Short- to medium-run forecasting of mobility with dynamic linear models," Demographic Research, Max Planck Institute for Demographic Research, Rostock, Germany, vol. 45(28), pages 871-902.
    8. Rajapaksha, Dilini & Bergmeir, Christoph & Hyndman, Rob J., 2023. "LoMEF: A framework to produce local explanations for global model time series forecasts," International Journal of Forecasting, Elsevier, vol. 39(3), pages 1424-1447.
    9. Gardner, Everette Jr., 2006. "Exponential smoothing: The state of the art--Part II," International Journal of Forecasting, Elsevier, vol. 22(4), pages 637-666.
    10. Hess, Alexander & Spinler, Stefan & Winkenbach, Matthias, 2021. "Real-time demand forecasting for an urban delivery platform," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 145(C).
    11. Posch, Konstantin & Truden, Christian & Hungerländer, Philipp & Pilz, Jürgen, 2022. "A Bayesian approach for predicting food and beverage sales in staff canteens and restaurants," International Journal of Forecasting, Elsevier, vol. 38(1), pages 321-338.
    12. Kourentzes, Nikolaos & Petropoulos, Fotios & Trapero, Juan R., 2014. "Improving forecasting by estimating time series structural components across multiple frequencies," International Journal of Forecasting, Elsevier, vol. 30(2), pages 291-302.
    13. Hyndman, Rob J. & Khandakar, Yeasmin, 2008. "Automatic Time Series Forecasting: The forecast Package for R," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 27(i03).
    14. Kang, Yanfei & Hyndman, Rob J. & Smith-Miles, Kate, 2017. "Visualising forecasting algorithm performance using time series instance spaces," International Journal of Forecasting, Elsevier, vol. 33(2), pages 345-358.
    15. Sprangers, Olivier & Schelter, Sebastian & de Rijke, Maarten, 2023. "Parameter-efficient deep probabilistic forecasting," International Journal of Forecasting, Elsevier, vol. 39(1), pages 332-345.
    16. Athanasopoulos, George & Hyndman, Rob J. & Song, Haiyan & Wu, Doris C., 2011. "The tourism forecasting competition," International Journal of Forecasting, Elsevier, vol. 27(3), pages 822-844.
    17. Andrea Kolková & Petr Rozehnal, 2022. "Hybrid demand forecasting models: pre-pandemic and pandemic use studies," Equilibrium. Quarterly Journal of Economics and Economic Policy, Institute of Economic Research, vol. 17(3), pages 699-725, September.
    18. Kim, Sungil & Kim, Heeyoung, 2016. "A new metric of absolute percentage error for intermittent demand forecasts," International Journal of Forecasting, Elsevier, vol. 32(3), pages 669-679.
    19. Meira, Erick & Cyrino Oliveira, Fernando Luiz & Jeon, Jooyoung, 2021. "Treating and Pruning: New approaches to forecasting model selection and combination using prediction intervals," International Journal of Forecasting, Elsevier, vol. 37(2), pages 547-568.
    20. Theresa Maria Rausch & Tobias Albrecht & Daniel Baier, 2022. "Beyond the beaten paths of forecasting call center arrivals: on the use of dynamic harmonic regression with predictor variables," Journal of Business Economics, Springer, vol. 92(4), pages 675-706, May.

    More about this item

    Keywords

    demand forecasting; demand drive adaptive enterprise; normality test; exponential smoothing; ARIMA; neural networks; hybrid model;
    All these keywords.

    JEL classification:

    • C53 - Mathematical and Quantitative Methods - - Econometric Modeling - - - Forecasting and Prediction Models; Simulation Methods
    • M15 - Business Administration and Business Economics; Marketing; Accounting; Personnel Economics - - Business Administration - - - IT Management
    • M21 - Business Administration and Business Economics; Marketing; Accounting; Personnel Economics - - Business Economics - - - Business Economics

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:prg:jnlcbr:v:2024:y:2024:i:5:id:371:p:51-69. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Stanislav Vojir (email available below). General contact details of provider: https://edirc.repec.org/data/uevsecz.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.