How to Create a Procurement Dashboard in Looker

Turning scattered procurement data into clear, actionable insights transforms your function from a cost center into a strategic value driver. Your ERP, accounting software, and endless spreadsheets hold the keys to smarter spending and better supplier relationships, but manually crunching those numbers is a dead end. This guide will walk you through creating a dynamic procurement dashboard in Looker to give you real-time visibility and control over your entire procurement lifecycle.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Build a Procurement Dashboard in Looker?

While spreadsheets can provide a snapshot, they're static and time-consuming. A dedicated procurement dashboard in a tool like Looker, on the other hand, offers a live, interactive view of what's happening. Instead of spending your Mondays exporting CSVs, you get immediate answers to your most pressing questions.

Here’s what you get with a well-built Looker dashboard:

• Real-time Visibility: See up-to-the-minute data on spending, purchase orders (POs), and supplier activity. No more waiting for a weekly report assembly.
• Better Spend Management: Instantly identify maverick spend (purchases made outside of approved processes), track savings, and analyze spending patterns by category or department to find new opportunities.
• Enhanced Supplier Oversight: Monitor key supplier KPIs like on-time delivery rates, defect rates, and pricing variances to build stronger partnerships and mitigate risks.
• Increased Efficiency: Track process metrics like PO cycle time and invoice accuracy to spot bottlenecks in your procure-to-pay process and streamline operations.

Before You Build: Key Metrics for Your Procurement Dashboard

A dashboard is only as useful as the metrics it tracks. Before you jump into Looker, map out the Key Performance Indicators (KPIs) that matter most to your organization. Grouping them by function will help you design a clear and logical dashboard layout.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Spend Analysis

This is the foundation of any procurement dashboard. Understanding where your money is going is the first step to controlling it.

• Total Spend: The most fundamental metric. You’ll want to slice this by category, department, supplier, and time period (e.g., month over month).
• Spend Under Management: This tracks the percentage of total company spend that is actively managed by the procurement department. A higher percentage indicates more control and greater potential for cost savings.
• Maverick Spend: Otherwise known as tail spend or off-contract spend, this is money spent outside of established procurement channels. High maverick spend often signals inefficiencies and missed savings opportunities.
• Cost Savings: These are the "hard savings" realized from negotiating better prices, consolidating suppliers, or changing specifications. It's the most direct way to demonstrate procurement's value.

Supplier & Vendor Performance

Your suppliers are critical partners. This section of the dashboard helps you objectively measure their performance and ensure they’re meeting their commitments.

• On-Time Delivery Rate: Calculated as (Number of on-time orders / Total number of orders) x 100. This KPI is vital for preventing production delays and stockouts.
• Supplier Defect Rate: (Number of rejected parts / Total parts received) x 100. This metric directly measures the quality and reliability of a supplier's products.
• Purchase Price Variance (PPV): This compares the standard cost of an item to the actual price you paid. A negative PPV is good (you paid less than expected), while a positive variance may require investigation.
• Number of Suppliers by Category: Helps you identify opportunities for supplier consolidation, which can lead to better volume-based pricing and stronger relationships.

Process Efficiency and Compliance

These metrics focus on the health and speed of your internal procure-to-pay (P2P) process.

• Purchase Order Cycle Time: The average time it takes from creating a purchase requisition to a PO being sent to the supplier. A long cycle time can create delays for the business.
• Invoice Accuracy: The percentage of invoices that are processed without errors (like price or quantity discrepancies). High accuracy saves your AP team countless hours of rework.
• PO Compliance Rate: The percentage of invoices that can be matched to an approved PO. Low compliance is a major symptom of maverick spend.

Step 1: Get Your Data Ready for Looker

Looker doesn't store your data, it sits on top of your existing database or data warehouse (like Google BigQuery, Snowflake, or Amazon Redshift) and reads from it directly. This means the first technical step is ensuring your data is in one of these systems.

Your procurement data is likely spread across multiple platforms:

• ERP Systems: SAP, Oracle NetSuite, Microsoft Dynamics containing POs, invoices, and supplier master data.
• Accounting Software: QuickBooks, Xero containing payment and invoice records.
• Spreadsheets: Google Sheets or Excel files used for tracking contracts, savings initiatives, or ad-hoc supplier lists.

To use Looker effectively, you first need to consolidate these sources into a central data warehouse. Once your relevant tables (e.g., purchase_orders, invoices, suppliers, line_items) are in the warehouse, you can connect Looker and begin modeling.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 2: Building Your Procurement Dashboard in Looker

