Data Analytics Solution
Break down data analytics barriers with AI — empower every business user to drive data-driven decisions
Why AI-Powered Data Analytics?
Data Analytics Democratization
Eliminate the SQL skill barrier, enabling every business user to perform data analysis independently
Faster Decision Making
From request to insight — reduced from days to seconds
Data Team Empowerment
Reduce repetitive data requests by 80%, freeing data teams for high-value analysis
Unified Data Semantics
MDL semantic modeling ensures consistent business definitions and calculation logic across the organization
Use Cases
FAQ
Make data analytics 'something everyone does daily'
The last decade of BI got us as far as 'the data team makes nice-looking reports'. The remaining problem: when a business user wants to drill in or slice a dimension, they're back in Excel or bothering the data team. Our data analytics solution closes that gap. MDL maps physical tables to business terms; the LLM turns one Chinese/English sentence into safety-checked SQL; results stream back with charts. Business users don't wait, don't beg, don't learn SQL. The data team goes back to building assets instead of running a ticket funnel.
Three real scenarios
Situation · HQ wants East-China trend + top-10 SKUs + WoW; five departments ask five slightly different versions daily.
Outcome · 'Revenue/margin/AOV' definitions live in MDL Cubes; a business user asks, AI returns the same-definition SQL with a WoW-tagged chart in 30 seconds.
Situation · Compliance audits pull anomalous transactions across databases with row/column permissions; DBAs won't issue ad-hoc accounts.
Outcome · Strict SQL mode rejects writes; row/column permissions bind to RBAC; auditors see only authorized rows; all queries/SQL are logged and replayable.
Situation · Production data lives in MES, SCADA, ERP; quality engineers stitch it together daily with slippery definitions.
Outcome · Yitu connects the three, MDL defines yield/downtime/work-order as business terms, engineers ask in natural language and slice by shift/line for immediate on-floor review.
Performance and scale
PG/MySQL/BigQuery/Snowflake/ClickHouse/Databricks/Trino etc.
Blind test with MDL + semantic memory enabled
Data-team ticket volume after 3 months on Yitu
From prompt to first SSE chunk
One MDL definition per metric company-wide
Connect + MDL + train business users to self-serve
How we compare
Natural-language queries; MDL keeps definitions unified.
Drag fields, write DAX; scattered logic; business users still depend on data.
Takeaway · Complementary: BI for deep reports, Yitu for daily self-serve.
MDL + semantic memory + safety policy; enterprise-grade access native.
Usually schema-in-prompt; accuracy collapses on complex JOINs and permission constraints.
Takeaway · Demo-to-production gap is exactly the semantic layer and safety policy.
SaaS or on-prem, value in 2 weeks, upgrades by platform.
Selection to alerting, all self-built; hidden long-term maintenance.
Takeaway · First-time working is easy; three years without incidents is the real cost.
Deeper details
Why MDL matters
MDL is 'business-definition source code' — defining 'revenue', 'order', 'customer' to the field level. The LLM reads MDL before generating SQL, eliminating the classic 'same metric, different answers' problem. Data teams keep their expertise; business users get autonomy — both sides do what they're better at.
SQL safety policies
All DDL/DML writes blocked by default; SELECTs pass RBAC checks with row/column controls injected before dispatch; credentials Fernet-encrypted and decrypted only at execution. Every query and SQL logged, replayable per user/role/time — supports GB/T 22239 level 3 and financial-sector audits.
Industry templates and best practice
For retail, finance, SaaS, manufacturing, e-commerce, and education, Yitu ships MDL templates and common Cube definitions; customers fine-tune and go live in 2 weeks. These templates are one of our strongest differentiators against generic tooling.
Rollout path
Week 1: connect DB, load MDL skeleton, run 3-5 high-frequency questions. Week 2: train business users, roll out in one department. Month 1: SSO/RBAC, expand to 3+ departments. Month 3+: retire 'data request' tickets, data team returns to asset building.
Start Your Data-Driven Journey
Empower every business user to perform data analysis independently