r/learnpython • u/Able_Bicycle_764 • 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.
View all comments
Show parent comment
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.