[Rodeoclash]

I'd vouch for Metabase. You can create charts that can be embedded fairly easily and the enterprise version allows you to create accounts with restricted access to datasets so it can be used by your customers in a self-service style.

I pair it with AirByte to fetch data from CSV files on S3 (generated hourly), a Salesforce instance and Google Analytics which is then assembled into a central data warehouse (also Postgres).

Both Metabase and Airbyte run nicely on Elastic Beanstalk. Airbase in particular is very easy to self host, maintain and upgrade.