BSH Electrodomésticos

Automatic management of quality certificates for raw materials.

Automatización Certificados de calidad de materia prima

Customer

BSH is a global manufacturer of household appliances, being a national and European leader with more than 40 manufacturing plants around the world, as well as having a significant market share worldwide. Its production focuses on the commercial brands Bosch, Siemens, Balay, Gaggenau and Neff.

Logo BSH Electrodomésticos España

Challenge

BSH needed a solution to integrate the data from the quality certificates issued by its raw material suppliers, as these certificates were stored in PDFs in different factories.

This complicated quick access to these certificates when they needed to be consulted, so a system was proposed that would process, extract and integrate all the data from the PDFs and allow them to be accessed easily and centrally at any time.

Results

  • Agile, fast and integrated access to raw material quality data, avoiding repetitive and costly tasks such as consulting PDFs in the traditional way.
  • Monitoring and analysis of the quality of the raw material received and obtaining conclusions much more quickly and correctly, as well as facilitating the investigation of possible causes of defects in the raw material directly and efficiently.
  • Possibility of labelling the raw material according to its result in the factory.

Solution

The solution consists of:

  • Automatic processing of the Certificates sent by the supplier to our client.
  • Automatic extraction process of the most relevant Data for the Business of each Certificate and storage of the same in a centralised Database.
  • Generation of Excel files with the processed data to facilitate access to the Users involved.
  • Application for visualisation of the stored Certificates with the possibility of categorising them into good or bad according to the performance of the raw material in the manufacturing line.
  • Access control to the application via Microsoft Active Directory based on Internet Information Services.
  • Automatic sending of e-mails to application users with monthly certificate tagging statistics.

The Data used in this Solution are:

  • Data extracted from the Certificates sent by the raw material Suppliers, which are originally in PDF format.

The Technology used for this Solution is based on:

  • R.
  • Shiny
  • Microsoft SQL Server
  • Microsoft Excel
  • Microsoft Active Directory
  • Internet Information Services

Testimonials

César San Julián Sala
Supply Development Manger at BSH Electrodomésticos España.

“Always agile, flexible and responsive with solutions. Since the beginning of the project PredictLand has shown a totally customer-oriented approach. Keep it up!”

Our solutions

Data is the answer

We apply Data Science in business to address current needs and predict future outcomes.

We want to listen to you_


    We inform you that the data you voluntarily provide in this form will be processed by "PredictLand" in order to respond to your request. Your data will not be disclosed to third parties, except when it is essential for the provision of the service or legal obligations. You can exercise your rights of access, rectification, limitation, portability, opposition and deletion of data by emailing info@PredictLand.com. More information at https://www.PredictLand.com).

    “There is only one way to get things done. Just well done”