Power Query for analysis

So I'm currently a clerical officer and have been for over 15 years. I recently started to look into jumping over to a data analyst career as it seems like a logical progression.

I'm proficient with Excel, SQL, PowerBI and Power Query. I've been learning how to use Pandas for a while now and I can certainly see how useful it can be, and I know it's much more powerful computationally, but I can't really see anything that can be …

analysis analyst career data data analyst datascience excel look pandas power powerbi query sql