Operating modes
A quick answer, or a deep investigation
Datachat adapts to the nature of the question. Basic mode answers everyday questions instantly; for complex, causal questions, Deep analysis runs a multi-step, verified investigation.
1
Basic mode
For everyday questions — instantly.
- The AI only sees the table structure, never actual data — maximum data security.
- Asks for clarification when a question is ambiguous, with optional clickable answers.
- Repairs failing SQL automatically (up to 3 attempts); the user never sees the errors.
- Adds an explanation to every answer: what the data shows and how to interpret it.
- Instant chart and table, refinable in the same chat.
2
Deep analysis mode
For complex and “why” questions.
- Iterative work: the AI fetches and interprets data, asks back if needed, then delivers a summary analysis.
- You see the AI’s reasoning in real time — each step appears immediately (“Step 2: aggregating the previous and current period”).
- Investigation plan: for causal questions the AI lists which dimensions it examines (product, region, customer, period, price vs. volume).
- Sufficiency check: internal reflection verifies the data answers the question; if not, it continues automatically.
- A closing badge shows whether the analysis finished verified or remained partial.
- Python-based statistical analysis: regression, correlation, trend and forecasting — for answers deeper than SQL alone, with limited and audited data access.
- The result can be saved to a dashboard in one click.
See it work on your own data
We’ll show you a tailored demo built on your Octopus8 data warehouse. 30 minutes, no commitment.