AI Trends 2026: Self-Service BI Is Becoming Agentic

On this page

1. AI trends 2026: the four generations of self-service analytics
2. The next generation of self-service BI isn't another dashboard
3. Why raw text-to-SQL breaks agentic analytics
4. Anthropic reached the same conclusion in production
5. A governed semantic layer gives agents shared meaning
6. MCP is becoming the interface between agents and business data
7. People and agents working from the same definitions
8. From a modern data stack to an agent-ready data foundation
9. Frequently asked questions

The way people get answers out of company data is changing faster than the data stacks underneath them. For twenty years the answer to "why did that number move?" was a dashboard someone built in advance. In 2026, increasingly, the answer is an agent that goes and finds out.

Among the AI trends 2026 has surfaced, that is the one worth paying attention to. Not "companies are using more AI" — they are — but something more specific: self-service business intelligence is becoming agentic, and the constraint on whether it works has moved from the model to the data foundation underneath it.

The adoption numbers are already there. According to Google Cloud's ROI of AI Report, 52% of executives report their organizations are deploying AI agents in production, and 88% of agentic AI early adopters are already seeing positive ROI. What those numbers hide is how much of the work is data architecture rather than prompting. To build a trustworthy modern data strategy for the age of AI, you have to change how machines get meaning out of your warehouse — not just how they get access to it.

---

AI trends 2026: the four generations of self-service analytics#

It helps to see where agentic analytics sits in a longer arc. Self-service BI has been reinvented roughly every decade, and each generation moved the work around rather than eliminating it.

The fourth generation is not a nicer chat box. The difference is that an agent doesn't just answer the question you asked — it runs the next three queries a good analyst would have run, checks its own result, and tells you what it found.

The infrastructure for that is already being built at scale. According to customer usage data compiled by Databricks, multi-agent workflows have grown by 327% year over year, and supervisor agents coordinating networks of specialized subagents now account for 37% of all agent usage.

---

The next generation of self-service BI isn't another dashboard#

The promise of self-service BI was always straightforward: let business users answer their own questions without waiting on the data team.

The interface kept getting easier. The underlying limitation never moved. Someone still had to anticipate the question, model the data, build the dashboard, define the metrics, and teach the user where to look. "Self-service" in practice meant "self-service, within the boundaries of what a data engineer already imagined you'd ask."

Agents change that equation. Instead of navigating dashboards, a sales leader can ask:

Why did expansion ARR drop in DACH this quarter? Which accounts caused it? What changed in their product usage in the months before the contraction?

No dashboard answers that question, because it isn't one question — it's an investigation. An agent can run that investigation dynamically: pull the metric, decompose it by account, join in product usage, look at the period before the drop, and come back with a narrative.

But only if it understands what "expansion ARR," "DACH," "account," and "product usage" mean inside your business. That is the whole problem.

---

Why raw text-to-SQL breaks agentic analytics#

When teams build their first internal analytics agent, the instinct is to connect it straight to the warehouse: hand the model database credentials, write a prompt, and let it generate SQL.

This is where most projects stall. Direct text-to-SQL has three systemic weaknesses:

1. Schema complexity. A typical enterprise warehouse has hundreds of tables, column names like usr_act_v2, and three fields that all look like they might be revenue. A model guessing at what those mean will guess wrong often enough to matter.
2. No metric governance. If three agents query raw tables for "Monthly Recurring Revenue," you get three SQL statements and three different numbers — with no way to tell which one leadership should act on.
3. No safety boundary. Raw SQL access exposes every table the credential can reach, including the ones nobody intended an agent to see.

Databricks' customer data points the same direction: a lack of structural control is the single biggest bottleneck to shipping AI. Teams that implement governance and security tooling ship 12x more production deployments, and standardized evaluation tooling yields 6x more.

The failure mode isn't that the agent can't write SQL. Modern models write excellent SQL. The failure mode is that it doesn't know what your business means.

---

Anthropic reached the same conclusion in production#

The strongest evidence for this isn't a vendor benchmark — it's Anthropic publishing its own internal architecture.

In How Anthropic enables self-service data analytics with Claude (June 3, 2026), Anthropic's data team reports that 95% of business analytics queries are now automated through Claude, at roughly 95% aggregate accuracy — and close to 99% in some domains. The headline result is impressive. The explanation is the useful part.

Anthropic is explicit that this is not a model story. Analytics accuracy, in their framing, is a context and verification problem, not a code-generation problem. The same Claude that reaches 95% with the right scaffolding never got above 21% on their internal evals without it.

Their agents don't start by improvising SQL. The stack they describe has four layers:

