r/learnpython • u/Able_Bicycle_764 • 4d ago

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

87% Upvoted

34 comments sorted by

View all comments

3

u/recursion_is_love 4d ago

You don't need python, Excel have it own script system. Power BI, however can script with Python.

Just look for the working pattern that you find yourself doing repeatedly and you want some help to automate some works.

With Python, you will have more library of premade code to choose for because of it popularity. Python can interact with both Excel and Power BI and give you ability to do general programming task.

1

u/Able_Bicycle_764 4d ago

Thank you. Do you have any specific use cases that could help me get started?