BI Tools

Tools of Business Intelligence, there are many.

Here a none complete list divided in different categories.

# BI-as-Code

• Rill Developer: Fast, BI-as-code dashboards defined in YAML + SQL with an embedded DuckDB/ClickHouse OLAP engine for sub-second queries.
• Evidence: BI as Code with a Markdown notebook style, rendering SQL-backed, NYT-style data reports as a static site from plain Markdown files.
• 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.
• Observable Framework: Open-source static-site generator for data apps, using polyglot data loaders (any language) to precompute snapshots for instant-loading dashboards.
• Shaper: Visualize and share your data. All in SQL. Powered by DuckDB.

• 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.
• Metabase: The “5-minute setup” open-source BI beloved by startups, pairing a no-code question builder with a SQL editor and friendly UX.
• 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.

• 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.
• Tableau: The visual analytics pioneer built on patented VizQL technology that turns drag-and-drop actions into database queries, now part of Salesforce.
• Qlik: Known for its patented Associative Engine that in-memory-indexes all relationships so users can freely explore in any direction — including “unrelated” data.
• TARGIT: Danish BI suite (Decision Suite) focused on industry-specific, out-of-the-box analytics for verticals like automotive dealerships, heavy equipment, and airports.

• 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.
• Holistics: Analytics-as-code BI with its own AMQL semantic language, Git version control, and canvas-style narrative dashboards — a modern Looker alternative.
• AtScale: Universal semantic layer that speaks SQL, MDX, and DAX natively, bringing OLAP-cube-style modeling (à la SSAS) to cloud warehouses without moving data.
• Steep: Stockholm-based metrics-first BI where everything starts from a centrally defined metric catalog, built natively on the semantic layer (dbt Cloud, Cube).
• 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.

• 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.
• Mode: Collaborative analyst-first platform combining SQL, Python, and R notebooks with reports, now part of ThoughtSpot.
• Count: A collaborative business intelligence (BI) platform built around an digital canvas like Miro.

• whaly: French self-service BI platform positioned as a cheaper Looker alternative, focused on embedding analytics into CRMs, Slack, and field-sales apps.
• Toucan Toco: French “data storytelling” platform that prioritizes narrative-driven, mobile-first dashboards for non-technical business audiences.

• Kibana: Visualization front-end for Elasticsearch, purpose-built for log, metric, and trace analytics inside the ELK stack rather than traditional BI.

• Graphene: BI built for agents.

• Mosaic: An extensible framework for linking databases and interactive views.
• MotherDuck Dives: An interactive visualizations you create with natural language, directly on top of your data in MotherDuck.
• Prefect Prefab
• dbt Charts
• Claude Dashboards: Now (2026-10-08) also Claude building their own: Build live dashboards and animate explainers with Claude | Claude by Anthropic

  • Claude Dashboards connects to a data platform like BigQuery, Databricks or Snowflake, or a CRM tool like Salesforce, and is in beta on paid plans.

• see more at MotherDuck Dives

Source

source

Origin: