Analytics & Search

Multi-hop query understanding, structural semantic search, and self-serve analytics - what it actually takes to put AI-grade analytics in the hands of business teams.

3 posts

Self-serve analytics has been promised for two decades. What broke it every time was the gap between question and execution - the unspoken assumptions buried in column names, the join paths that only the data engineer remembered, the metric definitions that drifted across dashboards. AI didn't fix this gap. AI exposed it.

This collection examines what changes when analytics and search are both grounded in a typed semantic graph. Posts cover multi-hop query understanding: how an agent navigates from "Q3 NPS for the lapsed-renewal cohort" through entities, relationships, and proven join paths to a single deterministic SQL plan. They also cover semantic search across corporate data - moving past keyword and embedding-only retrieval into context-aware concept resolution, where the same word resolves differently for finance, sales, or legal.

You'll find pieces on conversational analytics for business teams that don't speak SQL, and on how the same semantic substrate that powers search also powers governed dashboards, agent workflows, and audit. The thesis: when analytics and search compile through the same graph, the answer is not just relevant - it is provably correct, policy-aware, and traceable to the business logic that produced it.

A user prompt asking for Q3 EU revenue enters Copilot, three dotted arrows diverge to three different revenue figures - tagged NONDETERMINISTIC, with the Microsoft documentation quote beneath.
Analytics & Search

Why Power BI Copilot Delivers Wrong Answers (and What It Costs You)

Microsoft's own documentation calls Copilot nondeterministic. The diagnosis, the prep-work reality, and the architectural fix.

Read more
Two gated booths labelled Power BI Copilot and Tableau Pulse, each with its vendor's own documentation warning on a caution sign.
Analytics & Search

Power BI Copilot vs Tableau Pulse: Two Takes on AI BI, Same Ceiling

Two takes on AI BI, same ceiling - what each is gated behind, per the vendors' own docs.

Read more
A natural-language question traced through three semantic hops - filter, join, aggregate - to produce a grounded answer.
BI

Multi-Hop Query Understanding: The Deterministic Compiler Approach

When the answer requires three joins, two filters, and a definition the analyst hasn't seen yet.

Read more
Vector retrieval scattered points on the left vs. semantic search traversing a typed corporate-concept graph on the right.
Search

Building a Corporate Company Brain: Deterministic Semantic Search for Enterprise Data

Beyond vector retrieval - structural understanding of corporate data.

Read more
A LookML code box with four exit doors: your dbt project, as-code AML, spreadsheet freedom, and an autonomous graph highlighted in orange.
Analytics & Search

8 Looker Alternatives Without the LookML Lock-In (2026)

Organized by what actually replaces the modeling layer.

Read more
The 2026 AI analytics field plotted on two axes, accuracy and governance, with the compiled-and-governed dot top right.
Analytics & Search

The 9 Best AI Analytics Tools in 2026, Scored on Accuracy and Governance

Scored on the two axes that decide production success: accuracy and governance.

Read more
The same question answered by a black box with no query to inspect and a glass box with the SQL attached.
Analytics & Search

7 Power BI Copilot Alternatives That Show Their SQL (2026)

If you cannot see the query, you cannot audit the answer. The transparency ladder, ranked.

Read more
Nine semantic-analytics tools laid out in a 3x3 grid - asking who builds the semantic context. Eight answer
Analytics & Search

ThoughtSpot Alternatives: Why AI Agents Need a Semantic Compiler

An honest, sourced tour of the search-driven analytics market - nine tools on conversational fit, modeling effort, and cost.

Read more
Three business-team personas - sales, finance, ops - asking plain-language questions that compile through a shared semantic layer into governed answers and charts.
BI

Self-Serve Analytics: Why Deterministic Governance is the Missing Link

What it actually takes to put AI-grade analytics in the hands of non-technical teams.

Read more
A five step autonomy ladder with most agentic BI tools clustered on the lower steps, separated from governed autonomous execution by a compile-time governance gate.
Analytics & Search

Agentic BI Tools in 2026, Scored on Autonomy, Governance, and Reach

A five step autonomy ladder, and the step each vendor actually reaches. Most agentic BI tools stop at level 2.

Read more
The analyst job decomposed into six steps, with bars showing how many steps each tool class covers.
Analytics & Search

AI Data Analyst Tools in 2026, Scored on What They Replace and What They Can Prove

Not one vendor in the category has submitted to a public text-to-SQL benchmark.

Read more
Best text-to-SQL tools 2026 scored on accuracy and governance
Analytics & Search Updated

The Best Text-to-SQL Tools in 2026, Scored on Accuracy, Governance, and Reproducibility

Raw LLM text-to-SQL solves ~21% of real enterprise queries. The best tools close that gap with a semantic layer. Nine tools scored on what matters for production.

Read more
Conversational BI tools 2026 scored on governance and determinism
Analytics & Search

Conversational BI and Conversational Analytics Tools in 2026, Scored on Governance, Determinism, and Reach

Every BI vendor ships a chat box. The hard part is whether the answer is governed, reproducible, and correct across your estate. Copilot, Pulse, Spotter, Genie, Cortex, and Colrows scored.

Read more
Generative BI (GenBI) tools 2026 and the governed foundation
Analytics & Search Updated

Generative BI (GenBI): What It Is, and the Tools That Do It Well in 2026

GenBI generates SQL, charts, and dashboards from a question. Whether you can trust the output depends on the governed foundation underneath. The field, scored.

Read more
Enterprise text-to-SQL accuracy benchmark: the 91% to 21% cliff
Analytics & Search Updated

The Enterprise Text-to-SQL Accuracy Benchmark: Every Major Study in One Place

The same model scores 91% on a textbook benchmark and about 21% on real enterprise data. Spider 1.0/2.0, BIRD, and BEAVER in one cited table and chart. Free to reference.

Read more
Metric mismatch in BI dashboards resolved through semantic layer governance.
Business Intelligence Updated

Why BI Metrics Do Not Match Across Dashboards

Why dashboards show different numbers for the same metric, the organizational causes of mismatch, and how semantic governance centralizes metric definitions.

Read more

Stop building context twice.

One graph. Every agent compiles through it. Joins proven, policies enforced, SQL emitted.