Video | ThoughtSpot | Data visualisation | Data prep | AI & ML | Tool strategy

ThoughtSpot full walkthrough: search, Spotter AI, data modelling and live boards

ThoughtSpot surprised me — the data modelling and AI search genuinely rival anything I've seen in Tableau or Sigma.

Watch on YouTube
  • ThoughtSpot's search-based 'answer' interface replaces drag-and-drop with typed questions and keyword filters, which has a learning curve but suits AI-first workflows
  • Every asset exports to a TML (YAML) file, making dashboards and data models portable and inspectable in plain text
  • Spotter's plan mode can build a full live board from a single natural-language prompt, often faster than the manual answer-building workflow
  • The data modelling layer supports layered permissions so connection owners, model builders and chart creators can all be different people or groups
  • The query visualiser lets you dissect multi-step pre-aggregated queries, which is especially useful for debugging complex data sources

ThoughtSpot is a search and AI-driven BI platform where you ask questions instead of dragging and dropping, and it pairs that with a data modelling layer and AI assistant (Spotter) that can build whole dashboards from a prompt.

Tim went through ThoughtSpot's three-day vendor training before this walkthrough and is using a fresh trial environment with sample retail data, so some connections and permissions are not his own.

Part By Part

Onboarding and interface

The first-login flow and the overall layout for admins and everyday analysts.

  • Guided trial setup 9:02

    Signup asks for your department, industry and use case, then loads a matching dummy dataset so you land in a working environment rather than a blank one.

  • Four main areas 11:22

    As an administrator you see Insights, a data workspace, a developer area for embedding and APIs, and an admin space; most analysts only ever need Insights and the data workspace.

Search data

The canvas where you type or tick keywords to ask a question and get back a chart, equivalent to a sheet in other tools.

  • Ask instead of drag 12:20

    You type or select fields and keywords and ThoughtSpot picks a sensible chart type automatically, which replaces the drag-and-drop canvas you get in Tableau or Sigma and takes some reorientation.

  • Per-chart formatting panel 14:02

    Each answer has its own right-hand panel for switching chart type, swapping axes and adjusting formatting, scoped to that single chart rather than a shared dashboard view.

  • TML export for portability 15:16

    Every answer can be exported as a TML file, a plain YAML description of the data source, query and chart, which makes assets inspectable and movable in principle to other platforms.

  • Keyword-driven filtering 18:40

    As you type, the search suggests field names and special filter terms that let you describe aggregations and filters inline, without separate filter shelves.

Live boards

ThoughtSpot's dashboard equivalent, built by pinning saved answers onto a canvas.

  • Pinning answers onto a board 25:02

    You save individual answers first, then add or pin them to a live board; creating the live board before pinning avoids extra steps.

  • Editing returns you to the answer 28:41

    Editing a tile opens that answer in its own context rather than in place on the dashboard, so you lose the whole-board view while adjusting a single chart.

  • Cross-filtering 29:41

    You add filter controls (such as state or region) across the top of the board, and selections cascade sensibly, for instance narrowing a region dropdown once a state is chosen.

Spotter AI

ThoughtSpot's AI assistant for building answers and whole live boards from natural language.

  • Plan mode builds a full live board 31:47

    You describe what you want to analyse in a loose prompt, Spotter proposes a plan of answers, picks a relevant data source, and builds out the charts and a live board automatically, which was faster than building it manually.

  • Voice-to-text prompting 32:00

    A push-to-talk shortcut transcribes your spoken question on-device, which is handy for framing a request before Spotter acts on it.

  • Ad hoc chat for one-off questions 37:46

    Asking a simple question like what's going on with my sales returns an overview with charts, a table and key takeaways, and you can drill into a time window or pin any result straight to a live board.

  • Deterministic answers from a good model 38:04

    Because the underlying data model carries real semantics, Spotter's answers come back consistently even with loosely worded questions, rather than varying run to run.

Data workspace and modelling

Where connections, tables and data models live, which Tim rates as the platform's strongest part.

  • Models vs tables distinction 41:22

    Objects in the data workspace are marked as either plain tables or models that join multiple tables, shown with a subtly different icon, so you can tell at a glance what you are opening.

  • Visual join building 42:03

    You can inspect and build out how a model joins tables, and ThoughtSpot can also auto-generate solid base data models for you rather than requiring everything built by hand.

  • Layered permissions across roles 44:21

    The person who creates a connection can be different from who builds a model on top of it, who can in turn be different from who builds charts against that model, each with separately governed access, which supports proper governance across teams.

  • Syncing tables out to sheets 46:24

    A table or answer can be synced to Google Sheets on save or on a schedule, letting you push curated data out of ThoughtSpot for other uses.

Query visualiser

A tool for inspecting the actual query behind an answer, including multi-step pre-aggregation.

  • Dissecting complex queries 47:15

    You can see the query (and underlying SQL) that produced an answer, which is especially useful for debugging scenarios where one query pre-aggregates data before feeding another.

Developer and embedding

Where embedding and API capabilities live, briefly shown rather than covered in depth.

  • Embedding ThoughtSpot into products 48:42

    Most ThoughtSpot customers embed the platform into their own products, including the AI chat experience, so end users can ask questions without knowing ThoughtSpot sits behind it.

Worth Knowing
  • The search-based answer interface has a real learning curve if your muscle memory is drag-and-drop from Tableau or Sigma.
  • Some sample environment answers threw errors for Tim, which he attributes to the demo dataset's security setup rather than the platform itself.
  • Spotter's AI capabilities did not appear to be charged back as separate credits at the time of recording, though that could change.
  • The Analyst Studio data prep experience is described as older and may be phased out.
Use It When

Reach for this if you are evaluating BI platforms and want strong semantic data modelling plus AI that reliably builds dashboards from plain-language prompts, especially if you are open to a question-and-answer workflow instead of drag-and-drop.

How this Rollup was made provenance & method

A Rollup is drafted by AI from the video's transcript, then reviewed and edited by Tim. Everything used to produce this one is listed below (the model, the exact prompt, and the source video), so the process is transparent and reproducible.

Transcription
On-device: NVIDIA Parakeet v3 for recent videos, OpenAI Whisper large-v3 for earlier ones. The transcript never leaves the machine or gets published.
Drafting
Claude Sonnet 5 in the cloud, from that transcript.
Prompt
The exact Rollup prompt (v4) , the full system prompt, unedited.
Mode
Overview: organised by the parts of the platform, each with the capabilities covered.
Source video
Watch on YouTube
Drafted
18 October 2026 at 23:37
Reviewed & edited
18 October 2026 at 23:38 · by Tim Ngwena

Model + prompt + video is everything you'd need to recreate a Rollup like this yourself. The one thing we don't share is the transcript.

Rights. The video and its transcript are the property of TN Media Ltd. Unauthorised use or download is prohibited. © TN Media Ltd.

The Drilldown
a just-tim newsletter

Liked this? Get the honest take most weeks.

New essays about the industry as they land. My running read on what's worth your attention. By email or on LinkedIn.

5,323 subscribers and counting

or
inRead it on LinkedIn

Email via beehiiv. No spam, unsubscribe any time.