Home page / Cases / Supply chain dashboard
Supply chain dashboard
The client needed to optimize the work of employees by building a data source integration and reporting system to use at different management levels. Ultimately, we developed a system that unifies relevant data from all sources and stores them in a structured form, which saves more than 900 hours of manual work monthly.
900h+
manual work reduced
100+
system integrations
About the client
A British-Dutch transnational company focused on production of FMCG, products of which are represented in about 190 countries around the world. The company owns more than 400 brands. The turnover in 2017 is more than €50 bln.
Tech stack
React
Python
Django
Pandas
PostgreSQL
AWS
Challenges & solutions
Challenge
Our main goal was to optimize the work of employees by building a data sources integration and a reporting system to use at the different management levels of the Client.
Daily, the Client's reporting department deals with data gained from suppliers, sales and payments info, etc.
Data from more than 100 different sources gained by copying info from contractors' systems comes in the form of Excel sheets, PDF files.
Reporting department consisting of 15 workers processes unstructured data, forming tables and graphs, analyzes information for trends and generates management reports.
Solution
Created a system that unifies data from all sources connected with supply of goods and stores them in a structured form.Developed a system that controls data integrity and identifies anomalies.
Developed a web portal with the possibility of multi-level filtering and dynamic display of data which consists of:
• Consolidated dashboard for management.
• Detailed support of the goods supply.
• Blocks for monitoring the implementation of planned indicators and prompt notification of deviations.
• Individual access for different groups of employees.
Reduced more than 900 hours of manual work monthly. Instance reports for management.
Their technical knowledge and skills offer great advantages. The entire team has been extremely professional.
Steps of providing web applications services
Ecommerce scraping
The dropshipping company needed a way to automatically monitor prices and stock availability for over 100,000 products from over 1,500 stores. We created a system using custom scripts and a web interface that could check 60 million pages daily. This led to a reduction in manual work and errors, and improvements in customer experience and a $50-70k increase in monthly profits.
They always find cutting-edge solutions, and they help bring our ideas to life.
Demand forecasting
We built a sales forecasting system and optimized the volume of goods in the warehouse and the range of goods in different locations, considering each outlet's specifics. We set up a system that has processed more than 8 TB of sales data. These have helped the retail business increase revenue, improve logistics planning, and achieve other business goals.
I think what is really special about the DATAFOREST service is its flexibility, openness, and level of quality and expertise.
They developed solutions that brought value to our business.
Infrastructure Audit & Intelligent Notifications
An eCommerce company had issues with managing its complex IT infrastructure across multiple cloud providers. We helped to analyze the current architecture and develop a strategy for unification, scaling, monitoring, and notifications. As a result, we implemented a single cloud provider, CI/CD process, server unification, security and vulnerability mitigation actions, and improved reaction speed and reliability by 200%.
Not only are they experts in their domains, but they are also provide perfect outcomes.
Latest publications
All publications
We’d love to hear from you
Share the project details – like scope, mockups, or business challenges. We will carefully check and get back to you with the next steps.
