Retail & Consumer Goods
Development of a data warehouse and optimization of inventory management
The Challenge
Our customer from the non-food retail sector commissioned us to build a prototype data warehouse and optimize inventory management using data science analyses. This saves costs by optimizing the distribution of goods and minimizing empty shelves. The aim of this project was to answer the initial question of whether the customer's products were being distributed sensibly across the various stores throughout Germany. The product range of the more than 1,500 stores includes everyday consumer goods. The project was based on the customer's operational data. The particular challenge in this project was, on the one hand, the slowdown or strain on the system caused by analyses and queries and, on the other hand, a database schema that was not yet performing well.
Our solution
We have fulfilled our project assignment as follows:
- Setting up a data warehouse with a data vault model
- Loading the data warehouse from the operational system
- Data science analysis and answering the question posed at the beginning using Python and Jupyter Notebooks: Investigation of empty stocks and factors influencing sales, time series analysis to predict sales, graphical presentation of the results
The result
By setting up a prototype data warehouse as a result of this project, we were able to ensure that further analyses will be possible in the future without burdening the operational system. Furthermore, our data science analyses enabled us to identify factors that influence sales, such as seasonality and geographical correlations, and thus significantly optimize inventory management. As a result, our customer achieved enormous cost savings through the optimal distribution of goods and the minimization of empty stocks.
Discover our digital solutions
You too can benefit from our extensive experience with projects involving companies of all sizes.
HyExpert
Would you like to know how our customized IT solutions can help your business succeed? Do you have questions about specific digital challenges?
Get in touch with us—we’re here to help!