We (https://timeflow.systems https://timeflow.systems) use all of Metabase, Superset and heavier alternatives such as Tableau to build fairly advanced dashboard

We (https://timeflow.systems https://timeflow.systems) use all of Metabase, Superset and heavier alternatives such as Tableau to build fairly advanced dashboards for customers. Metabase is a great product. Simple to deploy and use, stable, easy for non techies and SQL analyst types. It tends to be my go-to. Superset is a great product and we are lucky to have this quality of BI tools for free. It does however have a few extra rough edges and quirks where your query doesn't render as you would expect, especially with niche databases such as Druid and Clickhouse (via a third party driver). I often find myself checking log files to see what actual SQL was issued from the front-end. It's also slightly more intimidating for end users too. Metabase is easier to deploy. I use a single binary vs (I think) a docker compose setup for Superset. Both have a cloud offering, Preset.io is the Superset one which we are just using now and having a productive time with. I would look at both Metabase and Superset before the heavier weight commercial options if the choice was purely down to product features. Tableau, Looker et al don't seem to be bring much to the table above these, and they are both quite difficult and expensive commercial organisations to deal with. With all of this said, building simple reports and dashboards over aggregated data is a fairly commodity task nowadays. Unless you are doing anything funky, all of these tools and tens of others will do the job.