Agents Lookup

Use cases / Data & analytics

Notebook agent that writes and runs analysis cells

An agent in a data notebook writes SQL and Python cells, runs them and builds charts, while the analyst checks each step.

DifficultyBeginner
Setup timeUnder 1 hour
CategoryData & analytics

The use case

Analysts spend a lot of an investigation writing boilerplate queries and charts. Hex's Notebook Agent works inside a project: given a question, it searches the data, writes SQL and Python cells, runs them, fixes errors, and builds charts. Hex also offers Threads for non-technical users to ask questions in chat. Because the work lands as visible cells, the analyst can read and edit every step. The analyst still checks the logic and assumptions, and shared apps or reports get reviewed before stakeholders see them.

Example workflow

  1. Open a project and describe the question
  2. Agent writes and runs cells
  3. Review queries and intermediate results
  4. Edit or redirect the agent where needed
  5. Publish the final app after review

Tools

Risks and guardrails

Sources

Written by Agents Lookup. Credits and official pages for the tools this use case names: