View

A Guide to Spend Cubes

A Guide to Spend Cubes

Date
Category
Procurement
Share

A spend cube answers a question that most organisations struggle with: exactly where the money goes, with whom, and why. Without clear visibility of spending patterns, procurement teams operate in the dark, unable to negotiate effectively, identify waste or build category strategies grounded in evidence.

Whether you are a procurement professional inheriting a new portfolio, a finance director questioning rising costs, or a business leader seeking better control over supplier expenditure, this guide explains how spend cubes work, how to build one and how to use what it shows you.

A spend cube is a way of organising procurement spend data along three dimensions: what is bought (category), who it is bought from (supplier) and who is buying it (business unit). Viewing all three together shows where spend is concentrated, duplicated or off contract, which gives procurement the evidence it needs to reduce cost.

What Is a Spend Cube?

A spend cube is a way to look at spend data projected as a multidimensional cube. You may also see it written as one word, "spendcube", particularly in software product names. The term comes from the three-dimensional nature of the analysis: every transaction is tagged with a category, a supplier and a business unit, so that the same data can be viewed from any of those angles.

In procurement, the purpose is simple. The cube shows who bought what, from whom. A finance ledger can tell you how much was spent with a supplier. A spend cube can also tell you which departments spent it, on which goods or services, and whether another department bought the same thing elsewhere at a different price.

Spend cubes are not a piece of software in themselves. They are a structure for data, which can be built in a spreadsheet for a small organisation or in a dedicated platform for a larger one. Many organisations use spend analytics services to build the first version, because the data preparation is where most of the effort lies.

The Three Dimensions: Suppliers, Categories and Business Units

Each dimension of the cube answers a different question.

  • Category – What are you buying? The type of goods or services purchased, classified using a structured taxonomy.
  • Supplier – Who are you buying from? The vendors providing those goods or services.
  • Business unit – Who is buying it? The departments, cost centres, sites or legal entities making the purchases.

To picture it, imagine a cube made of small blocks. One edge lists your suppliers, the second lists your spend categories and the third lists your business units. Each block holds a single figure: the amount one business unit spent with one supplier in one category.

You can then slice the cube in any direction. Category analysis tells you what you are buying, per supplier and per business unit. Supplier analysis reveals the range of suppliers per category and per business unit. Business unit analysis shows which cost centres are buying what, and from where.

As a simple illustration, take a business with three sites. The cube shows that all three buy safety equipment, each from a different supplier and each at a different price for the same item. No single site manager could see that from their own budget report.

Modern spend analysis often extends beyond three dimensions, adding time period, contract status, payment terms or location. The principle stays the same.

Want a spend cube built from your data? Talk to our spend analytics team.

How to Build a Spend Cube

Building a spend cube is a data discipline more than a technology exercise. The quality of the output depends on the rigour applied at each stage.

1. Collect Your Data

Gather spend data from every source across the organisation. This typically includes ERP systems, accounts payable records, purchase orders, invoices, corporate purchasing cards, expense reports and contract registers.

The challenge is that data often sits in several systems with inconsistent formats. A business may use one system for procurement, another for accounts and spreadsheets for ad hoc purchasing. It is always advisable to map every source of expenditure before you begin, including off-system purchases and department-level spending that does not flow through central procurement.

2. Cleanse the Data

Remove duplicates, correct errors, standardise formats and reconcile discrepancies. This is typically the most time-consuming stage. Common problems include the same supplier recorded under several name variations, missing category codes, duplicate entries from different systems and unclassified transactions.

It is worth investing the time here. Analysing poor data produces unreliable findings and undermines confidence in the whole exercise, which is why cleansing your data and holding it in one place comes before any analysis.

3. Classify the Spend

Assign each transaction to a category within your taxonomy. A spend taxonomy is the system of classification, from general to specific, of spending within your organisation. Taxonomies typically have three to four levels:

  • Level 1 (Group) – The broadest classification, for example "IT Services".
  • Level 2 (Family) – A sub-category, for example "Software".
  • Level 3 (Category) – More specific, for example "Enterprise Resource Planning".
  • Level 4 (Commodity) – The most detailed level, for example a named software licence.

Some organisations adopt a published standard such as UNSPSC (the United Nations Standard Products and Services Code). Others develop a custom taxonomy that reflects their industry. It is recommended that you do not over-engineer it, as levels beyond four tend to become difficult to apply consistently.

4. Choose Your Tools

For a small data set, a spreadsheet with pivot tables can be a reasonable starting point. It struggles with large volumes, needs manual updating and offers limited ways to view several dimensions at once.

Business intelligence tools such as Power BI and Tableau allow users to drill down into each dimension and filter by time period. Dedicated spend analytics software goes further, with automated data feeds and classification that can be refreshed without rebuilding the cube each time. Technology speeds up the process, but it does not remove the need for someone who understands the categories to check the results.

Spend Cube Analysis: What It Shows You

With clean, classified data in place, spend cube analysis turns the structure into decisions. The size of the opportunity depends on the maturity of the procurement function and how well spend has been managed in the past. First-time analyses tend to reveal the most, because they expose patterns that were previously invisible.

Savings Opportunities

  • Supplier consolidation – How many suppliers provide similar goods or services? Can volume be combined to negotiate better terms?
  • Price variation – What price differences exist for identical items across business units or time periods?
  • Demand management – Are all purchases necessary? Can specifications be standardised to reduce variety and cost?
  • Spend trends – Which categories are growing faster than expected?

Tail Spend

