[sails]

Metabase is pretty good if you have a nicely configured datawarehouse (Snowflake, Bigquery good options). If you are connecting metabase directly to your app database then you will probably run into issues trying to integrate another data set (say CRM data).

This is where it makes sense to ELT (extract, load, transform) everything into a datawarehouse, integrate the data there and transform as much as possible, and do the "last-mile" analysis in Metabase.

This is at least the theory, I've had reasonable results with metabase doing it this way, also nice in that the bulk of your logic sits in your datawarehouse, so a BI tool migration is less painful, and also possible to run dual analytics tools.

Checkout https://www.getdbt.com/ for more on the process.