Supply Chain Analytics: From Dashboards to Decisions

Editor’s note: This is the first article in a series, “Analytics Transformation Journeys,” authored by data consultants and engineers from IBM’s Procurement Analytics as a Service team. The series follows stories of procurement teams leveraging data and analytics to reposition procurement from a cost-centered function to a strategic driver of enterprise value.

***

Only one in five organizations report that their spend analytics capabilities are highly effective at driving decision-making, the IBM Institute for Business Value found in 2025, while more than 40 percent describe their capabilities as limited or ineffective.

For many, the issue isn’t access to data or scarcity of data, it’s a failure to integrate meaningful analysis into procurement review cycles.

Think about the most critical review moments in your organization — category strategy discussions, sourcing pipeline prioritization, supplier performance reviews, and risk and compliance assessments. These are the moments where insights should drive action, yet too often they remain disconnected from the data itself.

When analytics is fully embedded, it becomes a differentiator between procurement as a transactional function and a driver of enterprise value. If that connection is missing, it may be time to reinvent the review cycle.

The following two case studies examine organizations that have achieved this in different ways, along with the lessons learned you can apply to your own team.

Business Case 1

Transforming Indirect Spend Reviews with Advanced Analytics

The pressure for procurement teams to make quick decisions can compromise optimal, data-driven decision-making. We see it constantly where such pressures as fire-drill culture, tactical bias, high workload and top-down urgency result in a half-baked contract negotiation, unfavorable vendor selection or incomplete vendor performance review.

Does this sound familiar? While time pressures present an inevitable challenge for procurement teams, embedding advanced analytics capabilities is often the best solution to making better decisions faster.

IBM’s Procurement Analytics as a Service (PAaaS) team tackled this very issue when partnering with a major consumer goods company to rethink its quarterly reviews of indirect spend. While the client had developed a relatively high level of data maturity through a partnership with IBM (including cleansed spend cube, advanced analytics visualizations and targeted category insights), gauging performance across major categories and metrics continued to be an untapped opportunity.

This led IBM to develop a cross-category dashboard to address these gaps. The dashboard featured a breakdown of key metrics jointly developed by the client and IBM, with automated calculations embedded to track these metrics along with the top suppliers, geographies and plants by spend contributing to these trends quarter over quarter and year over year.

As a result, category managers gained immediate visibility into a prioritized set of risks and opportunities within their categories, eliminating time previously spent on manual analysis and enabling greater focus on targeted sourcing initiatives.

By embedding these metrics into regular leadership reviews, executives were better able to track the impact of recent initiatives. For example, a consolidation of multiple communications agencies into a single strategic partner would be highlighted through visibility into the top increasing and decreasing suppliers by spend.

Similarly, leadership could more effectively identify future sourcing opportunities. For instance, a highly fragmented tail spend profile in a category like manufacturing relative to other categories would signal a clear opportunity for sourcing intervention.

Lessons Learned

Establish a baseline for top KPIs to allow for continuous improvement. Identify five to 10 of the most business-critical KPIs to track for indirect as a whole and for each top-level category (like marketing or IT). Leveraging KPI summary views in your business intelligence (BI) tool and refreshing on a regular cadence provides a simple way to track performance over time.

If you’re unsure where to start, the following KPIs provide a strong foundation: (1) percentage of spend on PO, or on contract, (2) percentage of spend with strategic suppliers, (3) count of per million dollars of spend, (4) count of new suppliers and (5) count of distinct invoices.

Embedding automation within reporting streamlines decision-making. Reduce manual effort and minimize human error by automating dashboard calculations, reports and refreshes used in quarterly spend reviews. This simplifies the review process immensely and frees up time for higher-value activities.

AI-driven tools like large language models, when properly governed and validated, can accelerate automation efforts — particularly in environments with skill or capacity gaps.

Prioritize visibility into drivers, not just outcomes, to identify root causes. Integrate key supporting data (geographies, companies, contract details and the like) into dashboard visualizations to tie KPI movement to specific root causes.

For example, if spend increased by 5 percent for the manufacturing category but remained steady in previous quarters, this may seem like a regression in isolation. However, a well-designed dashboard might reveal that the increase was driven by a one-time US$10-million machinery purchase for a new plant opened earlier that year — providing critical context to interpret the metric accurately.

While advanced analytics strengthens decision-making within specific procurement processes, its value extends even further when applied to how teams allocate time and resources across the organization.

Business Case 2

Enabling Data-Driven Capacity Planning

In many procurement organizations, limited visibility into team capacity and fragmented data sources constrain the ability to effectively plan work, optimize utilization and demonstrate broader strategic value. Addressing this challenge demands a unified view of how procurement teams operate across both transactional and strategic work.

IBM’s PAaaS team partnered with a global retail client to address these challenges by delivering a centralized, self-service capacity tracking dashboard. The solution brought together multiple disparate data sources including operational purchasing data and strategic value-add project tracking into a unified data model, enabling a comprehensive view of how sourcing professionals allocate their time across activities.

The data pipeline was automated to refresh on a daily cadence, ensuring teams always had access to up-to-date capacity insights while eliminating the manual effort traditionally required to consolidate and maintain these data sets.

By presenting these insights through an intuitive dashboard, procurement leaders could monitor weekly capacity trends, assess workload distribution, and proactively align resources with evolving business priorities.

Beyond improving visibility, the dashboard became a catalyst for transforming how procurement teams collaborate and measure success. With a unified view of utilization across categories and project types, sourcing managers were better equipped to dynamically shift resources and maintain service levels while significantly reducing the manual effort required to reconcile siloed capacity data.

Over an observed period of 64 weeks, an average of 38 resources per week were tracked across six category teams. During this period, total average utilization was 108 percent, giving insight into a broader trend of overutilization that sourcing managers can leverage for forecasting capacity.

Additionally, the ability to capture and quantify previously untracked activities, such as category strategy and process improvement, allowed teams to recognize and reward value beyond traditional transactional output.

Lessons Learned

Centralizing data eliminates “shadow data” and unlocks enterprise-wide visibility. In many organizations, category managers rely on offline trackers or personal spreadsheets to manage work that is invisible to leadership and peers.

According to the IBM Institute for Business Value, nearly 77 percent of respondents agree or strongly agree that data silos hinder the organization’s ability to perform real-time analytics and make data-driven decisions.

More than 80 percent (83 percent) believe that data silos undermine innovation by preventing cross-departmental sharing of ideas. Engage your governance team to implement a roadmap to identify shadow data sources and centralize them to a single source of truth.

Enhanced visibility enables agility and cross-functional collaboration. Build a unified view of capacity and utilization data, so teams can dynamically rebalance workloads, proactively address bottlenecks, and collaborate across categories in near real time.

Consider key metrics and views that procurement leaders will find most impactful to enable more accurate forecasting and planning:

• Total open projects
• Average utilization
• Resource count
• Resource availability
• Count of active work types
• Count of active category teams or purchase areas
• Individual utilization across varying levels of complexity.

Measuring total contribution shifts procurement from cost center to value driver. By capturing previously untracked strategic work (think category strategy, RFX events, team leadership) and aligning performance metrics across roles, organizations can reward outcomes beyond cost savings and reinforce procurement’s role as a strategic partner.

***

Procurement organizations that embed analytics into their review cycles will accelerate their analytics transformation journey and position themselves as a strategic partner to the business. As illustrated in the examples above, procurement has the potential to deliver meaningful value in a multitude of ways beyond traditional cost savings.

Realizing this potential is a matter of investing in the right capabilities to turn data into measurable outcomes.

(Image credit: Getty Images/Nong Asimo)