Use Cases · Knowledge Retention
The real knowledge was never in the docs. It lived in a senior analyst's head — which tables matter, why a filter exists, how a metric is really defined — and in notebook comments and Slack threads no one else can read. When they give notice, onboarding their replacement means re-deriving all of it from scratch. Spotonix is the AI analyst that interprets before it queries: it resolves a business question into a plan you approve, then writes that accepted definition to the Context Graph — so the meaning persists when the person doesn't.
The alternative
Every team already has a plan for this. None of them actually move the knowledge from one analyst's head into somewhere the next analyst can use it.
Short tenure
Analysts rarely stay long. Just as someone has internalized the data landscape — the joins, the caveats, the definitions the business actually trusts — they move on, and the mastery resets. The cycle repeats with each hire.
Tribal knowledge
What matters isn't in the wiki. It's in notebook comments, ad-hoc queries, and the mental model one person built over many months. A two-week notice period doesn't transfer any of it — and a handoff doc captures a fraction.
Onboarding from zero
The next analyst rediscovers the same tables, redefines the same metrics, and re-derives reasoning their predecessor had already settled — because there was nowhere durable for it to live. Months go to relearning, not new analysis.
Cost of delay Every resignation you weather without a place to keep accepted definitions, another slice of how your business reads its own data leaves the building — and the next hire pays to rebuild it.
The outcome
Accepted plans and Answers become a shared asset in the Context Graph, so a departure is a staffing change — not an evaporation of how the business understands its data.
01
Each accepted plan records the Segments, Calculations, and Analysis Patterns behind an answer — and why. What used to live in one analyst's head becomes a durable definition in the Context Graph.
02
The next question resolves against definitions your team already approved instead of being re-derived. Where approved interpretations are persisted and retrieved, the team stops re-teaching the same business language.
03
A replacement analyst asks in plain language and gets answers composed from the institutional knowledge already in the graph — ramping on the analysis that's new, not rediscovering what the team already settled.
How it works
Intent Algebra resolves the Segments, Calculations, and Analysis Patterns in a business question into a visible plan. Where the meaning is ambiguous, it surfaces the ambiguity and asks — capturing the intent the analyst would otherwise hold in their head.
Once you approve the plan, Spotonix generates SQL from it and validates it against the accepted bindings before execution. The definition is now explicit and reviewable — not a query buried in someone's notebook that only its author could explain.
The accepted definition and Answer persist and can be retrieved on later questions. Institutional analytical memory becomes an asset the company holds — instead of one that resigns with its author.
Representative questions
Each of these resolves against accepted definitions in the Context Graph, so the interpretation is visible and traceable — no matter who asks, or who's already left.
“How do we actually define an active customer for the exec report?”
Segment Active customers Calculation Activity window Pattern Exec-report definition
“Why does our revenue figure exclude these accounts — and where's that rule?”
Segment Excluded accounts Calculation Reported revenue Pattern Exclusion rule
“What was the logic behind last quarter's churn cut, so I can rerun it?”
Segment Churned cohort Calculation Churn rate, QoQ Pattern Prior accepted plan
Proof
Retention here is a behavior you can watch, not a claim. Approve a plan, then ask a related question and see it resolve against the definition you already accepted. Worked traces use the public TPC-DS schema (illustrative). Design-partner engagements are underway.