Analytics Studio

Free, open-source, embeddable analytics for React — without the BI vendor

Analytics Studio is a free, open-source, drag-and-drop business intelligence platform that runs entirely in your browser. Drop in a CSV, Google Sheet, or Excel file and build pivot tables, 26 chart types, KPI dashboards, and scheduled PDF/Excel reports — with no backend, no database, and no data leaving the browser. It is the hosted demo of Analytix, the open-source analytics builder published on npm as @gridstorm/analytix-* under the MIT licence.

View the source on GitHub →
13 npm packages, all MIT
$0 per-developer cost
424 ms pivot on 1M rows
312 automated tests

What Analytics Studio does

Drag-and-drop pivot, charts, and KPI canvases

Compose dashboards visually — no SQL editor, no formula language, no data modelling. 26 chart types, cross-widget filtering, a snap-to-grid freeform canvas, and undo/redo.

Offline AI insights — no API key

Trend, anomaly, correlation, segment, and forecast detectors run locally in TypeScript and narrate findings in plain English. An optional LLM provider can add richer summaries.

Connect any data source

CSV, REST, WebSocket streaming, Google Sheets, Excel, and an in-browser SQL engine (SELECT, WHERE, GROUP BY, ORDER BY, LIMIT) — all with zero-config schema inference.

Real PDF and Excel reports

Compose multi-section reports and export real PDF files (pdf-lib) and real .xlsx workbooks (SheetJS), on demand or on a cron, interval, or one-time schedule.

Real-time streaming

WebSocket batches with auto-reconnect and page-visibility-aware refresh keep dashboards live without thrashing the browser.

React, Vue, and Svelte

A full React component library plus Vue 3 composables and Svelte stores. The engines are framework-agnostic TypeScript.

How Analytics Studio compares

CapabilityAnalytics StudioTableauPower BIMetabase
Embeds natively in a React appYesNoiframeiframe
No SQL modelling requiredYesNoNoNo
Offline AI insightsYesNoPaid add-onNo
Real PDF + .xlsx exportYesYesYesYes
Data stays in the browserYesNoNoNo
Self-hosted, MIT licensedYesNoNoYes
Per-developer priceFree$999/yr$10/user/mo$500+/mo

Who it is for

Frequently asked questions

What is Analytics Studio?

A free, open-source, drag-and-drop BI and analytics platform that runs entirely in the browser. It is the hosted demo of Analytix, the open-source analytics builder on npm (@gridstorm/analytix-*). No backend, no database, and your data never leaves the browser.

Is it free?

Yes — all 13 packages are MIT-licensed and free for unlimited developers and deployments. There is no paid tier.

Do I need a server, backend, or database?

No. Parsing, pivoting, charting, SQL, AI insights, and exports all run client-side in the browser.

Does my data leave the browser?

No. Everything is processed locally; nothing is uploaded to a vendor server.

What chart types are supported?

26 — including bar, line, area, scatter, bubble, pie, donut, radar, heatmap, treemap, funnel, gauge, waterfall, box plot, violin, and sankey.

Can it export PDF and Excel?

Yes — real PDF files via pdf-lib and real .xlsx workbooks via SheetJS, on demand or on a schedule.

Does it support SQL?

Yes — an in-browser SQL engine supporting SELECT, WHERE, GROUP BY, ORDER BY, LIMIT, and aggregate functions. Joins and subqueries are not supported.

Does it include AI?

Yes — an offline insight engine (trend, anomaly, correlation, segment, forecast) that narrates findings in plain English with no API key. An optional LLM provider can add richer narrative.

Which frameworks does it work with?

React (full component library), Vue 3, and Svelte. The engines are framework-agnostic TypeScript.

How is it different from Tableau, Power BI, or Metabase?

It embeds natively in React (no iframe), needs no SQL modelling or backend, is MIT-licensed and free, runs in the browser, and keeps all data on the client.