KPI Tree

KPI Tree vs Looker

KPI Treevs

Looker provides strong data governance through its LookML semantic layer. KPI Tree adds what's missing: a way to see cause and effect across your metrics, and a reason for every person to care.

Run both in parallel. Watch one drive action.

Start with your power users, expand department by department, and watch Looker quietly retire itself.

Looker
KPI Tree

First few weeks

Pilot team onboarded

Month by month

Department by department

6 months +

Organization-wide

End state

Looker retired

LookML defines your metrics. But who acts on them?

See how Looker and KPI Tree take fundamentally different approaches to the same problem.

The Looker way

Best-in-class data governance through LookML, but the gap between defining a metric and acting on it is still wide open.

  • Metrics are defined in LookML code. Powerful governance, but requires 0.5–2 dedicated FTEs
  • No concept of metric hierarchy or relationship mapping between metrics
  • Explores are powerful for analysts, but intimidating for business users
  • No metric ownership or accountability framework at the business level
  • Starting at ~$60,000/year with viewer licences at ~$30/user/month ($400/year)
  • LookML is proprietary and locks metric definitions to the Looker platform

The KPI Tree way

Make it effortless to understand what's happening across your business, and give every person a reason to care.

  • Combine metrics from multiple sources (Snowflake, BigQuery, dbt, Google Sheets) on a single tree
  • Full RACI accountability: Responsible, Accountable, Consulted, Informed per metric
  • Assign tasks with due dates that are tracked against real metric outcomes, not self-reported activity
  • Casually map relationships between metrics so anyone can understand the business at a glance, no context needed
  • Prove your growth hypothesis with built-in correlation analysis that shows which metrics actually drive each other
  • Full period-on-period analysis (MoM, WoW, YoY) with the ability to jump to any date in history
  • Tabular view with instant switching between daily, weekly, monthly, quarterly, and yearly aggregation
  • No specialist training required. Metric trees are visual and intuitive for any team member
  • Push insights natively via Email, Slack, SMS, and WhatsApp with no middleware
  • Native dbt Semantic Layer integration that works alongside LookML, not against it
  • No per-seat charges. Starter includes 10 users, Growth and Enterprise are unlimited

We talk to dozens of Looker teams every week.

This is a direct window into what they tell us about their experience.

We need a dedicated LookML developer just to maintain our metric definitions.

Onboarding a new analyst takes months because of LookML complexity.

At £120K/year it is by far our most expensive analytics tool.

Our metrics are locked into Looker, and we can not use them anywhere else.

Non-technical stakeholders can not explore data without asking the data team.

We need a dedicated LookML developer just to maintain our metric definitions.

Onboarding a new analyst takes months because of LookML complexity.

At £120K/year it is by far our most expensive analytics tool.

Our metrics are locked into Looker, and we can not use them anywhere else.

Non-technical stakeholders can not explore data without asking the data team.

We need a dedicated LookML developer just to maintain our metric definitions.

Onboarding a new analyst takes months because of LookML complexity.

At £120K/year it is by far our most expensive analytics tool.

Our metrics are locked into Looker, and we can not use them anywhere else.

Non-technical stakeholders can not explore data without asking the data team.

Close the gap between knowing and doing

Two things are missing from traditional BI: a way to see cause and effect across your business, and a reason for every person to care.

See cause and effect
Give every person a reason to care
Turn insight into action

See cause and effect

Your business is a system, so map it like one. Metric trees show how every KPI cascades and drives others, so when a number moves you can trace the cause instead of asking five specialists. Looker defines metrics in LookML but doesn't visualise their relationships.

Give every person a reason to care

Looker gives your data team the governance to define metrics consistently. But consistent definitions do not tell a stakeholder what drives conversion rate or why churn matters to revenue. That understanding is the behavioural shift that makes people care. Behavioural science shows that environmental factors drive 75% of performance outcomes. The most powerful is line of sight: when people can see how their work connects to business outcomes, they don't just comply, they care. Assign Responsible, Accountable, Consulted, and Informed roles per metric so every person can trace their impact. Looker has no concept of metric ownership.

Turn insight into action

The gap between seeing a problem and acting on it is where value dies. Assign tasks with due dates, track them against real metric outcomes, and push insights natively via Email, Slack, SMS, and WhatsApp so your team acts before the damage is done. Looker supports email and Slack, but not SMS or WhatsApp.

How does KPI Tree compare with Looker?

Core architecture

Primary paradigm

Explores & dashboardsLooker
Metric treesKPI Tree

Multi-source metric trees

Single model per projectLooker
KPI Tree

Metric hierarchy

Looker
KPI Tree

Metric relationship mapping

Looker
Drag-and-dropKPI Tree

RACI accountability matrix

Looker
KPI Tree

Metric ownership

Looker
KPI Tree

Semantic layer

LookMLLooker
dbt Semantic LayerKPI Tree

Correlation analysis

Looker
KPI Tree

Built-in comparison periods

LookML required (new runtime only)Looker
Built-in (any historical date)KPI Tree

Time granularity switching

Per-Explore configLooker
Daily to yearly (instant)KPI Tree
Data connectivity

dbt Semantic Layer

No (competing layer)Looker
NativeKPI Tree

Snowflake

Looker
KPI Tree

BigQuery

OptimisedLooker
KPI Tree

Google Sheets

Looker
KPI Tree

Git-based modelling

Looker
KPI Tree
Collaboration & engagement

Email notifications

Looker
KPI Tree

Slack notifications

Looker
KPI Tree

SMS notifications

Looker
KPI Tree

WhatsApp notifications

Looker
KPI Tree

Task assignment with due dates

Looker
KPI Tree

Tasks tracked against metric outcomes

Looker
KPI Tree

Unlimited viewers

~£24/user/moLooker
Growth+ (10 on Starter)KPI Tree

Embedded analytics

Looker
KPI Tree
AI & analytics

AI-powered insights

Gemini (GA, all users)Looker
KPI Tree

Natural language Q&A

Conversational Analytics (GA Nov 2025)Looker
EnterpriseKPI Tree

Performance drivers

Looker
KPI Tree

Anomaly detection

On-demand (Code Interpreter)Looker
KPI Tree
Security & compliance

SOC 2 Type II

Looker
Growth+KPI Tree

SSO

SAMLLooker
Growth+KPI Tree

Directory Sync (SCIM)

Unofficial proxy onlyLooker
Growth+KPI Tree
Pricing

Starting price

~$60K+/year (custom)Looker
£1,000/mo (10 users)KPI Tree

Viewer pricing

~$30/user/mo ($400/year)Looker
Included (no per-seat)KPI Tree

Per-seat charges

Looker
KPI Tree

Typical total cost (50 users)

~$84K–$120K/yearLooker
£2,500/moKPI Tree

Which is right for you?

Both tools have their strengths. Here's a straightforward guide to help you decide.

Looker

Choose Looker if you...

  • You need strong data governance with a Git-integrated semantic layer
  • You have a dedicated analytics team that can maintain LookML
  • You need embedded analytics capabilities
  • You are invested in the Google Cloud ecosystem with BigQuery
KPI Tree

Choose KPI Tree if you...

  • You need a visual metric hierarchy that shows how KPIs drive each other
  • You want formal RACI accountability for every metric
  • You want to close the gap between knowing and doing with tasks that are tracked against real metric outcomes
  • You need to push metrics via Slack, SMS, and WhatsApp
  • You use dbt and want a tool that works with your existing Semantic Layer
  • You want flat pricing without high per-seat costs

Common questions

Most teams start by running both in parallel. Looker handles data exploration and governed metrics via LookML. KPI Tree maps your business as a system of cause and effect, assigns every metric an owner, and tracks every action against the metric it was meant to move. Understanding creates clarity. Ownership creates accountability. Tracking creates proof. As that loop closes department by department, Looker usage naturally decreases and many organisations retire it.
KPI Tree integrates with Looker at the Enterprise tier, allowing you to sync metric definitions. KPI Tree also integrates natively with dbt Semantic Layer, which can sit alongside LookML in your stack.
Looker starts at ~$60,000/year with viewer licences at $400/year per user, plus LookML developer costs (~$50K–$70K/year). KPI Tree starts at £1,000/month for 10 users. The Growth plan at £2,500/month includes unlimited users with no per-seat charges, making it significantly more cost-effective for organisations focused on metric distribution and accountability.