While we're on the topic, what SQL-based BI tools do we all recommend? I'm in agreement wit OP that writing SQL is generally a best-practice, but I'm still a bit clueless about the State of the Art tools. Metabase? Looker? (it's still so expensive though). Something else?
It's a big canvas that multiple people can use at once, with SQL and Python, text annotations, comment threads, shapes and drawing etc.
Connects into the regular cloud database / warehousing systems.
It's great because it allows you to get the flow of data quite literally visualised on a big board and it exposes the underlying SQL so that, over time, non technical users can learn by exposure and osmosis, as things aren't super hidden away "behind the scenes".
Oh man that looks cool - BUT - $199/month for the "starter" version and $1k/month for a team prices me wayyyyyyy out on this. I am but a humble solopreneur trying to use SQL to build some nice dashboards (and not go broke while doing it).