Part 12: Data Analysis with pandas

Data Analysis with pandas for Finance and Accounting Welcome to post #12 in our Python journey! In the previous post, we explored NumPy and its powerful numerical capabilities. Now we’re taking a step up to pandas, which builds on NumPy’s foundation to provide specialised tools for working with tabular and time series data—exactly the kind of data we deal with daily in finance and accounting. Why pandas for Finance? pandas is specifically designed for data analysis and manipulation, with particular strengths in: ...

Part 11: NumPy Fundamentals for Numerical Data

NumPy Fundamentals for Numerical Data (with Finance Applications) Welcome to post #11 in our Python learning journey! If you’ve been following along, you’re starting to build a solid foundation in Python. Now it’s time to explore NumPy, the powerhouse library that makes Python a serious contender for numerical computing and data analysis. As a finance professional myself, I’ve found NumPy particularly useful for financial calculations, portfolio analysis, and working with large datasets. Let’s dive in and see how this library can level up your Python skills. ...

Your Finance Leadership Roadmap: Series Conclusion

Series Conclusion: Your Finance Leadership Roadmap This is the final post in my “Modern Financial Controller” series, documenting my journey from chartered accountant to strategic finance manager. Throughout this series, I’ve been learning in public and sharing insights primarily drawn from David Parmenter’s work and other finance thought leaders as I navigate this career transition. The Journey So Far Over the past eight posts, we’ve explored how the controller role has evolved from technical accounting specialist to strategic business partner. From developing meaningful KPIs to implementing rolling forecasts, from accelerating month-end close to enabling technology transformation, we’ve covered the essential elements of modern finance leadership. ...

Part 10: The Python Ecosystem & Interactive Data Workflows

The Python Ecosystem & Interactive Data Workflows As a finance professional diving deeper into Python, I’ve found that understanding the broader ecosystem of tools is just as important as learning the language itself. In this post, we’ll explore the different ways to manage Python packages and environments, and dive into interactive data workflows that can transform how you work with financial data. Package vs. Environment Managers: pip, conda, and Anaconda When I first started with Python, I was confused by the different tools available for installing packages and managing environments. Let’s clarify these concepts. ...

Technology Enablement for Modern Finance

Part 8: Technology Enablement for Modern Finance This is part 8 of my “Modern Financial Controller” series, documenting my journey from chartered accountant to strategic finance manager. I’m learning in public and sharing insights primarily drawn from David Parmenter’s work and other finance thought leaders. Introduction Technology has transformed the finance function more dramatically in the last decade than perhaps any other aspect of our work. As David Parmenter emphasises in his book “The Leading-Edge Manager’s Guide to Success,” finance leaders who fail to embrace technological innovation risk becoming irrelevant in the modern business landscape. ...