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

# For analysts

> Run ad hoc queries, build statistical models, and create recurring reports.

Sourcetable replaces the analyst stack of Excel + SQL client + BI tool + Python notebook with a single AI-powered spreadsheet.

## Example workflows

| Task | How to do it |
| - | - |
| Ad hoc data exploration | Upload a CSV or connect a database, then ask "Summarize this data and show me the key trends" |
| SQL queries without writing SQL | Ask "Show me revenue by product category for the last quarter" — the AI writes the SQL |
| Statistical testing | "Run an A/B test analysis comparing control and variant conversion rates" |
| Pivot tables and cross-tabs | "Create a pivot table of sales by region and month" |
| Recurring reports | Connect a live data source and build a dashboard that auto-updates |
| Data cleaning | "Clean this dataset — fix formatting, remove duplicates, handle missing values" |

## Key features for analysts

* **[AI chat](https://sourcetable.com/docs/ai/chat.md)** — Ask questions about your data in natural language
* **[SQL editor](https://sourcetable.com/docs/data/sql-editor.md)** — Visual query builder for connected databases
* **[Data analysis](https://sourcetable.com/docs/ai/data-analysis.md)** — Automated statistical analysis and insights
* **[Charts](https://sourcetable.com/docs/visualizations/overview.md)** — 30+ chart types with AI generation
* **[Pivot tables](https://sourcetable.com/docs/spreadsheet/pivot-tables.md)** — Drag-and-drop or AI-generated pivots
* **[Import/export](https://sourcetable.com/docs/data/import-export.md)** — Handle XLSX, CSV, Parquet, JSON, PDF, and more


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.