Optimizing Supply Chain Performance with Dashboard Solution

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.

Retail

Supply-chain automation

Web Applications

Retail

Supply-chain automation

Web Applications

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

ReactJS

Django

Pandas

PostqreSQL

AWS

The client's needs

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.

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.

Challenge

Data from more than 100 different sources gained by copying info from contractors' systems comes in the form of Excel sheets, PDF files.

Solution

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.

Challenge

Reporting department consisting of 15 workers processes unstructured data, forming tables and graphs, analyzes information for trends and generates management reports.

Solution

Reduced more than 900 hours of manual work monthly. Instance reports for management.

Challenge

Solution

Challenge

Solution

Challenge

Solution

Challenge

Solution

Challenge

Solution

Results

Supply chain dashboard first slider image

Supply chain dashboard second slider image

Supply chain dashboard third slider image

Supply chain dashboard fourth slider image

Their technical knowledge and skills offer great advantages. The entire team has been extremely professional.

Michelle Nguyen

Senior Supply Chain Transformation Manager Unilever, World’s Largest Consumer Goods Company

Steps of providing
data scraping services

Step 1 of 5

Free consultation

It's a good time to get info about each other, share values and discuss your project in detail. We will advise you on a solution and try to help to understand if we are a perfect match for you.

Step 2 of 5

Discovering and feasibility analysis

One of our core values is flexibility, hence we work with either one page high level requirements or with a full pack of tech docs. At this stage, we need to ensure that we understand the full scope of the project. Receive from you or perform a set of interviews and prepare the following documents: list of features with detailed description and acceptance criteria; list of fields that need to be scraped, solution architecture. Ultimately we make a project plan which we strictly follow. We are a result-oriented company, and that is one of our core values as well.

Step 3 of 5

Solution development

At this stage, we develop the scraping engine core logic. We run multiple tests to ensure that the solution is working properly. We map the fields and run the scraping. While scraping, we keep the full raw data so the final model can be enlarged easily. Ultimately we store data in any database and run quality assurance tests.

Step 4 of 5

Data delivery

After quality assurance tests are completed, we deliver data and solutions to the client. Though we have over 15 years of expertise in data engineering, we expect client’s participation in the project. While developing and crawling data, we provide midterm results so you can always see where we are and provide us with feedback. By the way, a high-level of communication is also our core value.

Step 5 of 5

Support and continuous improvement

We understand how crucial the solutions that we code for our clients are! Our goal is to build long-term relations, so we provide guarantees and support agreements. What is more, we are always happy to assist with further developments and statistics show that for us, 97% of our clients return to us with new projects.

How we provide data integration solutions

Step 1 of 5

Free consultation

It's a good time to get info about each other, share values and discuss your project in detail. We will advise you on a solution and try to help to understand if we are a perfect match for you.

Step 2 of 5

Discovering and feasibility analysis

One of our core values is flexibility, hence we work with either one page high level requirements or with a full pack of tech docs.

At this stage, we need to ensure that we understand the full scope of the project. We receive from you or perform a set of interviews and prepare the following documents: integration pipeline (which data we should get and where to upload), process logic (how system should work); use cases and acceptance criteria; solution architecture. Ultimately we make a project plan which we strictly follow.

Step 3 of 5

Solution development

At this stage, we build ETL pipelines and necessary APIs to automate the process. We attract our DevOps team to build the most efficient and scalable solution. Ending up with unit tests and quality assurance tests to ensure that the solution is working properly. Focus on Results is one of our core values as well.

Step 4 of 5

Solution delivery

After quality assurance tests are completed, we deliver solutions to the client. Though we have over 15 years of expertise in data engineering, we are expecting client’s participation in the project. While developing the integration system, we provide midterm results so you can always see where we are and provide us with feedback. By the way, a high-level of communication is also our core value.

Step 5 of 5

Support and continuous improvement

Steps of providing web applications services

Step 1 of 7

Web development discovery

In the initial stage of the web-based development project, professional business analysts make detailed documentation of the project requirements and the approximate structure of the future web application. DATAFOREST is a custom web application development agency, guided by extensive experience in multiple industries. We give you detailed project documentation and then assemble the team according to your time and budget.

Step 2 of 7

UX and UI design

Based on your wishes, the needs of your target audience, and the best web application design and development practices, our UX and UI experts create an aesthetically pleasing and user-friendly interface for your app to satisfy even the most demanding users.

Step 3 of 7

Web-based application development

At DATAFOREST we are following the best programming design principles and approaches. Being a data engineering company, we build high load platforms, with a significant level of flexibility and result orientation. We keep our deadlines and follow SOC 2 compliance requirements.

Step 4 of 7

Integration