The cube also brings tail spend into view. This is the large number of small, infrequent purchases that sit outside managed contracts. The tail typically accounts for a small share of total spend but a large share of the supplier base. Individually these transactions look minor. Together they are often a significant source of savings.

Compliance

Maverick spend means purchases made outside agreed contracts, preferred suppliers or procurement policies. A spend cube reveals purchases from non-approved suppliers in categories where a contract already exists, and purchases that bypass approved channels altogether. It also shows whether contracted suppliers are being paid at the agreed rates.

Findings only matter if they lead to action. It is advisable to identify a small number of quick wins early and pursue them whilst the analysis is refined, as spending too long perfecting the data is one of the most common reasons these projects stall.

Spend Cube vs Spend Analysis

The two terms are often used interchangeably, but they are not the same thing. Spend analysis is the broader discipline of examining procurement data to understand spending patterns and identify opportunities. A spend cube is one specific method within it, which structures the data across three or more dimensions so that it can be examined from several angles at once.

In other words, the spend cube is the model and spend analysis is the overall process. You can carry out spend analysis in procurement without a cube, for example by ranking suppliers by annual spend. The cube adds the ability to cross-reference, which is where most of the less obvious findings come from.

Neither should be a one-off exercise. Markets, suppliers and spending patterns change, so the cube needs refreshing on a regular cycle to stay useful.

Key Takeaway

A spend cube gives you a single, structured view of what is bought, from whom and by whom. Its value depends on the quality of the data behind it, so most of the effort goes into collecting, cleansing and classifying before any analysis begins. Used regularly, it is the evidence base for supplier consolidation, contract compliance and category strategy.

How Athena Can Help

Building a spend cube for the first time can be daunting, particularly when data is spread across several systems and there is no established taxonomy. We assess your current position, consolidate and cleanse your spend data, classify it and present the findings in a form your team can act on. You can see an example in the Block spend analytics case study, where £250k of savings and a supplier database were delivered for Block Solutions.

Whether you need a one-off analysis to set a baseline or ongoing support to build a spend analytics function, our approach is designed to minimise the load on your team. A fresh pair of eyes on your spending data can reveal opportunities that have been hiding in plain sight.

Want a spend cube built from your data? Talk to our spend analytics team.

Frequently Asked Questions

What is a spend cube in procurement?

In procurement, a spend cube is a model that organises spend data by category, supplier and business unit. It lets you see who bought what, from whom, in a single view. Procurement teams use it to find savings, reduce supplier numbers and check that contracts are being used.

What is a spend cube and how can it help me?

A spend cube is a three-dimensional view of your organisation's spending. It helps by showing where the same goods or services are bought from different suppliers at different prices, where spend is happening outside contracts, and which categories deserve attention first. That evidence supports better negotiation and clearer budget decisions.

What tools are available for improving spend visibility across multiple entities?

The main options are spreadsheets, business intelligence tools such as Power BI or Tableau, and dedicated spend analytics software. For a group with several legal entities, a dedicated platform or BI tool is usually needed, because it can combine data from different finance systems into one classified data set. Whichever tool you choose, a shared supplier list and a common taxonomy matter more than the software.

How can I improve spend visibility across multiple business locations?

Start by bringing the spend data from every location into one place and standardising supplier names. Apply the same category taxonomy to all of it, then use location as the business unit dimension of the cube. You can then compare sites directly and see where the same items are bought at different prices.

Can you build a spend cube in Excel?

For a small-scale analysis, Excel can be a starting point. It struggles with large data sets, needs manual updating and does not support automated classification. For an ongoing programme, dedicated software or a BI tool will usually give better results.

How often should you update a spend cube?

Spend analysis should be a continuous process, not a one-off project. A quarterly refresh is a sensible minimum, as it captures seasonal variation and shows the effect of changes you have made. Organisations with automated data feeds can keep the view close to real time.

Frequently Asked Questions

How long does it take to build a spend cube?

The timeline depends on the complexity of your data landscape and the number of source systems involved. A straightforward analysis with clean data from a single ERP system can be completed in two to four weeks. For organisations with fragmented data across multiple systems, the process typically takes six to twelve weeks, with data cleansing accounting for the majority of that time. AI-powered classification tools can significantly reduce the classification stage.

What size of organisation benefits from spend cube analysis?

Any organisation with significant procurement expenditure can benefit. However, the return on investment increases with complexity -- multiple business units, numerous suppliers, and fragmented purchasing processes create more opportunities for savings. Organisations with annual procurement spend exceeding £5 million typically see the most dramatic results from their first spend analysis.

Can we build a spend cube using Excel?

For small-scale analyses, Excel can be a starting point. However, Excel has significant limitations for spend analysis: it struggles with large datasets, lacks multi-dimensional visualisation capabilities, requires manual updating, and does not support automated classification. For any serious spend analysis programme, dedicated spend analytics software or integration with tools like Power BI will deliver far better results.

How often should we update our spend cube analysis?

Spend analysis should be a continuous process, not a one-off project. At minimum, refresh your analysis quarterly to capture seasonal variations and track the impact of implemented changes. Leading organisations maintain real-time or near-real-time spend visibility through automated data feeds from their procurement and finance systems.

What is the difference between spend analysis and spend cube analysis?

Spend analysis is the broader discipline of examining procurement data to understand spending patterns and identify opportunities. A spend cube is a specific analytical method within spend analysis that structures data across three or more dimensions (category, supplier, business unit) to enable multi-dimensional interrogation. Think of the spend cube as the visualisation tool and spend analysis as the overall process.