I'm working on something in between a BI tool and a SQL IDE. It's definitely code-heavy on the user at the moment compared to a BI tool but an improvement on switching between Python scripts, Postman, a SQL GUI and Excel.
In spirit, but with no UI, vega js, they follow the same “grammar of graphics” idea from the same research. Altair does vega charting but in Python. Kibana is using vega in more UI fashion but I haven’t tested it. I think someone should put a proper web ui on top of vega…
I have used Vega + Jupyter a few times. As well as the Vega Viewer extension for VS Code. I haven't used it enough to be proficient and fast, but I have used it enough to know that I want to be.
PowerBI?
Apache Superset? https://superset.apache.org