> ## Documentation Index
> Fetch the complete documentation index at: https://docs.omni.co/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.omni.co/feedback

```json
{
  "path": "/analyze-explore/index",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

# Analyze & build in Omni

> Explore data, build queries, create calculations, and optimize performance in Omni workbooks.

Omni's analysis tools are centered around [workbooks](/analyze-explore/workbook-basics) — flexible, multi-tab environments where you can query data, build calculations, and prepare results for visualization. This section covers everything you need to build analyses in Omni.

## Query data

Omni supports multiple paths for [querying your data](/analyze-explore/querying), from conversational AI to point-and-click to writing SQL directly. Every query is routed through the [semantic model](/modeling), so results respect your organization's definitions and permissions regardless of how you build them.

## Add data

Not all data lives in your data warehouse. Omni gives you two ways to bring in additional data:

* **[CSV & Excel uploads](/analyze-explore/data-input-csvs)** - Upload a file as a standalone table to use alongside your database queries, useful for data that hasn't made it into your warehouse yet or analyzing one-off spreadsheets.
* **[Input columns](/analyze-explore/input-columns)** <Badge className="badge-color">BETA</Badge> - Add editable columns directly to a query result to annotate rows inline, such as adding enrichments, scores, or notes.

## Spreadsheets

[Spreadsheet tabs](/analyze-explore/spreadsheet-tabs) bring an Excel-like environment into your workbooks. Connect spreadsheet tabs to your queries and use familiar formulas to format, reshape, and build on top of live data — without exporting or manually refreshing.

## Calculations and custom fields

Extend your queries with ad hoc logic:

* **[Table calculations](/analyze-explore/calculations)** — Use Excel-style functions to create post-query metrics like percent of total, running totals, and period-over-period comparisons.
* **[Custom fields](/analyze-explore/custom-fields)** — Create reusable dimensions and measures with custom SQL or modeled objects, including [bins and groups](/analyze-explore/custom-fields/bin-group) and [filtered measures](/analyze-explore/custom-fields/filtered-measures).

## Debug and optimize

* **[Workbook inspector](/analyze-explore/workbook-inspector)** — View the structure of your queries, copy them for use in the model, and debug issues by comparing query configuration to generated SQL.
* **[Performance optimization](/analyze-explore/performance/caching)** — Learn how Omni's caching layers and [aggregate awareness](/analyze-explore/performance/aggregate-awareness) reduce warehouse load and speed up your analyses.