• Data foundations — the warehouse itself: models, transformations, tests, and the metadata that describes them.
• Sources of truth — a human-curated semantic layer of metric and dimension definitions, plus lineage graphs and business-context knowledge. Notably, they found that auto-generating metric definitions from raw tables and query logs didn't work: it reproduced the ambiguity instead of removing it.
• Skills — procedural knowledge in markdown telling the agent which sources to consult, in what order, and what a finished answer looks like. That skill set is synced to multiple surfaces and served as resources over MCP.
• Validation — offline evals, ablation testing, and online monitoring with adversarial review.

Two details matter most for anyone building this. First, the semantic layer is the required first path: when a question maps to a defined metric, the agent calls that definition and gets the same number every other surface in the company produces. Raw table access is the fallback, not the default. Second, the same governed context is exposed across agent surfaces, so the answer doesn't change depending on whether someone asks in Slack, in an IDE, or in a chat window.

And they are honest about the limits. This architecture reduces failures; it doesn't eliminate them. Anthropic keeps adversarial review running precisely because silent failures still happen, and reports that without active maintenance accuracy drifts from 95% back toward 65%.

Better models help. Better context architecture is what makes self-service analytics trustworthy.

---

A governed semantic layer gives agents shared meaning#

A semantic layer is the translation between how data is stored and how the business talks. It maps raw tables to defined business concepts: instead of querying billing_ledgers_final, the agent queries an entity called Revenue and asks for MRR broken down by acquisition_channel.

Combining that with agent access gives agents something raw warehouse credentials cannot: a shared definition of customers, revenue, churn, pipeline, and every other concept they need in order to reason correctly.

The measurable effect is large. A general-purpose model writing SQL against an unmapped schema fails roughly half the time — Snowflake's internal benchmarks put GPT-4o at about 51% text-to-SQL accuracy on raw schemas. Grounding the same model in a governed semantic model lifts accuracy past 90%.

That is the same conclusion Anthropic reached, arrived at from a different direction: the governed definition is what turns a plausible answer into a correct one.

---

MCP is becoming the interface between agents and business data#

Dashboards were the interface between people and business data. MCP is becoming the interface between agents and business data.

The Model Context Protocol (MCP), released as an open standard by Anthropic, is the emerging connection layer of the AI ecosystem — the USB-C port for agent tooling. Rather than writing bespoke integration code for every model and every tool, you run a reusable MCP server. The agent connects, discovers what's available — metrics, schemas, reports — and calls it. The same server works for Claude, for IDEs like Cursor, and for custom orchestrators.

Standardizing that interface pays off quickly. In its 2026 Business Trends Report, Google Cloud describes how pulp manufacturer Suzano cut query times by 95% for 50,000 employees by deploying standardized semantic data interfaces.

But MCP on its own doesn't make data trustworthy. It solves connectivity, not meaning. An MCP server pointed at raw tables is a faster route to the same wrong answers. The quality of what comes back still depends entirely on the governed context sitting behind it — which is exactly where the interesting engineering is.

---

People and agents working from the same definitions#

None of this makes dashboards, analysts, or data teams disappear. It changes the collaboration model.

People define and govern what the business means — what counts as an account, how expansion ARR is calculated, which source system wins when two disagree. Agents perform the continuous investigation humans don't have time for. Both work from the same underlying definitions, and the semantic layer becomes the contract between them.

This matters more than it sounds, because of something Anthropic observes directly: once agents become the consumers of the data model, the person asking the question often can't validate the answer themselves. The reader of a dashboard could sanity-check a number against the chart next to it. The reader of an agent's paragraph cannot. Governance stops being a compliance concern and becomes the thing that makes the output usable at all. The same principle governs any enterprise AI agent deployment: the agents are only as trustworthy as the definitions they read. It holds even harder once agents start acting rather than only answering — whether one may enrich a new contact inside a customer account is a rule that has to live in the model too, or nobody can explain six months later why that contact was added.

---

From a modern data stack to an agent-ready data foundation#

The usual framing of this problem is vendor sprawl — ingestion here, warehouse there, transformation, semantics, and a custom API on top. That framing misses the point.

The problem isn't that there are too many vendors. It's that traditional data stacks were designed for humans consuming dashboards, not for agents consuming context. A human reading a report brings their own business knowledge to it. An agent has to be given that knowledge explicitly, in a form it can navigate — which is a requirement almost no stack was built to satisfy.

RevOS is built as that foundation, in four moves:

• Connect your data. Managed open-source ingestion from 160+ sources into a BigQuery lakehouse provisioned in your own cloud.
• Govern what it means. An AI agent builds your dbt models and semantic model — metrics, entities, and relationships defined once, version-controlled like code.
• Serve it to agents. The governed model is exposed through a secure MCP server, so Claude, your IDE, and your own agents all read the same definitions.
• Learn continuously. Definitions, lineage, and skills evolve with the business instead of drifting away from it.

The practical difference at query time: agents don't guess against raw schemas. They work from the same governed definitions your business already trusts, rather than inventing their own interpretation of the underlying tables — which removes one of the largest sources of analytics hallucination.

If you're currently assessing your data readiness for machine learning, or looking at how agentic data engineering changes who builds your models, this is the layer that decides whether the agents on top of it are worth trusting.

---

Frequently asked questions#

What is the new trend in AI for 2026?#

The defining trend of 2026 is agentic analytics: self-service business intelligence is shifting from dashboards and natural-language search to AI agents that investigate a business question end to end. Instead of reading a pre-built report, a user asks why a number moved, and the agent navigates governed business context, runs the follow-up queries a human analyst would run, and validates its own answer before returning it.

What is agentic analytics?#

Agentic analytics is the practice of letting AI agents answer business questions by navigating a governed data foundation rather than improvising SQL against raw tables. The agent looks up what a metric means, queries it through a semantic layer, investigates follow-up questions on its own, and checks its result. Anthropic's own data team reports automating 95% of business analytics queries this way, at roughly 95% aggregate accuracy.

What is Model Context Protocol (MCP) and how does it relate to AI agents?#

Model Context Protocol (MCP) is an open-standard communication protocol developed by Anthropic. It acts as a standardized interface (similar to USB-C) that lets AI models and autonomous agents connect to enterprise data sources, tools, and databases through reusable MCP servers. Dashboards were the interface between people and business data; MCP is becoming the interface between agents and business data. MCP solves connectivity, not meaning — answer quality still depends on the governed context behind the MCP server.

Why do AI agents need a semantic model instead of raw SQL access?#

AI models querying raw, unmapped database schemas suffer from a high text-to-SQL failure rate (~50%) because of table complexity and missing business context. Grounding agents in a governed semantic layer gives them shared definitions of relationships, metrics, and entities, which raises query accuracy past 90% and keeps every agent reporting the same number for the same metric.

Will AI agents replace dashboards, analysts, and data teams?#

No — they change the division of labour. People define and govern what the business means: what counts as an account, how expansion ARR is calculated, which source system wins a conflict. Agents perform the continuous investigation nobody has time for. Both work from the same definitions, and the semantic layer becomes the contract between them. Anthropic makes the same point in reverse: once agents consume the data model, users often cannot check the answer themselves, which makes governed definitions and validation more important, not less.

Frequently asked questions

What is the new trend in AI for 2026?

The defining trend of 2026 is agentic analytics: self-service business intelligence is shifting from dashboards and natural-language search to AI agents that investigate a business question end to end. Instead of reading a pre-built report, a user asks why a number moved, and the agent navigates governed business context, runs the follow-up queries a human analyst would run, and validates its own answer before returning it.

What is agentic analytics?

Agentic analytics is the practice of letting AI agents answer business questions by navigating a governed data foundation rather than improvising SQL against raw tables. The agent looks up what a metric means, queries it through a semantic layer, investigates follow-up questions on its own, and checks its result. Anthropic's own data team reports automating 95% of business analytics queries this way, at roughly 95% aggregate accuracy.

What is Model Context Protocol (MCP) and how does it relate to AI agents?

Model Context Protocol (MCP) is an open-standard communication protocol developed by Anthropic. It acts as a standardized interface (similar to USB-C) that lets AI models and autonomous agents connect to enterprise data sources, tools, and databases through reusable MCP servers. Dashboards were the interface between people and business data; MCP is becoming the interface between agents and business data. MCP solves connectivity, not meaning — answer quality still depends on the governed context behind the MCP server.

Why do AI agents need a semantic model instead of raw SQL access?

AI models querying raw, unmapped database schemas suffer from a high text-to-SQL failure rate (~50%) because of table complexity and missing business context. Grounding agents in a governed semantic layer gives them shared definitions of relationships, metrics, and entities, which raises query accuracy past 90% and keeps every agent reporting the same number for the same metric.

Will AI agents replace dashboards, analysts, and data teams?

No — they change the division of labour. People define and govern what the business means: what counts as an account, how expansion ARR is calculated, which source system wins a conflict. Agents perform the continuous investigation nobody has time for. Both work from the same definitions, and the semantic layer becomes the contract between them. Anthropic makes the same point in reverse: once agents consume the data model, users often cannot check the answer themselves, which makes governed definitions and validation more important, not less.

Read more about revenue operations, growth strategies, and metrics in our blog and follow us on LinkedIn and Youtube.

All articles