Search

Search IconIcon to open search

BI Tools

Last updatedUpdated: by Simon Späti · CreatedCreated:

Tools of Business Intelligence, there are many.

# Tools

Here a none complete list:

  • Apache Superset: Open-source data exploration platform born at Airbnb, connects to any SQL speaking engine with 40+ visualization types and petabyte-scale query capabilities.
  • PowerBI: Microsoft’s BI platform with deepest Excel/Office 365 integration, DAX formula language, and Copilot AI baked into the broader Microsoft Fabric stack.
  • Tableau: The visual analytics pioneer built on patented VizQL technology that turns drag-and-drop actions into database queries, now part of Salesforce.
  • TARGIT: Danish BI suite (Decision Suite) focused on industry-specific, out-of-the-box analytics for verticals like automotive dealerships, heavy equipment, and airports.
  • Metabase: The “5-minute setup” open-source BI beloved by startups, pairing a no-code question builder with a SQL editor and friendly UX.
  • Kibana: Visualization front-end for Elasticsearch, purpose-built for log, metric, and trace analytics inside the ELK stack rather than traditional BI.
  • Looker: Google Cloud’s enterprise BI where LookML defines a governed, code-based semantic layer that’s now exposed to Tableau, Power BI, and AI agents.
  • Rill Developer: Fast, BI-as-code dashboards defined in YAML + SQL with an embedded DuckDB/ClickHouse OLAP engine for sub-second queries.
  • Lightdash: Open-source BI that lives directly on top of your dbt project, turning dbt YAML models and metrics into a self-serve analytics layer.
  • whaly: French self-service BI platform positioned as a cheaper Looker alternative, focused on embedding analytics into CRMs, Slack, and field-sales apps.
  • Holistics: Analytics-as-code BI with its own AMQL semantic language, Git version control, and canvas-style narrative dashboards — a modern Looker alternative.
  • Lightdash: Open-source BI that lives directly on top of your dbt project, turning dbt YAML models and metrics into a self-serve analytics layer.
  • Redash (dashboarding on top of Delta Lake): Lightweight open-source SQL-first tool — a browser-based query editor over 35+ data sources that turns queries into shareable charts and dashboards.
  • Mode: Collaborative analyst-first platform combining SQL, Python, and R notebooks with reports, now part of ThoughtSpot.
  • AtScale: Universal semantic layer that speaks SQL, MDX, and DAX natively, bringing OLAP-cube-style modeling (à la SSAS) to cloud warehouses without moving data.
  • Power BI: Microsoft’s BI platform with deepest Excel/Office 365 integration, DAX formula language, and Copilot AI baked into the broader Microsoft Fabric stack.
  • Toucan Toco: French “data storytelling” platform that prioritizes narrative-driven, mobile-first dashboards for non-technical business audiences.
  • **Evidence: BI as Code with a Markdown notebook style, rendering SQL-backed, NYT-style data reports as a static site from plain Markdown files.
  • Steep: Stockholm-based metrics-first BI where everything starts from a centrally defined metric catalog, built natively on the semantic layer (dbt Cloud, Cube).
  • Qlik: Known for its patented Associative Engine that in-memory-indexes all relationships so users can freely explore in any direction — including “unrelated” data.
  • Sigma (BI): Warehouse-native BI with a familiar spreadsheet UI over Snowflake/BigQuery/Databricks, plus Input Tables that let users write back to the warehouse.
  • Observable Framework: Open-source static-site generator for data apps, using polyglot data loaders (any language) to precompute snapshots for instant-loading dashboards.
  • Omni: Founded by ex-Looker folks, combines a governed semantic layer with spreadsheet-like and SQL workflows so analysts and business users share one tool.
  • Shaper: Visualize and share your data. All in SQL. Powered by DuckDB.

# Overview


Source


source


Origin: