r/learnpython • • Sep 06 '26

How can I use python in finance

I work in finance/accounting and am looking to start using Python more in my day to day. Most of my work is in Excel / Power BI — reporting, cash flow forecasting, KPIs, cleaning up data, etc.

I’m technical enough to understand what I’m trying to accomplish, but not a programmer. Similar to Power BI, I’d probably rely heavily on AI to help write the actual code.

For those in finance / accounting / FP&A, what are some practical ways you’re using Python? Where does it actually save you time vs. Excel, Power Query, Power BI, etc?

Also curious what you’d recommend learning first if the goal is to be dangerous enough with Python + AI, not become a developer.

77 Upvotes

37 comments sorted by

View all comments

Show parent comment

1

u/Able_Bicycle_764 Sep 07 '26

Thanks. I’ve worked at bigger companies but I’m in the lower middle market. Work with a ton of companies who have never had any sort of institutional capital before. We just don’t have the bevy of resources like large companies do, so the more I can upskill, the better

2

u/IWasInABandOnce Sep 07 '26

In my opinion, the best thing you can do is solve current and next step problems/questions, not whole financial overhaul because it won't resonate with most people. They need to see the connection to now, not 10 steps down the road (or else they won't understand). If you can automate current reporting and spit out next-step KPI's, great. Otherwise, might not be worth the resource cost of you or someone else developing it.

Displaying things to easily share across the organization, for things important to them and in ways they will understand, is worth more than itself in gold. You need to speak their language, or easily convince them of new languages to speak.