With DATAFOREST, integrating the application into your business won’t stop your processes for a minute. We provide seamless integration with your software infrastructure and ensure smooth operation in no time.

Step 5 of 7

Quality assurance

We use a multi-level quality assurance system to avoid any unforeseen issues. Working with DATAFOREST, you can be confident that your web app development service solutions arrive to the market polished and in full compliance with all certification requirements.

Step 6 of 7

24/7 support

Once a product is released to the market, it’s crucial to keep it running smoothly. That’s why our experts provide several models of post-release support to ensure application uptime and stable workflows, increasing user satisfaction.

Step 7 of 7

Web app continuous improvement

Every truly high-quality software product has to constantly evolve to keep up with the times. We understand this, and therefore we provide services for updating and refining our software, as well as introducing new features to meet the growing needs of your business and target audience.

The way we deal with your task and help achieve results

Step 1 of 5

Free consultation

It's a good time to get info about each other, share values and discuss your project in detail. We will advise you on a solution and try to help to understand if we are a perfect match for you.

Step 2 of 5

Discovering and feasibility analysis

One of our core values is flexibility, hence we work with either one page high level requirements or with a full pack of tech docs.

In Data Science, there are numerous models and approaches, so at this stage we perform a set of interviews in order to define project objectives. We elaborate and discuss a set of hypotheses and assumptions. We create solution architecture, a project plan, and a list of insights or features that we have to achieve.

Step 3 of 5

Solution development

The work starts with data gathering, data cleaning and analysis. Feature engineering helps to determine your target variable and build several models for the initial review. Further modeling requires validating results and selecting models for the further development. Ultimately, we interpret the results. Nevertheless, data modeling is about a process that requires lots of back and forth iterations. We are result focused, as it’s one of our core values as well.

Step 4 of 5

Solution delivery

Data Science solutions can be a list of insights or a variety of different models that consume data and return results. Though we have over 15 years of expertise in data engineering, we expect client’s participation in the project. While modeling, we provide midterm results so you can always see where we are and provide us with feedback. By the way, a high-level of communication is also our core value.

Step 5 of 5

Support and continuous improvement

The way we deal with your issue and achieve result

Free consultation

Step 1 of 5

It's a good time to get info about each other, share values and discuss your project in detail. We will advise you on a solution and try to help to understand if we are a perfect match for you.

Step 2 of 5

Discovering and feasibility analysis

One of our core values is flexibility, hence we work with either one page high level requirements or with a full pack of tech docs.

Depending on project objectives, DevOps activity requires auditing the current approach, running metrics measurement, performing monitoring and checking logs. By having a set of interviews, we ensure that we understand the full scope of the project. Ultimately we make a project plan which we strictly follow. We are a result-oriented DevOps service provider company, and that is one of our core values as well.

Step 3 of 5

Solution development

At this stage, our certified DevOps engineers refine the product backlog. We deliver great results within digital transformation, cost optimization, CI/CD setup, containerization, and, last but not least, monitoring and logging. We are a result focused company – it’s one of our core values.

Step 4 of 5

Solution delivery

After quality assurance tests are completed, we deliver solutions to the client. Though we have over 15 years of expertise in data engineering, we expect client’s participation in the project. By the way, a high-level of communication is also our core value.

Step 5 of 5

Support and continuous improvement

Success stories

Check out a few case studies that show why DATAFOREST will meet your business needs.

All Success Stories

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.

88%

forecasting accuracy

0.9%

out-of-stock reduced

Andrew M.

CEO Luxury Goods Retail

View case study

I think what is really special about the DATAFOREST service is its flexibility, openness, and level of quality and expertise.

Stock relocation solution

The client was faced with the challenge of creating an optimal assortment list for more than 2,000 drugstores located in 30 different regions. They turned to us for a solution. We used a mathematical model and AI algorithms that considered location, housing density and proximity to key locations to determine an optimal assortment list for each store. By integrating with POS terminals, we were able to improve sales and help the client to streamline its product offerings.

10%

productivity boost

increase in sales

Mark S.

Partner Pharmacy network

View case study

The team reliably achieves what they promise and does so at a competitive price. Another impressive trait is their ability to prioritize features more critical to the core solution.

E-commerce 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.

1000h+

manual work reduced

60 mln

pages processed daily

Jonathan Lien

CEO Advanced Clear Path, Inc., E-commerce Company

View case study

They always find cutting-edge solutions, and they help bring our ideas to life.

Entity Recognition

The online marketplace for cars wanted to improve search for users by adding full-text and voice search, as well as advanced search with specific options. We built a system application using Machine Learning and NLP methods to process text queries, and the Google Cloud Speech API to process audio queries. This helped greatly improve the user experience by providing a more intuitive and efficient search option for them.

faster service

15%

CX boost