• Pankaj Jain 30/07/2019 08:33AM

    In Procure to Pay

    What will be the best method to carry spend analysis for a company with 1 Million parts and orders are getting created using free text.

    Answer Follow Share

  • Answers (3)

  • Cristian Martin

    30/07/2019 03:22PM

    You will need some clever formulas, not an impossible task, but you will want to create a list of searchable words by searching the cells for the words they contain, then normalise that list to remove duplicates and codify into categories before you start cleansing nonsense data.
    Alternatively you can pay for someone to do this for you, I would recommend https://www.theclassificationguru.com/

    Vote Report

    3

    Lewis Barnard I agree, use an expert to help with this. I'd second the recommendation of Susan at The Classification Guru.

    02/08/2019 03:43PM

    Susan Walsh Hi Pankaj, I can absolutely help you with this, not fancy formulas needed just good old fashioned elbow grease on the first run, get everything as accurate as possible, then going forward all the parts can be mapped and only new ones will need to be updated.

    02/08/2019 03:50PM

    Susan Walsh While it sounds like a massive task I have developed a method to make this efficient and extremely accurate. Happy to have a chat about this - [email protected]

    02/08/2019 03:51PM

  • Peter Macfarlane

    06/08/2019 01:08PM

    We developed a machine learning tool that automatically cleans and categorises spend data in seconds/minutes (SPAT) to a high degreee of accuracy (rubbish data in - accurate data out). It works off invoice data, various fields, but primarily the free text data. We use MS PowerBI to present the data in an interactive dashboard. We have successfully used this across a range of large organisations

    Vote Report

    0
  • James Ball

    30/07/2019 03:20PM

    Most organisations use free text for POs - to automate this is very complex and hard to maintain an exhaustive list (especially if you alter service/good suppliers regularly). Suggest good master and sub categorisation of POs at point of order. However, this needs resource to periodic review and cleanse as the users will ignorantly or lazily use the incorrect categories. Any cleansing needs to take place in co-operation with Finance to avoid any budgetary misalignments. The way to 'sell' this to the business is that the more in control of spend and trend analysis then greater intelligence, savings and innovation can be identified and delivered with the business benefits far outweighing the resource costs.

    Vote Report

    0

Get involved in the discussion. To answer this question

Join now or Login