I have a list of about 0.5m engineering materials that I need to allocate UNSPSC codes to. Has anyone done this before that could offer some pointers as to the process and challenges.
Kind regards
Karen
0 Votes
2 Comments
Sorted by
Antonio Poggiposted
25 days ago
Admin
Hi Karen,
Just to add on what challenges you'd find in allocating UNSPCSC codes, I'd say you're in the realm of having to deal with data quality issues such as missing values and empty rows, inconsistent naming conventions, duplicate records, mapping complexity, outliers, data integration difficulties, validation of results, and the need for manual intervention, which can be effectively addressed using Omniscope.
Some pointers in terms of Omniscope tools to solve these challanges: employing data cleaning tools like the Validate Data Block to catch inconsistencies, the De-duplicate Block to remove duplicates, the Normalise Case Block for consistent naming, the Search/Replace with regex to normalise and Fill Down Blocks for handling missing data, the Delete Empty Data Block to remove empty rows, anomaly detection features to identify outliers... all while allowing for manual review and correction through integrated data tables and export options for problematic data points, and using reports for visually explore data, review the process and test / assess the results.
Obviously .. Susan knows a lot about this topic
1 Votes
S
Susanposted
26 days ago
Hi Karen, we provide spend data classification services, www.theclassificationguru.com. We've been using Omniscope classic to do this for around 12 years and I've even written a book about it - Between the Spreadsheets. We classify manually, so I say this task might take my team anywhere from 2-4 weeks to do this depending on the quality of the information, but might take longer if you've never done this before.
Firstly, the UNSPSC is awful, what you're looking for might not be named what you think it should be so when you're classifying think about other names that you something might be called. I'd take the approach of keyword searches and using the filters. Think of abbreviations that you might also find in the file that will help you classify things quickly.
Hi
I have a list of about 0.5m engineering materials that I need to allocate UNSPSC codes to. Has anyone done this before that could offer some pointers as to the process and challenges.
Kind regards
Karen
0 Votes
2 Comments
Antonio Poggi posted 25 days ago Admin
Hi Karen,
Just to add on what challenges you'd find in allocating UNSPCSC codes, I'd say you're in the realm of having to deal with data quality issues such as missing values and empty rows, inconsistent naming conventions, duplicate records, mapping complexity, outliers, data integration difficulties, validation of results, and the need for manual intervention, which can be effectively addressed using Omniscope.
Some pointers in terms of Omniscope tools to solve these challanges: employing data cleaning tools like the Validate Data Block to catch inconsistencies, the De-duplicate Block to remove duplicates, the Normalise Case Block for consistent naming, the Search/Replace with regex to normalise and Fill Down Blocks for handling missing data, the Delete Empty Data Block to remove empty rows, anomaly detection features to identify outliers... all while allowing for manual review and correction through integrated data tables and export options for problematic data points, and using reports for visually explore data, review the process and test / assess the results.
Obviously .. Susan knows a lot about this topic
1 Votes
Susan posted 26 days ago
Hi Karen, we provide spend data classification services, www.theclassificationguru.com. We've been using Omniscope classic to do this for around 12 years and I've even written a book about it - Between the Spreadsheets. We classify manually, so I say this task might take my team anywhere from 2-4 weeks to do this depending on the quality of the information, but might take longer if you've never done this before.
Firstly, the UNSPSC is awful, what you're looking for might not be named what you think it should be so when you're classifying think about other names that you something might be called. I'd take the approach of keyword searches and using the filters. Think of abbreviations that you might also find in the file that will help you classify things quickly.
I have a video on how we classify data in Omniscope from a few years ago that might be helpful https://youtu.be/GqwxZf89Wy4?si=Zy5XmGezFPWNRmBW
Always happy to have a chat if you need anything else, [email protected]
0 Votes
Login or Sign up to post a comment