Managing scattered procurement data can be a daunting task. Find out how to make the right choice between building a custom solution or purchasing software for better results and savings.
Tell Me MoreUpdated: Oct 23, 2024
Every procurement organization needs visibility of their spend. There are many ways to do this. For some, a simple Excel-based desktop exercise suffices, while others might need sophisticated analysis solutions to cater to large enterprises.
Procurement data can be dirty, scattered and require plenty of attention. However, it can be extremely valuable when properly managed. In this article, we will go through how to best use the data in your hands.
Traditionally, purchasing data was seen as a byproduct of buying activities - it had no perceived value.
Today, procurement data has been identified as an important business asset. Yet, relatively few organizations embrace it to gain a competitive advantage.
The information gained from analyzing data is used to guide procurement category strategies, strategic sourcing projects, contract management and optimize the entire source-to-pay cycle. In addition to management insight, with data analysis companies have realized multi-million dollar savings opportunities.
Organizations have come to realize that they need a procurement data strategy - and either make sense of the data themselves or partner up with a supplier that knows how to deal with their data.
Get your comprehensive guide to spend analytics: Spend Analysis 101
Before diving into data, you must define your data strategy based on your specific business challenges.
Start by mapping all relevant data sources, such as:
Creating a clear plan will provide direction on how you collect, cleanse, store, manage and share the information for maximum benefit and profitability. Unstructured and unused data becomes an asset when it is combined, classified, and analyzed.
Given the dynamic nature of procurement, a data strategy is not static and should evolve over time.
Data analysis can be done as a spreadsheet exercise in Excel. Excel is a great tool for building dashboards that can provide analysis and deliver timely insights. While doing spend analysis in Excel is doable, most people will fail to do it efficiently and encounter issues. As your organization grows, so does the complexity of your data, making Excel unscalable.
Even if you’re successful doing all this, it can take hours or even days of work. The same “update and classify” data crunching exercise is repeated each month, which will not be scalable without purpose-built tools for doing so.
According to Deloitte’s CPO Surveys (2020 & 2021), high-performing organizations invest in advanced analytics, predictive capabilities, and AI to maintain a competitive edge. Investing in specialized tools becomes essential as data complexity increases.
Before considering how to build or buy a procurement data solution you need to understand:
The decision of whether to develop an in-house IT solution (build) or source a solution externally (buy) is a never-ending debate. Assuming there is already an appetite at senior level for a solution, there are three main issues to consider:
Since procurement’s top priority is making savings, cost must be high on the agenda. The total cost of a proposed solution over its entire life cycle must be the basis for the calculation. Procurement teams apply Total-Cost-of-Ownership (TCO) principles to all key make-vs-buy projects, this is no different.
Read an in-depth analysis of the TCO of Spend Analytics software
Most buy applications need integration with existing infrastructure and internal systems. When calculating the time expected to complete the entire project, specific time-consuming activities such as customization, changing work processes and retraining staff need to be costed and added.
Building a system internally means an IT team needs to use a platform such as Microsoft Power BI and continue to maintain it. The build cost includes technical training (if required) and direct labor costs but should exclude any fixed costs.
The duration of an in-house built project is often longer due to the pressure of other IT priorities. Time is money and delays are expensive. Should your TCO calculation stand for the “build” option, it makes sense to double-check if all related costs are taken into account and if the quality of in-house development and monthly upkeep is comparable to external solutions.
See below exemplary TCO comparison over a 3-year period.
Overall, the cost of the ”buy” should be less than the ”build”. This is due to vendors being able to utilize economies of scale and specialization, leading to lower unit costs. The attraction is often the offered subscription pricing model avoiding an upfront expense. The key here is to select and pay for only the functionality you need.
How important is having an effective procurement data management system to the success of your business? The answer is very. Without usable historical spend data decision-making on future procurement is guesswork.
System downtime is a risk, can an in-house system or external service provider guarantee that the system will be 99% available? Your stakeholders are likely very eager to make the most out of the vast mass of procurement data they have at hand, which means there is an urgency element involved.
Whether build or buy, the solution selected must meet all your specified criteria and be both secure and legally compliant.
The choice of buy or build must consider how much technical skill and capacity is available internally and how mature the IT function is.
Learn how to collaborate better with IT w/ Full eBook: Procurement <3 Data
In addition to technical skill, specific competence related to the procurement landscape is required to understand how data can be best used as internal customers might face a challenge getting across what they really need and what is possible solution-wise.
Any skills upgrade project takes time and investment. Potential vendors of procurement analytics solutions are likely to have the knowledge and expertise available but are they relevant to your industry or business sector? Check for relevant customer testimonials and market reviews.
Presenting the facts to senior management relating to cost, criticality, and availability of skills are not the only considerations. The political and cultural environment within the organization has an influence.
Organizational maturity in terms of data utilization plays its own part. There are known and unknown biases at play that influence the decision-making process. Prior experiences with a vendor, aggressive marketing by vendors, and end-user preferences all play a part.
Whichever route is chosen the system will require security patches, bugs fixed, and new features added. An in-house build will depend on the development capabilities and capacity of existing IT staff, assuming that they are fully acquainted with market developments in procurement technologies.
The in-house team should understand how to classify and draw conclusions from the procurement data that best serve the end user requirements.
Without that expertise, troubleshooting will have to rely on external community support. It could be said that an internal team has more control over planning changes and upgrades, thereby building confidence with stakeholders.
Vendors have extensive technical analytics expertise and support teams for their products - this is built into the price. A robust service level agreement (SLA) can ensure the quality of implementation, maintenance, and support – this applies equally to both build and buy solutions.
Technology alone will not deliver the results you are looking for. It is a tool that, in the right packaging with the right handling, can provide an easy-to-use-and-maintain system that delivers procurement value.
The solution to the question - Buy or Build - may be a hybrid. There is no definitive answer. Buying a cloud-based software solution that is flexible, agile, and secure that can be integrated into your current platform can make sense on your data roadmap as your organizational maturity increases.
Imperfect data can be valuable for dynamic procurement needs and can be enriched and combined with external data. Working with external partners can provide access to unique data streams and insights.
It does not out-scope the possibility to add in-house developed modules as your needs demand and vary over time.
At the end of the day, only no-value data is data that is not utilized. Your procurement data strategy and chosen solution are as unique as your business.
Photos:
Yulia Matvienko @yuliamatvienko (picture 1)
Esteban Lopez @exxteban (picture 2)
Sources:
https://www2.deloitte.com/us/en/insights/topics/operations/chief-procurement-officer-cpo-survey.html
See what you can do to connect procurement data + AI-powered insights to unlock procurement excellence
See what you can do to connect procurement data + AI-powered insights to unlock procurement excellence
Procurement Loves Data promises a new outlook and fresh perspectives on how IT and procurement, connected by their love of data, can contribute more value to the organization—together. You'll gain practical advice on data-driven leadership based on the authors' decades of experience in procurement analytics.