for data science, python is great, but for BI, its a waste. I have yet to see a use case where someone used python with pandas for a process only to make it 10x more difficult than it needs to be. All the data manipulation you're doing can be done in SQL and 99.4% of the time, guess where most of your data resides? In a relational database. Keep the database manipulation at the database level and just use sql. If you're doing all your work in python, you are creating a cluster fuck of a problem if that work needs to be moved to another team and that team does not have analysts familiar with python

SSIS is cheap and can handle most ETL tasks. If you need something more advanced there are better tools out there besides using python.

If you need to automate reports, use an actual reporting tool like SSRS, power bi or tableau.

I just think you're gong to end up making life more dificult for yourself when it doesn't need to be.

I totally see the need for python in data science, but not BI