This looks a bit like https://metabase.com -- anyone used both and can make a comparison?
Curious if anyone has used Metabase for serious work and can comment on it. I tried setting it up and got frustrated pretty quickly with the UX. It looks slick, but the mental model was confusing...
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.