The team and key partners in the Information Systems department embarked on a journey to find a digital, global solution to enable one repository of data and one analytics platform, improve business process efficiencies for cost savings, and develop an agile analytics model. Financial and procurement data were siloed in legacy systems, requiring the team to implement interfaces between systems to extract data. Analysis was time-consuming and stuck in spreadsheets, preventing the Global Procurement Data Analytics team from effectively serving stakeholders or structuring data with end user adoption and satisfaction in mind.
To transition to a digital approach, the team focused on asking questions about how procurement and spend data were consumed by stakeholders and how procurement data integrated across global systems. They wanted flexibility in order to provide greater value to the business: the ability to filter data by region, spend categories, measure complexity of payment terms, better manage suppliers, and identify risks that impact net revenue.
Ultimately, the Global Procurement Data Analytics team adopted SAP HANA to host the central data repository and decided on Tableau as their analytics platform to support spend analysis. The procurement organization now have complete spend visibility, integrating data end-to-end for a sustainable analytics model and reducing dependencies and reporting times.
In order to understand with high level of accuracy and effectiveness the use of cash in supplier payments, a global process needed to be put in place to ensure standards were followed. The Weighted Average Payment Terms report was developed allowing a process that used to take eight weeks, now takes only two weeks with Tableau. Across this report, among others, the Global Procurement Data Analytics team has analyzed millions of transactions and seen significant time savings by integrating data and using Tableau. Igor and team have enabled the procurement function to focus on strategy and proactively mitigate risk. With plans in progress to use Tableau dashboards to have full visibility into their supply chain, they will be able to take future action avoid revenue impacts when a supplier is at risk of not having an item like cocoa or wheat, for example, to prevent negative impacts to revenue.
Furthermore, managing payment terms is an area where end-to-end data integration proves its value. Having accurate visibility into spend across 28,000 suppliers allows the team to see which suppliers they're spending more with and adjust payment terms accordingly—to 90 days or 120 days, for example. This visibility also informs how to increase value from existing suppliers or plan for supplier base reduction.
Having more than 100 traditional reports, 20% of which were used, pushed the team to review which reports were most valuable and actionable. By consolidating spend and supplier information, they created 10 simple, yet powerful Tableau dashboards to serve all 475 stakeholders, across all categories and regions globally.
By enabling this digital transformation, Igor and a multifunctional team of 20 members—and growing—can scale and support over 475 Tableau users, with more planned, while maintaining continual collaboration with both internal and external stakeholders. After having launched their digital solution with Tableau, the feedback from stakeholders has been unanimously positive. People love the insightful analysis, saying, "Just show me Tableau," rejecting traditional spreadsheet-based reporting. They ask, "How can we get more?"