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