For an open source platform for business intelligence, the strongest matches are apache/incubator-superset (Apache Superset is an open-source business intelligence suite with), getredash/redash (Redash is a self-hosted analytics and BI platform with) and dataease/dataease (DataEase is an open-source, self-hosted BI platform that offers). metabase/metabase and edp963/davinci round out the shortlist. Each is ranked by relevance to your query, popularity and recent activity.
Open-source business intelligence platforms and data visualization tools for building interactive dashboards and reporting.
This project is a business intelligence suite and SQL data visualization platform used for data analysis, reporting, and monitoring. It provides a web application for exploring datasets and building interactive dashboards, complemented by a web-based SQL query editor for analyzing raw data from connected stores. The platform features a semantic data layer to define standardized metrics and dimensions, ensuring consistent data interpretation across reports. It includes a security framework with role-based access control to manage user permissions and authentication across shared dashboards. T
Apache Superset is an open-source business intelligence suite with a drag-and-drop dashboard builder, SQL query editor, role-based access control, and self-hostable deployment, covering all the key features needed as a Power BI alternative.
Redash is a self-hosted analytics platform and SQL data visualization tool. It provides a web-based SQL query editor for writing, executing, and scheduling database queries, and functions as a business intelligence dashboard for monitoring metrics via visual widgets. The platform distinguishes itself through its data source connectors, which integrate with various SQL, NoSQL, and API-based stores to retrieve information for analysis. It enables self-service analytics by allowing users to run queries with dynamic parameters and supports shared data reporting via public links or embedded dashbo
Redash is a self-hosted analytics and BI platform with a SQL query editor, interactive dashboards, and connectors to many data sources, making it a strong open-source alternative to Power BI that covers almost all of the requested capabilities.
DataEase is an open-source, self-hosted business intelligence platform designed for building interactive data visualizations and managing analytical reporting. It provides a centralized environment where users can construct dashboards through a drag-and-drop interface, connecting to diverse data sources including relational databases, data warehouses, and external APIs. The platform distinguishes itself through its focus on embedded analytics and enterprise-grade governance. It allows for the seamless integration of charts, dashboards, and management modules into third-party web applications
DataEase is an open-source, self-hosted BI platform that offers drag-and-drop dashboards, broad data source connectivity, interactive visualizations, and embedding capabilities, directly meeting the need for a Power BI alternative with enterprise governance and self-hosting.
Metabase is a business intelligence platform designed to connect to various storage systems and relational databases for data exploration, visualization, and reporting. It provides a centralized environment where users can build queries through a graphical interface or raw code, transforming raw information into interactive dashboards and charts. The platform is built to support self-service analytics, allowing non-technical team members to extract insights without requiring deep knowledge of database syntax. The platform distinguishes itself through a metadata-driven modeling layer that abst
Metabase is a self-hostable open-source business intelligence platform with drag-and-drop dashboards, broad database connectivity, interactive visualizations, SQL editor, embedding, and role-based access, making it a direct and comprehensive alternative to Power BI.
Davinci is a business intelligence and data visualization platform used for building interactive dashboards and reports. It functions as a SQL-based dashboard builder and multi-tenant analytics service that connects to databases via JDBC and CSV files to transform raw data into visual components. The platform is distinguished by its granular security model, which includes row-level and column-level permissions integrated with LDAP and OAuth2 authentication. It also provides an embedded visualization tool that allows secure, parameterized charts and dashboards to be inserted into external appl
Davinci is a self-hostable, SQL-based business intelligence and data visualization platform that provides interactive dashboards, granular role-based access control, wide JDBC/CSV data connectivity, and embedding support—directly matching the search for an open-source Power BI alternative.
Superset is a web-based business intelligence platform designed for data exploration, visualization, and interactive dashboarding. It functions as a query-driven analytics engine that connects to various SQL databases, allowing users to perform ad-hoc analysis, define virtual metrics, and build complex data visualizations through a centralized interface. The platform distinguishes itself through a robust semantic layer that transforms raw database schemas into calculated columns and virtual metrics, enabling consistent business logic across an organization. It features a plugin-based visualiz
Superset is a mature, self-hostable business intelligence platform that directly competes with Power BI, offering a drag-and-drop dashboard builder, SQL editor, broad database connectivity, interactive visualizations, role-based access, and embedding — covering nearly every feature you listed.
JimuReport is an open-source reporting and dashboard engine designed to be embedded directly into Spring Boot applications. Its core identity centers on generating data reports and full-screen dashboards from natural language descriptions, eliminating the need for manual design. The platform also provides a conversational query interface that translates plain-language questions into database queries, returning results as tables and charts without requiring SQL knowledge. What distinguishes JimuReport is its integration of AI skills that can be installed with a single command, enabling report
JimuReport is an embeddable reporting and dashboard engine with AI-powered report generation and natural-language querying, making it a legitimate BI tool—though it lacks a traditional drag-and-drop builder.
Lightdash is an open-source business intelligence platform that treats analytics logic as code. It centralizes metric and dimension definitions in a semantic layer, allowing data teams to define business metrics in YAML files version-controlled alongside data models. This approach ensures consistent, governed data access without requiring users to write SQL. Lightdash introduces CI/CD workflows for BI content, enabling teams to validate, test, and deploy analytics changes through automated pipelines and isolated preview environments. Its natural language query interface allows users to ask qu
Lightdash is an open-source business intelligence platform that defines metrics as code and integrates with dbt, offering self-hosted deployment, interactive dashboards, RBAC, and embedded analytics, though its code-first approach and YAML-driven setup may lack the fully drag-and-drop builder many Power BI users expect.
Chartbrew is a self-hosted business intelligence platform and data visualization engine designed to transform raw data from SQL databases and external API endpoints into interactive charts and dashboards. It serves as a tool for building analytics dashboards that monitor business metrics and KPIs through a privately hosted environment. The platform distinguishes itself with an embedded analytics workflow, allowing users to generate secure, time-limited shared links and iframes to display private charts on external websites. It also provides programmatic chart generation via API and integrates
Chartbrew is a self-hosted business intelligence platform that connects to SQL databases and APIs to build interactive dashboards with sharing and embedding, fitting the BI category, though it may lack some requested features like a drag-and-drop builder and RBAC.
Evidence is a self-hostable business intelligence platform that lets you build interactive dashboards using SQL and Markdown, fitting the search for an open-source Power BI alternative, though it uses a code-first approach rather than a drag-and-drop builder.
Panel is a Python data application framework used to build interactive dashboards and reactive user interfaces by connecting data visualizations, widgets, and callbacks. It functions as a reactive UI library that synchronizes application state with interface updates based on user interactions. The project distinguishes itself by offering multiple execution models, including a FastAPI-based web application server for scalable session management and a WebAssembly compiler that enables Python applications to run directly in the browser without a backend server. It also includes a specialized too
Panel is a Python framework for building interactive dashboards and data applications, fitting the business intelligence and visualization category but as a code-first library rather than a turnkey drag-and-drop platform like Power BI.
| Repository | Stars | Language | License | Last push |
|---|---|---|---|---|
| apache/incubator-superset | 73.3K | TypeScript | Apache-2.0 | |
| getredash/redash | 28.7K | Python | BSD-2-Clause | |
| dataease/dataease | 23.4K | Java | gpl-3.0 | |
| metabase/metabase | 47.7K | Clojure | NOASSERTION | |
| edp963/davinci | 5K | TypeScript | Apache-2.0 | |
| apache/superset | 73.5K | TypeScript | Apache-2.0 | |
| jeecgboot/jimureport | 8.1K | Java | GPL-3.0 | |
| lightdash/lightdash | 5.6K | TypeScript | other | |
| chartbrew/chartbrew | 3.6K | JavaScript | other | |
| evidence-dev/evidence | 5.9K | JavaScript | mit |