License & Deployment Mix: 15 tools – 7 OSS, 6 SaaS. (OSS and SaaS counts can overlap when an open-source tool also offers a vendor-hosted edition.)
What Is Business Intelligence?
Business Intelligence (BI) refers to the technologies, practices, and tools used to collect, integrate, analyze, and present business data to support better decision-making. BI platforms transform raw data from databases, APIs, files, and cloud services into interactive dashboards, reports, and visualizations that reveal trends, patterns, and anomalies across an organization.
Unlike infrastructure monitoring (which tracks system health metrics like CPU, memory, and uptime), BI focuses on business data – revenue, customer behavior, sales pipelines, operational efficiency, financial performance, and strategic KPIs. BI platforms are designed for business analysts, data teams, and executives who need to explore data interactively, build self-service reports, and share insights across the organization.
Modern BI platforms range from code-first tools (SQL + Markdown) to fully visual drag-and-drop dashboard builders. Some specialize in embedded analytics (embedding dashboards into other applications), while others focus on semantic layers (defining business metrics consistently across the organization). The BI landscape includes fully open-source platforms, proprietary commercial tools, and managed SaaS offerings.
The information on these pages was researched by a combination of human review and large language models. To suggest an addition or correction, please contact us. Prepared by Rhodium Systems Inc., author of the ResorsIT platform — a unified IT operations management platform for IT teams and MSPs that integrates a curated suite of open-source, commercial, and SaaS applications into a single system with shared identity, single sign-on, access control, and a common audit trail. Use this catalogue only as a starting point for your own research, and review any tool carefully against your own requirements before relying on it. Catalogue data version 2026.197.
Comparison
This evaluation covers the full BI & analytics landscape, from OSS self-hosted platforms to commercial SaaS integration targets.
SSO / OIDC Comparison
OIDC is the preferred SSO protocol. The Authentik Notes column records compatibility with the Authentik identity provider.
| Tool | OIDC | SAML | SCIM | Authentik Notes |
|---|---|---|---|---|
| Metabase | Yes | No | No | Native OIDC support (OSS); Authentik as IdP; JWT embedding for SSO |
| Apache Superset | Yes | No | No | Native OIDC via Flask-OIDC; Authentik as IdP; role mapping via claims |
| Redash | Yes | Yes | No | Native OIDC and SAML; Authentik as IdP; group mapping |
| Lightdash | Yes | No | No | Native OIDC; Authentik as IdP; Google/Okta/generic OIDC |
| Evidence | No | No | No | Static site generator; no built-in auth; use reverse proxy + Authentik |
| Nocturne (Cube) | Yes* | No | No | JWT-based auth; custom OIDC integration via middleware; Authentik JWT validation |
| Metabase Pro | Yes | Yes | Yes | Full OIDC, SAML, and SCIM; Authentik as IdP; group sync; JWT embedding |
| Grafana (BI) | Yes | Yes | No | Native OIDC and SAML; Authentik as IdP; already configured in monitoring stack |
| Sisense | Yes | Yes | Yes | Native OIDC and SAML; SCIM provisioning; Authentik as IdP; SSO embedding |
| Tableau | No | Yes | Yes | SAML SSO via Tableau Server/Cloud; SCIM directory sync; no native OIDC |
| Power BI | Yes* | Yes | Yes | Entra ID (Azure AD) SSO; OIDC via Entra; SCIM via Entra; Authentik federation possible |
| Looker | Yes | Yes | Yes | Native OIDC and SAML; SCIM user provisioning; Authentik as IdP |
| Sigma | No | Yes | Yes | SAML SSO; SCIM provisioning; no native OIDC; Authentik as SAML IdP |
| Mode | No | Yes | Yes | SAML SSO; SCIM directory sync; no native OIDC; Authentik as SAML IdP |
| Preset | Yes | Yes | Yes | Native OIDC and SAML; SCIM provisioning; Authentik as IdP; inherits Superset SSO |
* = requires extension, plugin, or specific configuration
Best SSO support: Looker (OIDC, SAML, SCIM), Metabase Pro (OIDC, SAML, SCIM), Preset (OIDC, SAML, SCIM), Sisense (OIDC, SAML, SCIM)
No built-in auth: Evidence (static site; reverse proxy required)
API Comparison
| Tool | API Type | Auth | Webhooks | SDKs |
|---|---|---|---|---|
| Metabase | REST | Session token, API key | No | None official (REST-based) |
| Apache Superset | REST | Bearer token, JWT | No | Python (community) |
| Redash | REST | API key | No | Python (community) |
| Lightdash | REST | API token | No | None official (REST-based) |
| Evidence | None (static) | N/A | No | N/A (file-based) |
| Nocturne (Cube) | REST + GraphQL | JWT | Yes (webhooks) | JS (official), Python, REST clients |
| Metabase Pro | REST | Session token, API key | Yes (alerts) | None official (REST-based) |
| Grafana (BI) | REST | API key, Bearer, Basic | Yes (alerting webhooks) | Go, Python (community) |
| Sisense | REST + GraphQL | API token, Bearer | Yes (webhooks) | JS (official), Python, REST clients |
| Tableau | REST | PAT, JWT | Yes (webhooks) | Python (tableauserverclient), JS, REST |
| Power BI | REST | OAuth2 (Entra ID) | Yes (event-driven) | .NET, Python, JS (Microsoft SDKs) |
| Looker | REST | OAuth2, API key | Yes (webhooks) | Python (looker_sdk official), Ruby, JS |
| Sigma | REST | API token | Yes (webhooks) | None official (REST-based) |
| Mode | REST | API token + secret | No | Python (community) |
| Preset | REST | Bearer token, JWT | No | Python (community), inherits Superset API |
Data Connectivity
| Tool | PostgreSQL | MySQL | Cloud DW (BQ, Snowflake, Redshift) | Files (CSV, Excel) | APIs / Live Connect |
|---|---|---|---|---|---|
| Metabase | Yes | Yes | Yes (BigQuery, Snowflake, Redshift) | Yes (upload) | No (database only) |
| Apache Superset | Yes | Yes | Yes (all major via SQLAlchemy) | Yes (upload) | No (database only) |
| Redash | Yes | Yes | Yes (BigQuery, Snowflake, Redshift, Athena) | No | Yes (API data sources) |
| Lightdash | Yes | Yes | Yes (BigQuery, Snowflake, Redshift, Databricks) | No | No (dbt models only) |
| Evidence | Yes | Yes | Yes (BigQuery, Snowflake, DuckDB) | Yes (CSV, Parquet) | No (SQL sources only) |
| Nocturne (Cube) | Yes | Yes | Yes (all major via drivers) | No | Yes (REST/GraphQL API layer) |
| Metabase Pro | Yes | Yes | Yes (BigQuery, Snowflake, Redshift) | Yes (upload) | No (database only) |
| Grafana (BI) | Yes | Yes | Yes (limited; plugin-based) | No | Yes (API data sources via plugins) |
| Sisense | Yes | Yes | Yes (all major; ElastiCube import or live) | Yes (CSV, Excel) | Yes (REST connectors) |
| Tableau | Yes | Yes | Yes (all major; native connectors) | Yes (CSV, Excel, JSON) | Yes (WDC, REST connectors) |
| Power BI | Yes | Yes | Yes (all major; native connectors) | Yes (CSV, Excel, JSON) | Yes (100+ connectors, Power Query) |
| Looker | Yes | Yes | Yes (BigQuery native, Snowflake, Redshift) | No | No (SQL database only) |
| Sigma | Yes | No | Yes (Snowflake, BigQuery, Redshift, Databricks) | Yes (CSV upload) | No (cloud DW primary) |
| Mode | Yes | Yes | Yes (BigQuery, Snowflake, Redshift) | Yes (CSV upload) | No (database only) |
| Preset | Yes | Yes | Yes (all major via SQLAlchemy) | Yes (upload) | No (database only; inherits Superset) |
Query & Modeling
| Tool | SQL Editor | Visual Query | Semantic Layer | Custom Expressions | dbt Integration |
|---|---|---|---|---|---|
| Metabase | Yes (native SQL) | Yes (question builder) | No (basic models only) | Yes (custom columns) | No |
| Apache Superset | Yes (SQL Lab) | Yes (Explore UI) | No (calculated columns) | Yes (Jinja + SQL) | No (external) |
| Redash | Yes (query editor) | No | No | Yes (SQL-based) | No |
| Lightdash | Yes (SQL runner) | Yes (Explore UI) | Yes (dbt metrics layer) | Yes (dbt + custom) | Yes (native) |
| Evidence | Yes (SQL in Markdown) | No | No | Yes (expressions in SQL) | Yes (compatible) |
| Nocturne (Cube) | No (API only) | No | Yes (Cube data model – primary feature) | Yes (measures, dimensions) | Yes (compatible) |
| Metabase Pro | Yes (native SQL) | Yes (question builder) | Yes (models + metrics) | Yes (custom columns) | No |
| Grafana (BI) | Yes (SQL in panels) | No | No | Yes (transformations) | No |
| Sisense | Yes (SQL) | Yes (widget builder) | Yes (ElastiCube data model) | Yes (formulas, R, Python) | No |
| Tableau | Yes (custom SQL) | Yes (drag-and-drop) | Yes (data model, LOD expressions) | Yes (calculated fields, LOD) | No |
| Power BI | Yes (DAX, M query) | Yes (drag-and-drop) | Yes (data model, DAX measures) | Yes (DAX, Power Query M) | No |
| Looker | Yes (SQL Runner) | Yes (Explore UI) | Yes (LookML – core feature) | Yes (LookML dimensions, measures) | No (LookML is the modeling layer) |
| Sigma | Yes (SQL) | Yes (spreadsheet-like) | No (live queries) | Yes (spreadsheet formulas) | No |
| Mode | Yes (SQL editor) | Yes (visual explorer) | No | Yes (Python notebooks) | No |
| Preset | Yes (SQL Lab) | Yes (Explore UI) | No (inherits Superset) | Yes (Jinja + SQL) | No (external) |
Visualization
| Tool | Chart Types | Dashboards | Drill-Down | Geo Maps | Pivot Tables |
|---|---|---|---|---|---|
| Metabase | 15+ (bar, line, pie, scatter, funnel, map, waterfall, pivot) | Yes (interactive) | Yes (click-through) | Yes (pin map, region map) | Yes |
| Apache Superset | 50+ (extensive library including deck.gl, heatmap, treemap) | Yes (interactive) | Yes (cross-filter, drill) | Yes (MapBox, deck.gl) | Yes |
| Redash | 15+ (bar, line, pie, scatter, map, pivot, cohort) | Yes (basic grid) | No (limited) | Yes (choropleth, points) | Yes |
| Lightdash | 15+ (bar, line, pie, scatter, funnel, table) | Yes (interactive) | Yes (drill into underlying data) | No | Yes |
| Evidence | 15+ (bar, line, area, scatter, map, sankey, funnel) | Yes (page-based) | Yes (linked pages) | Yes (built-in maps) | No |
| Nocturne (Cube) | N/A (headless – provides data API; frontend renders charts) | N/A (headless) | N/A (headless) | N/A (headless) | N/A (headless) |
| Metabase Pro | 15+ (same as OSS + additional) | Yes (interactive) | Yes (click-through) | Yes (pin map, region map) | Yes |
| Grafana (BI) | 10+ (time-series focused; bar, gauge, stat, table, geomap) | Yes (interactive) | Yes (link to other dashboards) | Yes (geomap panel) | No |
| Sisense | 30+ (bar, line, scatter, funnel, treemap, sunburst, indicator) | Yes (interactive) | Yes (drill-down, drill-anywhere) | Yes (maps) | Yes |
| Tableau | 50+ (gold standard; bar, line, scatter, map, treemap, Gantt, box plot, bullet) | Yes (interactive stories) | Yes (deep drill-down) | Yes (advanced mapping) | Yes |
| Power BI | 40+ (bar, line, scatter, map, treemap, KPI, decomposition tree, custom visuals) | Yes (interactive) | Yes (drill-down, drill-through) | Yes (Bing Maps, ArcGIS) | Yes (matrix visual) |
| Looker | 20+ (bar, line, scatter, map, funnel, table, single value) | Yes (interactive) | Yes (drill into Explore) | Yes (maps) | Yes |
| Sigma | 20+ (bar, line, scatter, map, pivot, KPI, funnel) | Yes (interactive workbooks) | Yes (drill-down) | Yes (maps) | Yes (pivot tables as primary) |
| Mode | 20+ (bar, line, scatter, map, pivot, Python-rendered) | Yes (reports as dashboards) | Yes (drill-through) | Yes (maps) | Yes |
| Preset | 50+ (inherits Superset visualization library) | Yes (interactive) | Yes (cross-filter, drill) | Yes (MapBox, deck.gl) | Yes |
Collaboration & Sharing
| Tool | Scheduled Reports | Alerts | Comments | Embedding | PDF Export |
|---|---|---|---|---|---|
| Metabase | Yes (email subscriptions) | Yes (goal-based alerts) | No | Yes (iframe, static embed) | Yes (via Pulses) |
| Apache Superset | Yes (email reports) | Yes (SQL-based alerts) | No | Yes (iframe) | Yes (screenshot/PDF) |
| Redash | Yes (email subscriptions) | Yes (query-based alerts) | No | Yes (iframe, public URL) | No (screenshot only) |
| Lightdash | Yes (email, Slack) | No | Yes (space comments) | No | Yes |
| Evidence | No (static deploy) | No | No | Yes (static embed) | No (print to PDF) |
| Nocturne (Cube) | N/A (headless) | N/A (headless) | N/A (headless) | Yes (API for embedding) | N/A (headless) |
| Metabase Pro | Yes (email, Slack) | Yes (goal-based alerts) | No | Yes (interactive embedding, SDK) | Yes |
| Grafana (BI) | Yes (email, Slack; Enterprise feature) | Yes (alerting rules) | Yes (annotations) | Yes (iframe, panel embed) | Yes (Grafana Enterprise) |
| Sisense | Yes (email, scheduled) | Yes (data alerts) | Yes (discussion threads) | Yes (full SDK, white-label, iframe) | Yes |
| Tableau | Yes (email subscriptions) | Yes (data-driven alerts) | Yes (comments on views) | Yes (Tableau Embedded Analytics) | Yes (PDF, image, CSV) |
| Power BI | Yes (email subscriptions) | Yes (data alerts) | Yes (comments) | Yes (Power BI Embedded, iframe) | Yes (PDF, PowerPoint) |
| Looker | Yes (email, Slack, webhook) | Yes (condition-based alerts) | Yes (Look comments) | Yes (iframe, SDK, Actions) | Yes (PDF, CSV) |
| Sigma | Yes (email, Slack) | Yes (alert rules) | Yes (comments on elements) | Yes (iframe embed) | Yes (PDF export) |
| Mode | Yes (email schedules) | Yes (report alerts) | Yes (report annotations) | Yes (iframe embed) | Yes (PDF export) |
| Preset | Yes (email reports) | Yes (SQL-based alerts) | No | Yes (iframe) | Yes (inherits Superset) |
Embedded Analytics
| Tool | iframe | SDK | White-Label | Multi-Tenant | Notes |
|---|---|---|---|---|---|
| Metabase | Yes | No | No (OSS) | No (OSS) | Basic iframe embedding; public sharing |
| Apache Superset | Yes | No | No | No | iframe with guest tokens; limited embedding |
| Redash | Yes | No | No | No | Public URL and iframe only |
| Lightdash | No | No | No | No | No embedding support currently |
| Evidence | Yes | No | No | No | Static HTML; embed as iframe |
| Nocturne (Cube) | N/A | Yes (JS) | Yes | Yes | Headless API; full custom frontend; primary use case |
| Metabase Pro | Yes | Yes (React) | Yes | Yes | Interactive embedding SDK; full white-label in Enterprise |
| Grafana (BI) | Yes | No | No | No | Basic iframe; no SDK or white-label |
| Sisense | Yes | Yes (JS) | Yes | Yes | Full embedded analytics platform; Embed SDK; white-label |
| Tableau | Yes | Yes (JS API) | Partial | Yes | Tableau Embedded Analytics; Connected Apps; full API |
| Power BI | Yes | Yes (.NET, JS) | Partial | Yes | Power BI Embedded; App-Owns-Data pattern; Azure-based |
| Looker | Yes | Yes (JS) | Yes | Yes | Looker Embedded; SSO embed; full white-label |
| Sigma | Yes | No | Partial | Yes | iframe embedding with auth; workbook embedding |
| Mode | Yes | No | No | No | iframe embedding; limited customization |
| Preset | Yes | No | No | No | iframe; inherits Superset embedding; limited |
Best embedded analytics: Sisense (purpose-built), Looker (full white-label), Power BI Embedded (Azure-based), Nocturne/Cube (headless API)
OSS embedded leader: Metabase Pro (React SDK + white-label in Enterprise tier)
Deployment and Licensing
| Tool | License | Self-Hosted | Language | Database | Docker | Cloud Option |
|---|---|---|---|---|---|---|
| Metabase | AGPL-3.0 | Yes | Java, Clojure | H2 (dev), PostgreSQL (prod) | Yes | Metabase Cloud |
| Apache Superset | Apache-2.0 | Yes | Python | PostgreSQL, MySQL | Yes | Preset (managed) |
| Redash | BSD-2-Clause | Yes | Python | PostgreSQL, Redis | Yes | No (self-hosted only)* |
| Lightdash | MIT | Yes | TypeScript | PostgreSQL | Yes | Lightdash Cloud |
| Evidence | MIT | Yes (static) | Svelte, JS | N/A (generates static HTML) | Yes | Evidence Cloud |
| Nocturne (Cube) | MIT | Yes | TypeScript, Rust | N/A (API layer; connects to sources) | Yes | Cube Cloud |
| Metabase Pro | Proprietary | Yes | Java, Clojure | PostgreSQL | Yes | Metabase Cloud |
| Grafana (BI) | AGPL-3.0 | Yes | Go | N/A (connects to sources) | Yes | Grafana Cloud |
| Sisense | Proprietary | Yes | – | ElastiCube (proprietary) | No | Sisense Cloud |
| Tableau | Proprietary | Yes (Server) | – | PostgreSQL (internal) | No | Tableau Cloud |
| Power BI | Proprietary | Yes (Report Server) | – | Analysis Services (internal) | No | Power BI Service |
| Looker | Proprietary | No (SaaS) | – | – | No | Looker (Google Cloud) |
| Sigma | Proprietary | No (SaaS) | – | – | No | Sigma Computing |
| Mode | Proprietary | No (SaaS) | – | – | No | Mode Analytics |
| Preset | Proprietary | No (SaaS) | – | – | No | Preset Cloud |
* Redash Cloud was discontinued; self-hosted is the only deployment option.
Self-hosted OSS: Metabase (AGPL-3.0), Apache Superset (Apache-2.0), Redash (BSD-2-Clause), Lightdash (MIT), Evidence (MIT), Nocturne/Cube (MIT)
License caution: Metabase uses AGPL-3.0, which requires sharing modifications with network users. The same caution applies as noted in the Wiki & Knowledge Base and EDR / XDR evaluations.
Tools
15 tools.
Apache Superset
Apache Superset is the most powerful open-source business intelligence platform, originally created at Airbnb and now an Apache Software Foundation top-level project.
License: Apache-2.0 (OSS) · Kind: web · Deploy: native · SSO: OIDC
Evidence
Evidence is a code-first BI framework that generates polished data reports from Markdown files containing SQL queries.
License: MIT (OSS) · Kind: web · Deploy: native · SSO: none
Grafana (BI Use Cases)
Grafana is an open-source observability and dashboarding platform; this evaluation examines its use for business intelligence – querying and visualizing relational business data alongside its native time-series metrics.
License: AGPL-3.0-only (OSS) · Kind: web · Deploy: native · SSO: OIDC, SAML
Lightdash
Lightdash is an open-source BI platform built natively on top of dbt (data build tool). It uses dbt models and metrics as its data layer, meaning the semantic layer is defined in dbt YAML files rather than in the BI tool itself.
License: MIT (OSS) · Kind: web · Deploy: native · SSO: OIDC
Looker (Google Cloud)
Looker is a data analytics platform built around LookML, a proprietary modeling language that defines a semantic layer for business data.
License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: OIDC, SAML
Metabase
Metabase is the most widely adopted open-source business intelligence platform, known for its exceptionally accessible user interface that enables non-technical users to explore data and build dashboards without writing SQL.
License: AGPL-3.0-only (OSS) · Kind: web · Deploy: native · SSO: OIDC
Metabase Pro / Enterprise
Metabase Pro and Enterprise are the commercial editions of Metabase, adding enterprise features on top of the open-source AGPL-3.0 core.
License: Proprietary (proprietary) · Kind: web · Deploy: native · SSO: OIDC, SAML
Microsoft Power BI
Microsoft Power BI is a business intelligence platform for data ingestion (Power Query), modeling (DAX), and interactive visualization and sharing, tightly integrated with the Microsoft ecosystem.
License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: OIDC, SAML
Mode Analytics
Mode Analytics is a collaborative BI platform designed for data teams that work primarily with SQL and Python. It combines a SQL editor, Python notebook environment, and visual dashboard builder into a single workflow.
License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: SAML
Nocturne (Cube)
Nocturne (Cube) is a headless BI platform that provides a semantic layer API between data sources and frontend applications.
License: MIT (OSS) · Kind: web · Deploy: native · SSO: OIDC
Preset (Managed Superset)
Preset is a fully managed SaaS offering of Apache Superset, created by the original author of Superset (Maxime Beauchemin, also the creator of Apache Airflow).
License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: OIDC, SAML
Redash
Redash is a query-focused open-source BI tool that enables data teams to connect to databases, write SQL queries, and build visualizations and dashboards.
License: BSD-2-Clause (OSS) · Kind: web · Deploy: native · SSO: OIDC, SAML
Sigma Computing
Sigma Computing is a cloud-native BI platform that provides a spreadsheet-like interface for exploring and analyzing data stored in cloud data warehouses.
License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: SAML
Sisense
Sisense is a commercial BI platform specializing in embedded analytics – enabling SaaS companies and enterprises to embed interactive dashboards, charts, and analytics directly into their own applications.
License: Proprietary (proprietary) · Kind: web · Deploy: native · SSO: OIDC, SAML
Tableau (Salesforce)
Tableau is the gold standard in data visualization, widely regarded as the most powerful and intuitive visual analytics platform in the BI market.
License: Proprietary (proprietary) · Kind: web · Deploy: saas · SSO: SAML
