To address these challenges, MadeinWeb developed a forecasting solution based on machine learning, leveraging historical sales data for advanced modeling and high-accuracy demand projections.
The solution generates monthly forecasts with a 2-month horizon for a portfolio of 1,843 items.
The ingestion and preparation of historical sales data was automated with AWS Glue, with governed datasets stored in Amazon S3 and analytical queries via Amazon Athena.
The ML pipeline is orchestrated by Amazon SageMaker Pipelines, with features managed in Amazon SageMaker Feature Store to ensure consistency between training and inference.
The final production model is an XGBoost, selected from 90 tested configurations — including linear, autoregressive and neural network models.
Training runs via Amazon SageMaker Training, with versioning in the SageMaker Model Registry and recurring batch inference via SageMaker Batch Transform, scheduled by Amazon EventBridge.
Predictive quality and drift monitoring uses Amazon SageMaker Model Monitor with alerts via Amazon CloudWatch.
The main steps of the project included:
Data mapping and ingestion: collection and automation of relevant information sources.
Predictive model development: 100+ variables created and 90 models tested and validated.
Interactive dashboards: creation of panels to visualize metrics and monitor performance.
Continuous optimization: adjustments and improvements to maximize forecasting accuracy and efficiency.