Video | Hex | Tool strategy | Data visualisation | AI & ML | Analytics

Hex explained: notebook-style BI for AI-driven analytics teams

Hex isn't trying to be Tableau with a notebook bolted on - it's betting that analytics should work like code, and that bet might be the right one for the AI era.

Watch on YouTube
  • Hex builds analytics around a notebook mindset, where cells of SQL/Python analysis combine into a package that powers dashboards and apps
  • Its AI agent can autonomously write SQL across multiple tables, generate calculations, and produce charts, then explain its reasoning step by step
  • The app builder lets you drag notebook outputs into a dashboard-style interface, including a lineage view showing which queries fed which chart
  • Hex doesn't lock you in - the underlying SQL and Python code remains usable even if you stopped using Hex
  • Pricing includes a $36/editor individual plan with AI agent access, five published apps, and 30-day version history, plus comparable team tiers with fewer hidden enterprise tiers

Hex is a notebook-based analytics platform where SQL and Python cells combine into a package that powers dashboards and apps, built around an agentic AI assistant that writes queries and charts for you. It suits small, code-fluent teams who want to move fast rather than organisations wanting drag-and-drop BI.

This is a first look using a trial environment with Hex's own sample dataset, not a specially arranged demo.

Part By Part

Philosophy and fit

The notebook mindset that underpins every other feature in Hex.

  • Notebook as the building block 4:21

    You build analytics as cells of SQL and Python inside a notebook-style package, and everything you build (charts, dashboards, apps) runs off that package rather than a separate BI layer on top.

  • Built for small, code-fluent teams 5:02

    Hex suits small teams where one person covers several roles and is comfortable writing SQL and Python, rather than large orgs wanting a drag-and-drop experience; its customer base of startups reflects this.

  • CI/CD-style productionising 11:24

    Because analysis starts as code, you can apply standard software practices to get it into production, rather than going through a platform's own approval and publishing flow.

AI agent

The agentic assistant that writes the notebook analysis for you from a prompt.

  • Autonomous SQL and analysis 13:46

    Give the agent a question and it spins up compute, writes SQL across multiple tables, and builds out the analysis as notebook cells without you writing queries yourself.

  • Step-by-step reasoning shown 14:40

    You can open each cell the agent created to see exactly which tables it queried and how it built towards its answer, so the process stays transparent rather than a black box.

  • Generates calculations and charts 15:20

    Beyond raw queries, the agent creates derived calculations and a visualisation cell automatically, turning a plain-language question into a chart you can inspect.

Notebook

The core editor where cells of SQL, Python and visualisations live before anything reaches an app.

  • Cells as units of analysis 15:17

    Each cell is a discrete piece of work, a SQL query, a calculation or a chart, and you stack cells to build up your analysis the way an analyst would work through a problem.

  • Three linked views 17:19

    Agent, notebook and app builder sit as tabs on the same analysis, so you can hide or bring back the agent panel while working directly in the notebook that's driving your insight.

    My video on: App builder
  • Write raw SQL or Python directly 20:22

    You can write your own SQL query or Python script directly in the notebook, alongside pivot tables and parameters, giving you the raw capability to shape data exactly as needed.

App builder

Turns notebook outputs into a shareable, dashboard-style interface.

  • Classic or generative app building 18:01

    You can build the app manually (classic) or describe what you want and let AI assemble it (generative, in beta), similar to natural-language app building seen elsewhere.

  • Drag notebook outputs into an app 19:00

    You can take any chart or table built in the notebook and drag it into the app builder to assemble a dashboard, choosing fields like size and colour for each visual.

  • Standard dashboard mechanics 22:04

    Once in the app builder you get familiar dashboard behaviours, dragging and rearranging elements and adding tabs for multiple pages of analysis.

  • Lineage view 23:08

    A lineage view shows which SQL queries fed which chart, so you can trace an app's visuals back to the exact analysis steps that produced them.

No lock-in

The underlying code remains yours independent of the platform.

  • SQL and Python stay usable 20:49

    Because the BI layer sits on top of code you wrote or the agent wrote, if you stopped using Hex you would still have the working SQL queries and Python scripts behind your analysis.

Organisation and sharing

How projects, apps and analyses are grouped and distributed.

  • Sharing controls 25:21

    Apps can be shared to individuals or groups, or embedded, so finished analyses become things others can browse and use.

  • Projects, threads and favourites 26:01

    Your home page lists individual projects, discussion threads, data connections and favourites, giving a simple way to navigate your own work.

  • Collections 26:21

    Collections let you group assets from different projects together to form a bigger story, though this appeared to be an enterprise-tier feature not available in the trial.

Pricing and templates

How Hex is packaged and what's available to start from.

  • Individual plan 12:25

    A $36-per-editor individual plan includes AI agent access, five published apps, 30-day version history and compute, enough for a solo analyst to get going.

  • Team pricing without hidden tiers 13:02

    Team pricing is comparable to other BI platforms but gives you more out of the box, without the secretive enterprise tiers seen elsewhere.

Worth Knowing
  • The notebook-first approach means you often need to think in terms of which SQL queries to run before anything appears, unlike drag-and-drop tools where connecting data does more of the work for you.
  • Context studio and collections appeared to require an enterprise-level licence not available in the trial environment used here.
  • Setting up a representative demo environment took noticeably longer than with other platforms, since you're building the way Hex wants rather than dragging and dropping.
  • The product's own prompts increasingly nudge you away from manual app building towards letting the AI agent do it, suggesting Hex's own roadmap favours agentic building over classic.
Use It When

Reach for Hex if you're a small, SQL-and-Python-fluent team that wants to move fast and ship analysis as both notebooks and apps without heavy platform overhead. It's less suited to teams wanting a purely drag-and-drop BI experience or to large organisations needing tightly governed publishing flows.

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:36
Reviewed & edited
18 October 2026 at 23:36 · 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.