I guess it will ultimately boil down to an ETL workflow and a BI tool. Most of my requirements are fairly simple so I did not want to put up with the clunkiness

I guess it will ultimately boil down to an ETL workflow and a BI tool. Most of my requirements are fairly simple so I did not want to put up with the clunkiness of a complex software. >Metabase works to some extent .. and that was enough actually. I would have continued with it if it did not crash on me all the time.