Analytics Studio
Visual Data Analytics & BI Platform
Beta · v0.2.0 · MIT licensed
Visual Data Analytics & BI Platform
Drag-and-drop analytics builder powered by GridStorm. Create pivot tables, 26+ interactive charts, KPI dashboards, SQL queries, and scheduled reports — all in the browser, no backend required.
Key capabilities
- Drag-and-drop pivot builder — group, aggregate, filter visually
- 26+ chart types: bar, line, scatter, radar, heatmap, treemap, sankey & more
- In-browser SQL engine — SELECT / WHERE / GROUP BY / JOIN, no server
- KPI dashboard with auto-thresholds and alert rules
- Scheduled report designer — export PDF / Excel on a cron schedule
- Vue & Svelte adapters — embed analytics in any framework
- AI natural-language query parser (regex-based, zero API key)
- Full responsive layout — works on desktop, tablet, and mobile
Resources & quick links
What is Analytics Studio?
Analytics Studio is a drag-and-drop business-intelligence builder that runs in the browser, powered by the GridStorm engine. You connect data, drag fields into a pivot builder, and get pivot tables, 26+ interactive chart types, and KPI dashboards — without standing up a backend or writing application code.
It is currently in Beta. The data model, pivot builder, charting, and the in-browser SQL engine (SELECT / WHERE / GROUP BY / JOIN) are all functional today; we are actively expanding connectors, the scheduled-report designer, and the natural-language query parser ahead of a stable release.
How it works
- Bring your data. Load tabular data into the browser. Analytics Studio infers a schema and makes the fields available to the pivot builder and SQL engine.
- Build visually. Drag fields to group, aggregate, and filter. Switch between 26+ chart types — bar, line, scatter, radar, heatmap, treemap, sankey, and more — or compose a KPI dashboard with threshold-based alerts.
- Query and share. Run SQL directly in the browser for ad-hoc analysis, then export to PDF or Excel — manually or on a schedule via the report designer.
When to use Analytics Studio
- Embedding self-service analytics inside a SaaS product without a separate BI backend.
- Internal KPI dashboards with auto-thresholds and alert rules.
- Ad-hoc data exploration using in-browser SQL, no database connection required.
- Cross-framework embedding — React, plus Vue and Svelte adapters.
Limitations & honest trade-offs
- Beta: APIs and the report-scheduling features are still stabilising and may change between releases.
- The in-browser SQL engine supports a practical subset (SELECT / WHERE / GROUP BY / JOIN); it is not a full database replacement.
- The natural-language query parser is regex-based (no external AI API), so it handles common phrasings rather than arbitrary free text.
Frequently asked questions
Do I need a backend or database?
No. Analytics Studio runs in the browser and processes data client-side, including its SQL engine. You can wire it to your own data sources, but nothing is required server-side to get started.
It says Beta — is it safe to use?
It is functional and we publish it openly, but expect occasional API changes before the stable release. Pin a version and read the changelog if you adopt it in production.
What is it built on?
The same GridStorm engine that powers our data grid, which is how it handles large datasets and pivoting efficiently in the browser.
Tekivex · open-source enterprise developer tools · MIT licensed · Products · Use Cases · About · TekiVex UI