If you're looking for something free, open source, selfhosted, or doesn't require programming knowledge (but allows SQL if needed), there's Metabase: https://metabase.com/
Thank you for your work! Metabase has been a tremendous help in getting my coworkers interested in data and analytics, and is probably the sole reason why our call center is finally registering data in a structured and organized way.
Metabase is great but try as I might, I cannot get it to connect to a Postgres database over SSL. So... I'm using Redash instead, where it was easier to make that happen.