Optimizing and Integrating Supplier Data Enrichment Data Into Your Spend Intelligence Warehouse

December 28th, 2009 at 09:20am David Bush - Iasta

Many of our customers ask us to handle their Supplier data enrichment data.  This is a natural fit to add and integrate this informative data to all the supplier and Spend data that is collected.  Supplier enrichment data packets build additional analytical and Spend management capabilities into the overall Spend Intelligence warehouse.  However, many organizations do not add this important information such as DUNS/SIC/NAICS/Parent Child, Diversity, and Risk related Supplier information, as it can get quite expensive in a hurry, if the overall process is not managed and optimized to the company’s overall needs.

Adding this data into your Spend Intelligence warehouse should simply be another source file.  We have relationships with all the major companies that provide Supplier Enrichment data, and having done this many times, we have optimized the overall process and related expense to get this information integrated with your Supplier and Spend information.

Optimizing the Supplier Enrichment process is as follows:

  1. Create a Clean Vendor Master – through the Spend data collection process, suppliers are collected from all sites, cleansed, grouped, classified, and rationalized to a consolidated vendor master.  Now the company can break down their suppliers relative to Spend and priorities as to which ones should potentially be enriched.
  2. Mix and Match Supplier Enrichment Data Packets – enrichment data for SIC/NAICS or Parent Child relationships are usually in different data packets than data packets for diversity and risk.  Each data packet has different costs, with risk usually being most expensive.  You can analyze your supplier base to determine which suppliers should get what level of data packet, such as only preferred suppliers, or suppliers with large Spend dollars, have risk-related enrichment.
  3. Process and Integrate Suppliers to/from the Provider – the handshake of providing the actual supplier file to the supplier enrichment provider, getting it back, and integrating it into your Spend warehouse, should be handled easily by your Spend Analysis provider.
  4. Create More Advanced Analytics, Reporting, and Spend Management programs – once the data is received back from the supplier enrichment provider, it must be integrated with all the related Spend data for that supplier.  In addition, the new data can now be added to the overall analytical capability the organization needs to track diversity, compliance, conduct deeper analysis, and better manage overall sourcing programs.

All the above should be done easily (and at low cost) by your Spend Analysis provider, thereby creating significant value to handle this important and more advanced management capability for your organization.

Entry Filed under: General, Spend Analysis

1 Comment Add your own

  • 1. Prashant Mendki  |  January 7th, 2010 at 5:34 am

    A complex process very nicely described with simple steps. As per my experience, its step by step process to execute easy to say than done. E.g when you say parent child linkages it involves cleansing and stadardizing vendor base – which will increase your match rate. Enriching information for address, city, state, country zip. Then trying to match and deduplicate record set – to avoid redundancy and shrink base set. Then trying to seperate employees or individuals – so you avoid wasting time on non vendor records. Once you have clean, deduplicated enriched dataset – you have to have latest vendor information from reliable sources to know who is parent of whom and child of whom. Then diversity identification could be another area in vendor enrichment.

    -Prashant Mendki
    http://manageyourdata.blogspot.com

Leave a Comment

hidden

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Trackback this post  |  Subscribe to the comments via RSS Feed



The e-Sourcing Handbook

The e-Sourcing Handbook is a modern guide to supply and spend management success.

New Supply Chain Agenda: The 5 Steps That Drive Real Value

Turn your supply chain into a competitive weapon that produces unprecedented economic profit for your firm.
RSS   Twitter

Affiliates

Paladin Associates
TPI
Disanto and Associates
eSourcing Wiki
EnglishFrancaisDeutschItalianoEspanolPortugeseJapanese
KoreanChineseArabicRussianFinnishPolishSwedish

Certifications

Next Level Purchasing

CURRENT VIEWERS

2010 SDC Executive Pros To Know

2008 Pros To Know

2009 Pros To Know

2007 Pros To Know

2005 Pros To Know

2009 SDC Executive 100

2008 SDC Executive 100

2007 SDC Executive 100

2006 SDC Executive 100

2005 SDC Executive 100

2004 SDC Executive 100