Solution blueprint
Conversational analytics on a semantic layer
Conversational analytics on DataNature lets business users ask questions in plain language and get governed SQL, tables and charts. Accuracy improves with metadata enrichment, vector ingestion, categorical value ingestion and careful table selection, and answers use certified KPIs from the semantic layer.
Updated
How it is built
- Enrich metadata
- Ingest vectors
- Ingest categorical values
- Select tables
- Ship
- Enrich metadataDescribe tables and columns in business language.
- Ingest vectorsEmbed documentation and examples so the agent finds the right context.
- Ingest categorical valuesTeach the agent the real values in key columns, such as product names and regions.
- Select tablesLimit the agent to relevant, certified tables to improve SQL accuracy.
- ShipUsers ask questions; answers respect their access rights.
- Voir Chat
- Natural-language questions to SQL
- Semantic Layer
- Certified views and KPIs
- Atlas
- Row and column security on every answer
- BI
- Save answers as dashboards
On this page
Why do text-to-SQL tools give wrong answers?
They guess at joins and meanings. Grounding the agent in enriched metadata, real column values and certified KPIs removes most of the guessing.
Will users see data they should not?
No. Every generated query runs with the user's own row and column permissions.
Can answers become dashboards?
Yes. Save any answer to DataNature BI.
Common questions
Can executives ask data questions in plain language?
Yes, through Voir on the semantic layer, so answers use certified KPIs.
How do we stop wrong numbers from AI?
Answers come from certified semantic views with lineage, not free-form SQL over raw tables.
Implementation details
- Write cubes as YAML in
semantic-models/cubes/: a Gold table, measures as full aggregates (SUM(net_amount)), dimensions as columns, joins and time grains. - Avoid one-to-many joins in cubes; pre-aggregate in a dbt Gold model so sums are not inflated.
- Materialize popular cubes as warehouse views and add a Refresh cubes node after Gold in the job.
- Set Cube Security predicates per role, such as
branch_code = 'KTM'. - Connect a Voir twin to the semantic layer; answers come from cubes over MCP instead of model-written SQL.
- Expose cubes to apps through the REST endpoint
/semantic/querywith an API key; queries return up to 1,000 rows.
Platform components in this blueprint
Learn more about each DataNature product and module mentioned here.
Products
See it on your own data.
Book a demoDemos and quotes are handled by Dlytica, the company behind DataNature.