LoginSign Up
← Back to all sparks
M

Mode Analytics

ANALYTICS
Velocity2.5

Mode is converging spreadsheets, SQL, Python, and cross-source joins into one analyst surface.

business intelligencespreadsheet uicross-source joinssql editorembedded analyticsdata governance
◆Current state
Mode is making its core report editor more flexible and analyst-friendly: a native Excel-style spreadsheet mode with 70+ formulas alongside SQL and Python, a Data Mashup capability for cross-warehouse joins without ETL, a substantially overhauled SQL editor, shareable filtered URLs, and granular per-viz downloads in white-label embeds. Admin-side governance has kept pace with admin-managed refresh schedules and automated data retention policies.
◆Where it's heading
Mode is doubling down on the 'one workspace for SQL, Python, and spreadsheets' positioning at a moment when most BI tools are picking a lane. The cross-source Data Mashup is the more strategic bet — it positions Mode as a thin governance/analysis layer sitting above multiple warehouses, useful in shops with fragmented data infrastructure. White-label embedding work hints at continued investment in the analytics-for-customers segment.
◆Prediction
Expect AI/copilot features to layer onto the new SQL editor and spreadsheet surfaces (natural-language query, formula suggestion), and Data Mashup to graduate from invite-only to GA with notebook-output and CSV/Excel sources following. White-label embeds are a likely target for richer customer-facing interactivity given Mode's product-analytics-embed customer base.

◆Recent moves

  1. 1mo ago

    Native spreadsheet mode lands in Mode reports

    ⚡ SPARK

    Mode adds a native spreadsheet mode inside the report editor — 70+ Excel-style formulas, low-code prep tools, and seamless switching between SQL, Python, and grid views in a single report. Removes the export-to-Excel detour that breaks every governance story.

    View source ↗
  2. 4mo ago

    White Label Embeds : Per-Visualization Data Downloads

    White-label embeds gain per-visualization data downloads, with the active filters respected. Workspace-level toggle keeps governance simple. Targeted depth for product-analytics customers whose end-users have been asking for granular CSV exports.

    View source ↗
  3. 4mo ago

    Data Mashup enables cross-source SQL joins in one report

    ⚡ SPARK

    Data Mashup ships in early-release invite-only — SQL joins across disparate data sources (different warehouses, flat files) within a single report, backed by a cached layer for performance. Removes the longstanding 'one connection per report' constraint without requiring ETL pre-work.

    View source ↗
  4. 4mo ago

    New and Improved SQL Editor

    Major SQL editor refresh: smarter autocomplete handling CTEs and case-sensitive names, a high-contrast theme, code folding via region markers, and parallelized metadata fetching to eliminate suggestion lag. The kind of tooling polish that disproportionately improves daily-driver experience for query-heavy analysts.

    View source ↗
  5. 7mo ago

    Introducing Shareable Report Views

    Filtered report views can now be shared via URL with no expiration. Closes a long-standing collaboration gap where viewers had to re-apply filters every time. Small but high-leverage for teams operating from shared bookmarks.

    View source ↗
  6. 8mo ago

    Import Notebook files directly

    Direct .ipynb import lets analysts pull existing Jupyter notebooks into Mode without setup. A targeted bridge for teams whose Python work currently lives outside the BI tool — useful, expected, and a precondition for Data Mashup eventually picking up notebook outputs as a join source.

    View source ↗