Show Notes

How is Microsoft using AI to reach up to 99% accuracy in some forecasts? In this episode of FP&A Today, Daniel Sousa-Lennox Mejía, a data scientist at Microsoft with deep experience of financial analysis, reveals all.

The Microsoft’s finance team – about 5000 people – saw its first foray into machine learning in forecasting. The team developed FINN (or Microsoft Finance Time Series Forecasting Framework) says Sousa-Lennox who sits within the finance organization, providing software engineering and data science expertise. Using machine learning and creating AI finance tools (such as FINN which has been open-sourced) Sousa-Lennox says the Microsoft finance team has replaced burdensome forecasting and Excel heavy lifting.  "The tool has helped, for instance, this one team in terms of accuracy to get the revenue that they were trying to forecast for an Azure product (the cloud computing platform run by Microsoft) to 99% accuracy".  But Sousa-Lennox adds that it is important to remember that AI is not "magic" and "wont lead to 99% in every single forecast" and the quality of data is paramount.

Nevertheless, the results are transforming financial forecasting at the $2 trillion company.

FINN alone provides access to 25+ models supporting Microsoft’s daily, weekly, monthly, quarterly, and yearly forecasts, transforming the approach of FP&A.

Sousa-Lennox says: “It takes on average for a forecast used run using our tool, it takes about an hour to an hour and a half, which is significantly less than a week [previously]. It is also an hour and a half where you don’t have to be actively doing anything.”

In this episode Daniel Sousa-Lennox shares:

• Similarities and differences between FP&A in US and Panama (and banking vs Microsoft)

• Getting  an internship to full-time career at Microsoft

• How he trained in Data science and technology

• How to evangelize finance teams into adopting AI

• How Microsoft is transforming its forecasting and FP&A

• Despite its success why AI is not a “magic bullet” for finance

• The two most powerful lessons in presenting AI to finance teams

• The biggest advice for anyone starting in FP&A

• Last thing finance thing I Googled ChatGPT’d

• My favorite Excel function

YouTube Video

Read the Transcript

Show Links

FINN (Open-sourced by Microsoft): https://microsoft.github.io/finnts/

• Follow Daniel Sousa-Lennox Mejía

• Follow Paul Barnhurst on LinkedIn

• Follow Datarails on LinkedIn

• Follow FP&A Today

The #1 FP&A Community (Slack) Join here - A global community and resource hub for modern FP&A leaders like you.

FP&A Today is brought to you by Datarails.

Earn CPE credit through Earmark for listening to this episode.