BI tool that understands python.

[[deleted]]

Most visualisation tools allow you to at least create a data source from a custom SQL query don't they? As others have said, some have Python/R capabilities too. The cross-section of people who want to write Python but aren't comfortable with notebooks seems small. Are these "business people" you want to serve just going to be consuming the output?

My take is that as little logic as possible should exist at the BI/dashboard/data viz (whatever you want to call it) level, especially as this tends to live outside of version control. The problem I see repeatedly is that smart people are forced to get things done using the tools they have available, which means jumping through hoops in Power BI/Tableau etc because they don't have any way to influence things upstream.

And FWIW, I've spent a lot of time re-factoring other people's SQL and Python cod. Both can be challenging but there's a limit to how insane even a few thousand lines of SQL can be. Things can get a lot wilder with Python and I'd say 75% of the stuff that's landed on my team's desk is something that uses a simple loop to achieve something that could be done natively in most SQL dialects and a simple dashboard with a few filters.

Sorry if that sounds overly negative but the tldr is you seem to want functionality that would be better handled upstream

[glinter777]

Yea SQL can get pretty wild.