With your data connected, it's time to build. The process involves creating a semantic model with Looker's modeling language (LookML), building individual visualizations (called "Looks"), and then combining them into a dashboard.

Making Sense of Your Data with LookML

LookML is the secret sauce of Looker. It's a layer that sits between your database and your end-users, allowing you to define your business logic in one place. You don't write SQL queries to build charts, you use familiar business terms that your LookML model defines.

In your LookML project, you would create "views" that correspond to your database tables. For each view, you define:

• Dimensions: These are the fields you use to group or filter your data, like supplier_name, spend_category, or order_date.
• Measures: These are the aggregated calculations, like a count, sum, or average. Examples include a total_spend (a sum of the price field) or po_count (a count of distinct purchase orders).

By defining these once, you ensure that everyone in the company calculates "Total Spend" the exact same way, delivering a single source of truth.

Creating "Looks" for Each Metric

A Look is a single data visualization or table. You'll create one Look for each KPI on your dashboard. Let's build a simple one: "Spend by Category."

1. Navigate to an Explore: An Explore in Looker is a starting point for a query. You might have an "Orders" or "Spend" Explore built on your LookML model.
2. Select Your Data: In the Explore interface, you’ll see the dimensions and measures you defined in LookML listed in a field picker on the left.
3. Run the Query: Hit the "Run" button. Looker writes the SQL query for you behind the scenes and brings back a data table showing total spend for each category.
4. Choose Your Visualization: In the Visualization tab, select a chart type that fits a part-to-whole relationship, like a Pie Chart or a Bar Chart. Customize the colors and labels as needed.
5. Save as a Look: Once you're happy with it, save the visualization as a Look, giving it a clear name like "Total Spend by Category - Last 90 Days."

You’ll repeat this process for all the KPIs you defined earlier, creating different Looks for On-Time Delivery Rate (using a scorecard visualization), PO Cycle Time (perhaps a line chart), and so on.

Assembling Your Dashboard

Once you've created several Looks, you bring them together on a dashboard.

1. Navigate to the "Dashboards" folder and create a new dashboard.
2. Click "Add Tile" and choose "From a Look." Select the Looks you just created to add them to the dashboard canvas.
3. Drag, drop, and resize the tiles to create a logical and visually appealing layout.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Adding Filters for Interactivity

The real power of a Looker dashboard comes from its interactivity. Adding dashboard-level filters lets users dig into the data themselves without needing to ask for custom reports.

• Go to the dashboard's "Edit" mode and click "Add Filter."
• Common filters for a procurement dashboard include Date Range, Supplier Name, and Department.
• Link the filter to the relevant field in each Look (tile) on your dashboard. Now, when a user selects "Q2" in the date filter, all the connected tiles will update automatically to show data only for that period.

Visual Design Tips for a User-Friendly Dashboard

An effective dashboard isn’t just about the data, it’s about how that data is communicated. Following a few design principles can make the difference between a dashboard that gets used and one that gets ignored.

• Put KPIs First: Place your most important high-level numbers (Total Spend, Cost Savings) in scorecard visualizations at the top. This gives users an at-a-glance overview of performance.
• Choose the Right Chart: Don't try to force data into a flashy visualization. Use line charts for trends over time, bar/column charts for comparisons, and maps for geographic data.
• Keep it Clean: Avoid overwhelming users with dozens of charts. Group related metrics together and use white space to give the dashboard a clean, organized feel. If needed, create separate dashboards for different functions (e.g., a "Supplier Performance" dashboard vs. a "Spend Analysis" dashboard).
• Use Color Meaningfully: Use colors consistently and strategically. For example, use green to indicate positive performance (like high cost savings) and red for negative performance (like a high defect rate).

Final Thoughts

Building a procurement dashboard in Looker organizes your complex spend and supplier data into a clear, interactive command center. It empowers your team to move beyond reactive reporting and start making proactive, data-driven decisions that save money, reduce risk, and improve efficiency.

Laying the foundation in tools like Looker takes a fair amount of technical knowledge and time. At Graphed, we help you get to the insights faster by connecting your data sources and allowing you to create dashboards and reports with simple, natural language. It’s like having a data analyst on your team who can turn questions like "Show me a chart of our top 10 suppliers by spend this quarter" into a live visualization in seconds.