Case · Master data cleansing · International mining company

75,000 catalogue records cleansed for an international mining company

An international mining company with assets in several countries ran one central catalogue of 75,000 records. Missing information on existing items and inconsistent processes for new ones led to duplicates, higher stock and extra purchases.

  • Mining
  • Assets in several countries
  • 2018
  • 75,000 records
  • 50,000records brought to the approved standard
  • 4,000duplicates found
  • 3 minto choose the golden record, instead of about a week by hand
  • −19%catalogue size

The task

Find the duplicates and fill the gaps

The client needed the catalogue brought to one standard, duplicates merged without losing the links to stock, requests and orders, and missing data added from reliable sources.

What we did

Cleansing, merging and enrichment

  • Data processed with automation tools and manual review
  • A duplicate merge matrix that takes stock, requests and orders into account
  • Missing information added from manufacturer catalogues and online sources with automation tools
  • Golden record selection automated

Scope

One central catalogue

  • International mining company
  • Assets in several countries
  • One central catalogue
  • 75,000 records

Results

A smaller, cleaner catalogue

  • 50,000 records brought to the approved standard and enriched with missing data

  • 4,000 duplicates found. Golden record selection took 3 minutes instead of about a week of manual work

  • The material catalogue reduced by 19%

Contact

Let's look at your material master

Tell us the size of your catalogue and your systems. We will propose a cleansing plan and the first steps.

  1. 1
    Task and systems

    What you have now and what you need

  2. 2
    Quick assessment

    Data, processes and IT landscape

  3. 3
    Work plan

    Stages, timeline and scope

0
200000
We use your details to respond to your request. See our Privacy Policy.