Open source BI tools? What are your thoughts on open source BI tools? Which ones are the best/most interesting and what are the Pros and Cons of open source BI tools?

We are in the process of selecting a BI tool to offer analytics services to various clients. We've ruled out Tableau due to its high costs, and Power BI isn't an option because it lacks support for Macs. We're seeking an affordable or open-source solution with the following features:

• Basic to intermediate visualization capabilities, with the potential to embed Python-related visualizations (for those clients that want some very specific visualization)

• Ability to connect to a wide variety of data sources.

• Capability to create both internal (private, with user access controls) and external (public) dashboards.

• Maximum compatibility across platforms, ideally based on web standards (such as HTML5).

• Easy sharing options that don't require users to download or install anything.

We are a small team of developers specialized in Data Science and Data Engineering, but we lack a background in infrastructure management (e.g., Terraform, Kubernetes, etc.). We are currently using dbt to create the tables for our dashboards.

Any recommendations or insights from your experiences would be greatly appreciated!

I'm currently looking into Grafana, Superset, Metabase, and Dash.

PS: The posts related to this topic I've found in the community are at least a few years old, so I decided to create a new one :)