Research Note · Analytics · Licensing

Data analytics licensing: consumption versus the seat.

The modern analytics stack spans data warehouses, lakehouses, BI tools and ML platforms — half a dozen vendors, each with a different meter. This note separates the two commercial models that actually drive cost, maps where each platform leaks spend, and sets out the negotiation and governance moves that hold 25–40% of savings past the next renewal.

By James Hill-WoodUpdated Oct 202110 min readAnalytics licensing cluster
Bottom line

Analytics spend is governed by two meters. Consumption platforms — Snowflake, Databricks — leak through idle and oversized compute; the fix is committed capacity sized to real usage plus consumption governance. Seat-based tools — Tableau, Power BI, SAC — leak through misclassification and bundled uplift. A full review across the stack typically recovers 25–40% of combined spend within 6–9 months.

01 Key findings

  1. Two commercial models, not one. Warehouses and lakehouses meter consumption (Snowflake credits, Databricks DBUs); BI tools meter seats (Tableau, Power BI, SAC). Each fails commercially in a different way and needs a different control.

  2. Consumption elasticity is the primary cost risk. Auto-scaling warehouses can burn credits at 10× a minimum-size warehouse, and 20–30% of Snowflake credit consumption is typically pure waste — idle, oversized or dev-on-prod compute.

  3. Platform expansion multiplies DBUs silently. Organisations that move Databricks from data engineering into ML training can see DBU consumption rise four to six times with no new users, driven by GPU-accelerated instance types.

  4. Seat misclassification cuts both ways. Tableau Viewers who need Explorer capability create compliance risk; Explorers who only ever consume dashboards are pure overpayment. Both hide inside the same licence count.

  5. Bundling is leverage and trap. Tableau via a Salesforce EA, Power BI via a Microsoft EA and SAC via an SAP renewal all gain pricing latitude — but treated as a passive add-on, the bundled product typically costs 20–30% more than a benchmarked standalone deal.

02 Licensing models compared

The single most useful lens on analytics cost is the billing meter. Consumption platforms charge for compute you run; seat platforms charge for users you license. The committed-discount lever and the dominant expansion risk follow directly from which meter applies.

PlatformLicensing modelBilling unitCommitted-use discountPrimary expansion risk
SnowflakeConsumptionCompute credit + per-TB storage25–40% vs on-demandAuto-scaling & idle warehouses
DatabricksConsumptionDBU, rated by workload type20–40% by termML / GPU workload growth
TableauPer-user seatCreator / Explorer / ViewerVia Salesforce bundleSeat misclassification
Power BISeat + capacityPro / PPU / Premium capacityVia Microsoft EAPremium feature creep
SAP Analytics CloudPer-user seatBI / planning / viewer tiersVia SAP renewalBundled add-on uplift

03 Snowflake compute economics

Snowflake separates compute from storage — a decision that makes cost highly elastic. Compute is charged in credits consumed by virtual warehouses that run queries; storage is charged per terabyte of compressed data. On-demand credits run roughly $2–$4 depending on cloud and region; pre-purchased capacity in 12- or 24-month blocks falls to $1.50–$2.50 for large commitments.

That elasticity is commercially dangerous without governance. Auto-scaling warehouses spin up extra clusters as concurrency rises, protecting user experience while generating credits at 10× a minimum-size warehouse. Dev and test warehouses left running overnight consume credits for no business value, and loading jobs run on oversized warehouses are direct waste.

Credit waste patterns

20–30% of credit consumption in a typical large deployment is attributable to warehouses that should be auto-suspended, incorrectly sized warehouses, and development workloads running at production-grade compute. Addressing these before renewal right-sizes the commitment and cuts cost materially.

Negotiation centres on committed capacity. On-demand is never the right model for a committed consumer — the discount versus on-demand is 25–40%, and the break-even is typically four to five months of consumption. Snowflake’s enterprise team has meaningful flexibility above $500K annually, including non-standard storage discounting and rollover for unused pre-purchased credits. A credible evaluation of BigQuery, Redshift, Athena or Synapse unlocks a further 15–25% unavailable in an assumed-renewal conversation.

04 Databricks DBU model

Databricks meters Databricks Units (DBUs) — a compute unit reflecting cluster processing capability per hour. Workload types consume DBUs at different rates, and each platform expansion into ML, MLOps, Unity Catalog governance and generative AI (DBRX, Mosaic AI) tends to add new SKUs at premium DBU rates. Move from data engineering into GPU-accelerated ML training and consumption can multiply four to six times with no new users.

Workload typeDBU intensityCost managementCommon waste pattern
All-purpose (interactive)MediumAuto-terminate after inactivityClusters left running overnight
Jobs (automated)Low–mediumUse jobs clusters, not all-purposeAll-purpose used for production jobs
SQL warehouse (BI)LowSize to peak concurrency, not dataOversized warehouses for modest queries
ML training (GPU)Very highSpot instances for non-critical trainingOn-demand GPU for dev experiments

