Olambus
Start free →

DocsAnalyze

Analyze

Query the cleaned table with SQL, Python, or R. Optionally describe what you want in plain English and generate a starter script.

Open Analyze

Choose Analyze in the pipeline (⌘/Ctrl+3). Pick a language with the toggle: SQL, Python, or R.

Analyze editor with language toggle

Write and run a query

  1. Enter your statement or script in the editor.
  2. Run with Run query, Run Python, or Run R (or ⌘/Ctrl+Enter). To run only part of the editor — useful when you have multiple statements — select the text and use Run selected (⌘/Ctrl+Shift+Enter). The button shows Running… while the job is in flight.
  3. Inspect the result table below the editor.

Runtimes: SQL and Python run locally in the browser when possible (DuckDB-WASM and Pyodide) for near-instant results, with a server fallback if the local engine is unavailable. R runs as a server-side language job. Prefer SQL for fast tabular cuts; use Python when you need pandas or custom logic.

Describe in plain English

  1. Use the bar labeled something like Describe in plain English…
  2. Choose Generate to draft SQL/Python/R from your prompt.
  3. Read the draft carefully, edit if needed, then run it. Treat generated code like any other code — verify results before exporting.
NL generate bar above the editor

Send results to Visualize

When a result set is ready, use Visualize to open the chart builder with that data. You can also open the Visualize step directly from the pipeline.

Tip: Keep analysis reproducible — leave a short note in Notes (status bar) about the question you answered and the query you trust.

Next

Build charts in Visualize.