Mode Analytics

Mode Analytics is a collaborative data platform designed for analysts and data teams who need to combine SQL, Python, R, and interactive visualizations in a single, shared environment. By bringing together query editing, exploratory analysis, and dashboard publishing in one tool, Mode reduces the friction between data discovery and stakeholder communication.

The Mode notebook is the primary workspace for analysis. Each analysis is composed of a series of SQL queries and optional Python or R notebook cells that can reference the results of previous queries. This layered approach allows analysts to start with SQL for data retrieval and transformation, then apply Python or R for statistical analysis, machine learning, or custom data processing that goes beyond what SQL can express. All steps are saved and can be re-executed against updated data.

SQL editing in Mode includes a schema explorer, query autocomplete, query history, version history, and the ability to preview query results inline. Multiple SQL queries can be run within a single analysis, and results from different queries can be combined and analyzed in Python or R cells. Query variables allow creating parameterized analyses that viewers can customize with different inputs.

Data visualization in Mode covers standard chart types including line, bar, scatter, area, pie, heatmap, histogram, table, and map visualizations, as well as custom D3.js visualizations for teams that need fully customized charts. The chart editor is point-and-click for standard configurations and code-based for advanced customization.

Dashboards in Mode are assembled from visualizations created in analyses. Dashboard editors select specific charts from their analyses library, arrange them on a grid layout, and add text, images, and filter controls. Filters allow dashboard viewers to interactively slice the data without modifying the underlying analysis. Scheduled reports deliver dashboard snapshots via email on a defined schedule, keeping stakeholders informed without requiring them to log into Mode.

Mode Connected Charts enable linked filtering across multiple charts on the same dashboard, creating interactive analytics experiences where clicking on one chart filters all other charts dynamically based on the selected value.

The Mode community of analyses, called Mode Public, allows analysts to share their work publicly and discover analyses published by other users. This knowledge-sharing aspect of Mode has contributed to a library of reusable analysis templates for common data questions.

Mode integrates with major data warehouses including BigQuery, Redshift, Snowflake, PostgreSQL, MySQL, Databricks, and others. Connections are managed by administrators, and users access data through the authenticated connections without needing direct database credentials.