Workbook Agent

AI agent · Data & analytics agent · Data & analytics by Omni

Go from business questions to polished workbooks in seconds with AI.

An AI assistant for Omni workbooks that transforms natural language questions into complete data analyses with queries and charts, grounded in a governed semantic model.

Agent specs

The full spec card (context, pricing per token, modalities and more) on AntSpace. Sign up free to see the full spec card.

Category: Business Intelligence

Channels
In-app (Omni Workbook UI)
Deployment
Cloud-native architecture
Languages
English (Natural language interface)
Primary Interface
Omni Workbook UI
Supported Analysis Modes
SQL, Spreadsheet, Point-and-click
Core Foundation
Omni Semantic Layer
  • Generates full analyses from natural language prompts
  • Automatically writes queries and builds visualizations
  • Seamlessly transitions between AI, SQL, and Excel modes
  • Grounded in a governed semantic model for accuracy

Overview

Workbook Agent is an AI-powered assistant integrated into the Omni analytics platform designed to accelerate deep data exploration for business and data teams. It solves the problem of slow ad-hoc reporting by allowing users to go from a natural language business question to a polished workbook with queries, visualizations, and insights in seconds. The agent operates within the Omni Workbook UI, where it can manage tabs and organize complex multi-step analyses. A key differentiator is its grounding in Omni's shared semantic model, which ensures that AI-generated results remain consistent with organizational data standards. Users maintain full control through a multi-modal workflow that allows them to switch between AI prompts, raw SQL, spreadsheet formulas, and point-and-click editing at any time.

Exploratory Analysis

  • Natural language analysis: The agent generates full analyses from natural language business questions, including the necessary queries and visualizations.
  • Automated query writing: It automatically writes the underlying queries required to retrieve data for the requested analysis.
  • Visual analysis generation: The agent selects and builds appropriate charts and visualizations to represent the data results.
  • Insight surfacing: It surfaces key insights and summaries directly within the workbook to inform decision-making.

Workbook Integration & Control

  • Multi-modal workflow transition: Users can switch between the agent's prompt-based interface and manual SQL, point-and-click, or spreadsheet modes at any point.
  • Tab management: The agent can manage and organize workbook tabs to keep complex analytical projects structured.
  • Chat-to-workbook conversion: AI-generated chats and results can be saved directly into workbooks for further refinement and sharing.
  • Semantic model grounding: The agent operates on top of Omni's shared semantic model, ensuring results are consistent with governed metrics and logic.

What it does

  • Writes queries from natural language prompts
  • Builds visualizations automatically
  • Surfaces data insights and summaries
  • Manages workbook tabs and organization

Use cases

  • Business users ask natural language questions to generate instant data visualizations without writing SQL.
  • Data analysts use the agent to quickly draft complex multi-step analyses and then refine them with manual SQL.
  • Finance teams perform ad-hoc calculations in workbooks using AI-generated queries combined with familiar Excel formulas.
  • Product managers diagnose metric changes by prompting the agent to surface insights from live warehouse data.

Specifications

Channels
In-app (Omni Workbook UI)
Integrations
dbt; Snowflake; Google BigQuery; Amazon Redshift; Databricks; Postgres; MySQL; MotherDuck; Clickhouse; Trino; Microsoft SQL Server
Human control
Users can review and refine AI-generated queries and visualizations; Manual override available via SQL, spreadsheet formulas, or point-and-click editor at any time
Deployment
Cloud-native architecture
Languages
English (Natural language interface)
Primary Interface
Omni Workbook UI
Supported Analysis Modes
SQL, Spreadsheet, Point-and-click
Core Foundation
Omni Semantic Layer
Task Capability
Multi-step analysis and tab management
Output Formats
Queries, Visualizations, Insights, Summaries

How it works

  1. Prompt the agent: Open a workbook and enter a business question or analysis request in the natural language prompt.
  2. Automated generation: The agent plans the analysis, writes the necessary queries, and generates appropriate visualizations.
  3. Refine and iterate: Review the results and use the agent to add follow-up questions or manually refine the analysis using SQL or point-and-click tools.

FAQ

What is the Omni Workbook Agent?

The Workbook Agent is an AI assistant that turns business questions into polished workbooks by writing queries, building visualizations, and surfacing insights in seconds.

Can I edit the queries the agent creates?

Yes, you can switch into point-and-click, SQL, or spreadsheet modes at any point during your analysis.

How does the agent ensure data accuracy?

The agent is grounded in Omni's semantic layer, which defines metrics, dimensions, and business logic to ensure consistent and trustworthy results.

Can the agent help organize my work?

The agent can manage workbook tabs and organize different stages of an analysis to keep complex projects structured.

Added by AntSpace from public sources (omni.co).

Related

More AI agents by Omni