Data for Life 2026 entry · Challenge VLTN-05
Semanio is an AI-first BI platform empowering data teams to standardize metrics and business rules, enabling everyone to query, analyze, and build reports within authorized boundaries.
Analytics Journey
Scroll to move between stepsExperience a complete workflow from the first natural language question to automated report distribution, powered by Semanio.
Type questions in natural language. The system transparently decomposes metrics, dimensions, filters, and generates governed SQL on live data.
SELECT b.branch_name,
SUM(s.revenue) AS total_revenue
FROM fct_sales s JOIN dim_branch b ON s.branch_id = b.id
WHERE b.region = 'North'
AND s.order_date BETWEEN '2026-01-01' AND '2026-08-31'
GROUP BY b.branch_name
ORDER BY total_revenue DESC;| Branch | YTD revenue | Share |
|---|---|---|
| Ha Noi | VND 235.4B | 42.9% |
| Hai Phong | VND 142.8B | 26.0% |
| Quang Ninh | VND 96.5B | 17.6% |
| Bac Ninh | VND 73.8B | 13.5% |
Illustrative interface; all figures and queries in this example are sample data used to demonstrate product capabilities.
How it works
The data team configures the structure once. Afterwards, anyone in the organization can query, audit, and create reports within governed boundaries.
Step 1: Connect data sources
Connect directly to databases (PostgreSQL, MySQL, SQL Server, BigQuery...) or ingest standardized Excel/CSV files. The system automatically profiles table schemas, detects data types, and validates structures upon connection.
Step 2: Review metrics & business rules
The data team reviews and approves metric formulas, friendly business synonyms, table relationships, and calculation logic once to ensure a single source of truth across the organization.
Step 3: Grant user permissions
Define department-specific permissions and row-level security (RLS). Business users gain self-service query and analytics access strictly within their authorized scope.
Features
Instead of stitching together disconnected tools, Semanio unifies querying, dashboarding, and report automation in one platform.
Direct connection to PostgreSQL, MySQL, SQL Server, BigQuery, Snowflake, Google Sheets... Query live in-place on your organization's existing data sources.
Easily download standardized templates for departments to fill, then drag-and-drop to upload. The system automatically validates schema, maps columns, and synchronizes in seconds.
Standardize metric formulas, analytical scopes, and access permissions. Users can review definitions, verify results, and audit generated SQL queries.
Native understanding of administrative timeframes (this quarter, year-to-date, year-over-year) and business synonyms. Multi-turn dialogue allows continuous analytical deep dives.
Ready-to-use executive analysis models: Cohort, RFM, Conversion Funnel, Waterfall, Pareto. Select your metrics and generate insights immediately without writing code.
Schedule recurring reports once, and PDF/Excel documents arrive on time via Zalo OA, Telegram, and Email. An automated background scanner flags data anomalies early.
Core difference
Most Text-to-SQL solutions let language models interact directly with physical tables. Semanio introduces a governed semantic layer for control and consistency.
Business Need
Fast self-service queries in natural language
How Semanio Delivers
Understands natural Vietnamese & English questions, synthesizes SQL across connected databases, and returns answers with charts in seconds.
Business Need
Unified metric definitions & formulas
How Semanio Delivers
Governed business semantics: standardize metric calculations, dimensional hierarchies, and permissions. Users can review definitions and inspect generated SQL.
Business Need
Granular access control & security
How Semanio Delivers
Multi-tiered role-based (RBAC) and row-level security (RLS) with full audit trails for every query executed.
Business Need
Flexible deployment & AI model choice
How Semanio Delivers
Supports private on-premise deployments and connects to multiple AI providers or internal models. Data scope sent to AI is configurable by policy.
Business Need
Automated recurring delivery
How Semanio Delivers
Schedule once for automated PDF/Excel reports delivered via Zalo OA, Telegram, and Email, with proactive anomaly detection.
Business Need
Cost optimization on existing infrastructure
How Semanio Delivers
Queries directly on existing database infrastructure and spreadsheets without requiring costly data warehouse rebuilds.
Role-Based Benefits
Semanio unites technical governance and business self-service into one trustworthy, transparent workflow.
Monitor key metrics in real time and drill into details on demand.
Having to wait until end-of-week for consolidated numbers, making proactive intervention difficult.
Real-time dynamic dashboards and automated summary briefs delivered to Zalo OA at 7:30 AM every Monday.
Self-serve queries, audit numbers, and generate reports within assigned permissions.
Needing ad-hoc data answers daily but lacking coding knowledge, while manual spreadsheets risk errors.
Natural language conversations returning charts, tables, and insights in seconds with zero hallucination.
Govern shared business definitions centrally and eliminate repetitive ad-hoc requests.
Overwhelmed by ad-hoc pull requests and needing strict consistency in metric definitions and data access.
Define metrics and business rules once via the Semantic Layer; support private deployment with configurable AI data boundaries.
Information security
Ensuring transparency, granular access control, and complete organizational control over deployment infrastructure.
Supports isolated private deployments and connects to multiple AI providers or local self-hosted models. Data transmitted to AI conforms strictly to internal policies.
Granular access control by role (RBAC), row-level security (RLS), and column-level masking. Each staff member accesses only their designated scope.
Complete activity logging: who queried what, executed SQL statements, metric definition adjustments, and report export history.
Flexible model abstraction: seamlessly switch between Gemini, Claude, GPT, or plug in open-source models deployed fully within your private network.
Data for Life 2026
The real-world challenge: Business officers and managers spend hours manually consolidating figures across disparate sources (email, Excel, multiple departments), leading to delays and errors during peak periods.
Challenge Requirement
Natural Vietnamese question and answer over data
Semanio Solution
Vietnamese-to-SQL generation with multi-turn contextual awareness
Challenge Requirement
Automated report consolidation
Semanio Solution
Auto-generated dashboards and scheduled delivery via Zalo OA, Telegram, Email
Challenge Requirement
Real-time data visualization
Semanio Solution
Direct querying against live source databases without stale staging copies
Challenge Requirement
Broad multi-source connectivity
Semanio Solution
12 database engines, Google Sheets, and standardized Excel/CSV submissions
| Challenge Requirement | Semanio Solution |
|---|---|
| Natural Vietnamese question and answer over data | Vietnamese-to-SQL generation with multi-turn contextual awareness |
| Automated report consolidation | Auto-generated dashboards and scheduled delivery via Zalo OA, Telegram, Email |
| Real-time data visualization | Direct querying against live source databases without stale staging copies |
| Broad multi-source connectivity | 12 database engines, Google Sheets, and standardized Excel/CSV submissions |
NCB Team · Digital Government & Public Services · Digital Economy · Data for Social Good
Connect your data source, declare your metrics, and run your first query in a single working session.