The challenge
Our client faced a significant challenge with their existing forecasting process. The slow, resource-intensive process lacked the flexibility to easily add long-term forecasts. The prediction of future sales, inventory levels, and customer demand for their products lagged behind, disrupting the retailer's efforts to plan their buying and merchandising strategies. The hoped profit maximization was undermined by overstocking or understocking of products.
The solution
VirtusLab (VL) implemented a new forecasting framework that streamlined the entire process, making it faster and more efficient than ever before. By introducing parallelization with Apache Spark, we enabled our client to take advantage of multiple computers and run the process simultaneously, eliminating the bottleneck caused by using only a single computer.
The framework relied on complex time series analysis and statistical models to predict future trends better. VirtusLab processed several hundred terabytes of historical data, analyzed it, and ran validation tests to ensure accuracy. The framework VL developed includes handling external data sources and factors such as inflation rates that may impact sales forecasts.
The results
Our client experienced several positive outcomes as a result of implementing the new forecasting framework:
- Streamlined Forecasting: the automated forecasting process significantly reduces manual intervention and errors, leading to smoother and faster calculations.
- Faster Forecasting: the forecasting time has been reduced from several days to just an hour, increasing the productivity and efficiency of the team.
- Improved Flexibility: the new framework allows the client to quickly add long-term forecasts and adapt swiftly to changing business requirements.
Enhanced Data Science: data scientists now focus on critical business analysis rather than just performing manual calculations of forecasts.
The tech stack
Languages: Python, Spark
Database: Hive, S3
Infrastructure: On-prem: Yarn and Kubernetes
Cloud: Azure Databricks
CI/CD: Jenkins, Airflow
Modelling: Statistical models
Partner flexibly with VirtusLab
Use one or a combination of engagement models to suit your needs.
Take the first step to a sustained competitive edge for your business
Let's connectVirtusLab's work has met the mark several times over, and their latest project is no exception. The team is efficient, hard-working, and trustworthy. Customers can expect a proactive team that drives results.
VirtusLab's engineers are truly Strapi extensions experts. Their knowledge and expertise in the area of Strapi plugins gave us the opportunity to lift our multi-brand CMS implementation to a different level.
VirtusLab has been an incredible partner since the early development of Scala 3, essential to a mature and stable Scala 3 ecosystem.
VirtusLab's strength is its knowledge of the latest trends and technologies for creating UIs and its ability to design complex applications. The VirtusLab team's in-depth knowledge, understanding, and experience of MIS systems have been invaluable to us in developing our product. The team is professional and delivers on time – we greatly appreciated this efficiency when working with them.