Negotiation centres on committed DBU packages: roughly 20–30% off on-demand for 12-month commitments and 30–40% for 24-month terms. The decisive points are the DBU rate per workload type (all-purpose versus jobs versus SQL versus ML), the minimum consumption floor relative to realistic projected usage, and rollover provisions for unused DBUs within the committed period.

05 Seat-based BI platforms

Tableau, Power BI and SAP Analytics Cloud all meter users rather than compute — and all three sit inside a larger vendor relationship that supplies leverage and complication in equal measure.

Tableau, acquired by Salesforce in 2019, now spans legacy Desktop/Server and the Tableau Cloud SaaS offering Salesforce is steering customers toward. Its Creator, Explorer and Viewer tiers map to authoring, interaction and consumption — but misclassified users (Viewers needing Explorer rights, Explorers who only consume) create compliance risk or overpayment. On a Salesforce EA, Tableau can be pulled into a broader multi-product negotiation, though Salesforce account teams often treat it as secondary to CRM and Service Cloud renewals.

Power BI is the default in Microsoft estates because Pro is bundled into M365 E3/E5. Cost escalates at the Premium boundary: Premium Per User adds roughly $20/user/month above Pro, while Premium Capacity — priced by dedicated compute block — makes sense above ~500 report consumers. Standalone Premium Capacity carries stiff list pricing; folded into a Microsoft EA alongside Fabric, Azure and Teams it gains real latitude. See our Microsoft Fabric licensing guide for Power BI’s evolution within the Fabric family.

SAP Analytics Cloud is user-based across BI, planning and viewer tiers and is positioned as the native analytics layer for S/4HANA estates. Negotiated as an add-on to a broader SAP renewal — where SAP holds maximum leverage — customers typically pay 20–30% more than a standalone SAC deal with live competitive alternatives. See our SAP Analytics Cloud licensing guide and, for Tableau ownership in context, the Salesforce licensing guide.

06 Consumption traps

The costliest analytics mistakes are structural, not negotiated — they recur every billing cycle until governance closes them. Three traps account for most avoidable spend.

Trap 1 · Elastic compute with no guardrails

Auto-scaling and always-on warehouses protect experience but bill silently. Without auto-suspend, right-sizing and environment separation, Snowflake and Databricks both drift toward the 20–30% waste band — spend that survives even a well-negotiated rate.

Trap 2 · Platform expansion at premium rates

Each new capability — ML training, streaming pipelines, governance SKUs — arrives at a premium meter. GPU-accelerated Databricks workloads can multiply DBU consumption four to six times without a matching increase in users or business value.

Trap 3 · Passive bundling

Letting a bundled vendor set the analytics price — Tableau inside Salesforce, Power BI inside a Microsoft EA, SAC inside an SAP renewal — typically costs 20–30% more than an actively benchmarked standalone position. Bundles are leverage only when you force the joint conversation.

07 Optimisation framework

Beyond individual negotiations, a governance approach produces sustained savings that one-off discounts cannot. Four mechanisms carry most of the durable result.

Factor 01

Compute tagging & attribution

Tag every Snowflake warehouse and Databricks cluster with a business owner and cost centre, so analytics spend is visible to the teams generating it.

Factor 02

Usage-based access review

Review Tableau, Power BI and SAC access quarterly, deactivating licences for users with no logins in the preceding 90 days.

Factor 03

Query & job optimisation

Pipelines running on excessive compute, or more frequently than data currency requires, are significant waste in both Snowflake and Databricks.

Factor 04

Commitment right-sizing

Review committed compute against actual consumption annually; size commitments at 80–90% of projected usage, not 100–120%, leaving room for growth without overages.

08 Our recommendations

Consumption
Snowflake & Databricks

Commit capacity at 80–90% of realistic projected usage, never on-demand. Pair the rate with auto-suspend, right-sizing and workload-type discipline — and keep a credible cross-cloud alternative live to hold 15–25% of competitive tension.

Seat-based BI
Tableau & SAC

Reclassify users to actual capability before renewal, and run a 90-day access review to reclaim dormant seats. Establish the standalone benchmark first so the per-user price is defensible, not assumed.

Bundled vendors
Power BI & suites

Force a single joint commercial conversation rather than the passive add-on the vendor prefers. Quantify the standalone price, then use the broader EA as leverage — not as cover for a 20–30% uplift.

Benchmark your full analytics stack

Our Cloud & FinOps practice reviews Snowflake, Databricks and Tableau together — contracting and consumption on one engagement. Average saving: 29%.

Request a review →

The Licensing Edge

Weekly intelligence on data analytics platforms, cloud costs and enterprise software licensing. 3,000+ subscribers.