18/7/2025

 18/7/2025

The focus of my work this morning was to discuss with my supervisor and team the sales volume forecast results I had previously completed using the XGBoost model. During the discussion, I introduced the features used in the model (including historical sales, holiday markers, sales volume changes before price increases, etc.), model structure, and MAPE performance in detail to my supervisor and team.


The supervisor affirmed the overall accuracy of the model, especially compared to the previously used SARIMA model, XGBoost is more stable in handling multiple variables and predicting nonlinear trends. However, the supervisor also made some suggestions for improvement, such as further subdividing the behavioral changes before and after the holidays, and considering the model differences between promotional items and non-promotional items.

评论

发表评论

此博客中的热门博文

21/3/2025

 21/3/2025 Continue to explore and test various sales forecasting methods, including using different time periods for forecasting, to find the most accurate forecasting method. Attend meetings in the afternoon to discuss inventory status during the promotion period with relevant teams (such as managers and executives), focusing on products that have already started or are about to start promotions, especially products that are at risk of being out of stock (OOS), and develop corresponding response strategies to ensure the smooth progress of promotions.
阅读全文

19/3/2025

19/3/2025 Data related to Soh (Stock on hand), Sales (Sales data) and Warehouse Stock (Warehouse Stock) from January 2, 2025 to March 19, 2025 are extracted from Qlik Sense, and the data integrity is checked and initially cleaned. Subsequently, the stock level and warehouse stock allocation are analyzed by building visualization charts such as line charts and bar charts. Finally, the analysis results are discussed and corrected with the Supply Chain Forecast and Promotion Executive.
阅读全文