Meltano spun out of Gitlab is working in this domain, I think they are making progress.
https://meltano.com/
dbt are building the transformation engine that Meltano is using (I think), and are worth keeping an eye on
https://www.getdbt.com/
In my experience the issue with this domain isn't the "one-off" analysis, but rather orchestrating the BI function across the business, maintaining the single source of truth, testing and deploying across the ETL/ELT layers. I can't speak to how well Ananas is managing these but Meltano and dbt are giving this area a lot of thought.
Things to keep on your radar:
Meltano spun out of Gitlab is working in this domain, I think they are making progress. https://meltano.com/
dbt are building the transformation engine that Meltano is using (I think), and are worth keeping an eye on https://www.getdbt.com/
In my experience the issue with this domain isn't the "one-off" analysis, but rather orchestrating the BI function across the business, maintaining the single source of truth, testing and deploying across the ETL/ELT layers. I can't speak to how well Ananas is managing these but Meltano and dbt are giving this area a lot of thought.