DataStudio
DataStudio lets business users ask questions of their data in plain language and get answers they can check. A notebook, a drag-and-drop canvas, and natural-language Q&A all read and write one shared analysis graph, so a change made in one view shows up in the others. Each question is clarified, broken into steps, turned into SQL or Python, checked before it runs, and summarized in a conclusion whose numbers trace back to the source tables.
Demo scenario: student daily management at Northwest A&F University (academic warnings, overnight absences, and targeted financial aid over 7 tables: students, colleges, scores, attendance, dorm access, library, and canteen)
- 12 kinds of data sources: DuckDB, SQLite, PostgreSQL, Greenplum, MySQL, TiDB, StarRocks, Apache Doris, ClickHouse, Trino/Hive, CSV/Parquet, and Excel uploads; remote databases can be queried directly or synced incrementally to a local copy, and passwords never go into config files.
- Five-level data context (HDC): the LLM summarizes columns, tables, relationships, business entities, and the whole database, and the relevant pieces are retrieved when a question is asked.
- Checked before it runs: generated code passes a safety guardrail, a database EXPLAIN, and a 50-row trial run, and failures are fed back to rewrite it; every number in the conclusion links to its result row and source column.
- 84 canvas operators and 100+ algorithms: 11 operator groups cover cleaning, reshaping, joins, text search, statistics, charts, machine learning, and LLM steps; modeling spans classification and regression through forecasting and survival analysis.
- Reproducible by design: each step is fingerprinted by its code and upstream inputs, so unchanged results are reused, edits recompute only downstream steps, and every run can be replayed.
- People and agents on one document: teams co-edit notebooks and canvases in real time with four agents (Q&A, canvas, visualization, review) whose steps can be undone, under OIDC sign-in, three permission levels, row filters, column masking, and a full audit log.
Canadian AI 2026
arXiv
SIGMOD
ICDE
SIGMOD
NDBC
PVLDB
PVLDB
PVLDB
ICDE
SIGMOD
SIGMOD
PVLDB
ICDE
ICDE