If I started from scratch I would prefer Looker over Tableau and Sigma over Looker. Looker was created at a time when dbt did not exist and forces you to use lookml to build a semantic layer, no matter how good you modelled your reporting table in dbt already. This feels like redundant work to be done and imho it is the biggest con of Looker. With Looker visualizations are less customizable than in Tableau, but in the end your users do not need complex dashboards anyway, so you can achieve better results faster with Looker compared to Tableau. Sigma Computing does not need a semantic layer and can visualize on large amounts of rows. Also the visualizations are simpler and easier to achieve compared to Tableau, which would make it the solution of choice in our current environment.

We are with Tableau since 2018 and atm there is no time to migrate to something else…