Accelerate Financial Forecasting With Dataiku

Use Cases & Projects, Dataiku Product Lauren Anderson

Financial forecasting is one of the primary and also most challenging tasks of finance teams. Using existing historical data, like balance sheets, income statements, or business data sources, financial analysts attempt to predict future outcomes.

These predictions are then used as drivers for key business decisions and business planning. In other words, they ultimately can have huge impacts on the overall company performance. Yet while financial forecasting models greatly influence strategy and policy, they’re not always as accurate as they could be. In fact, nearly 40 percent of CFOs feel their forecasts are not accurate and that the process takes too much time.

→ Get the Full Ebook: Advancing Analytics in Finance Teams

Financial Forecasting Methods: Challenges & Pitfalls

Some of the most pervasive challenges in efficiently delivering accurate financial forecasts include friction with finding data and process bottlenecks. These can be seemingly small roadblocks like getting access to the right data and ensuring it's in the proper format. But it also includes larger, more systemic problems. A big one is understanding whether the data is even accurate and fit for purpose (i.e., data quality).

Given all the potential points of resistance along the way, unfortunately, financial forecasting is sometimes more art than science. These day-to-day challenges take up precious time and resources and don't leave much room for leveraging more advanced techniques. Machine learning, for example, has enormous potential to improve the accuracy of financial forecasting. But teams need the time and tools to implement it.

Many FP&A teams aspire to improve, but they’re caught between today's issues and asks and the necessity of future improvement. Nine times out of 10, the urgency of today's issues and asks wins out over long-term advancement.

What Does Better Forecasting Look Like?

Even when teams do have time to focus on improvement, they might not have a clear path forward. CFOs feel their forecasts are not particularly accurate, as we saw above. But in that same McKinsey study, companies also report being "generally satisfied" with their forecasting processes. Where does that leave finance teams regarding what "good" looks like and the ideal processes to get there?

Financial forecasting software and technology in general, as always, is never a magic bullet. But the right tools can provide useful guardrails for introducing more efficiency and consistency into financial modeling processes.

A Financial Forecasting Template from Dataiku

Today's most advanced finance teams are transforming their forecasting processes by streamlining the data process and improving accuracy through machine learning. With Dataiku, more precise, less costly forecasts are within reach.

The financial forecasting solution from Dataiku is a plug-and-play blueprint for more efficient and more accurate reports. The ready-to-use template means that finance teams can get started in days and see results in weeks, not months. Highlights of the Dataiku Solution include:

  • The ability to enrich your forecasting approach by blending machine learning and enhancing existing techniques, improving results while reducing effort.
  • Flexible, driver-based evaluation to quickly test and select potential financial drivers from internal (e.g., headcount) or external (e.g., inflation) sources.
  • Machine learning predictions that are easy for finance teams and people on the business side to understand.
    Powerful visual analytics that clearly reveal historical and future forecasting accuracy.

How Does the Financial Forecasting Solution Work?

We interviewed the creators of the financial forecasting solution from Dataiku. John McCambridge, Business Solution Lead for FSI and Finance, and Lea Senequier, Data Scientist, dive into the details below.

Beyond the financial forecasting solution specifically, what are Dataiku Solutions in general?

[JM] Dataiku Solutions are pre-packaged projects that speed up the delivery of data, analytics, and AI use cases. They are industry- and/or business function-specific and cover a range of topics.

Dataiku Solutions can also be called a foundation, a base, or a starting point to meet a business objective. They consist of outlines that will guide the user to the completion of a data, analytics, or AI use case.

Currently, we have 29 Solutions in our catalog, both industry-specific and transversal. The most recent release is the Financial Forecasting Solution, which can be used transversally across industries in finance teams.

Of all the data and analytics use cases out there, what made the team decide to focus on financial forecasting?

[JM] It is not a secret that financial forecasting processes play a central role at every company. They support organizations worldwide in making appropriate cost management and investment decisions. The financial forecasting solution is a natural response to the general transition toward more automated and accurate analytics.

Even though generative AI and large language models (LLMs) are all the rage, most organizations still struggle with basic data processes. Dataiku Solutions, including the financial forecasting solution, can help accelerate progress on these baseline use cases to pave the way for more innovative applications down the road.

You have extensive experience in the finance space. What are some of the biggest challenges you've personally seen play out with financial forecasting?

[JM] You already saw that 40% of CFOs reported that they feel their forecasts are not accurate and that the process takes too much time. To be more specific, we can highlight three main challenges that current methods of financial forecasting exhibit:

  1. They are either time- and effort-intensive, or fast but lack business logic and insight.
  2. Scattered and unstructured data sources — this problem also contributes to the time needed to perform financial analysis.
  3. The time needed to invest in building new or improved forecasting approaches is in very short supply. And spending the time required is impossible if there is risk of under-delivery.

What did you learn from a data science perspective while developing the solution? 

[LS] To address the challenge of limited input data, typically comprising fewer than 100 data points, we did some research and adopted a methodology inspired by a paper authored by Microsoft employees.

Originally, this methodology was implemented to forecast revenues across different geographic regions or product types. It involved utilizing simple time series models to generate forecasts, which were subsequently incorporated into a regression model.

What are some of the coolest features of the solution? 

[LS] One of the coolest features of the solution is the ability to incorporate an unlimited number of drivers. Drivers are variables that can have a significant impact on the target variable being forecasted. These drivers can be specific to each time series or apply to all categories. They can be either company-specific or macroeconomic data chosen by the user in a numerical format.

How can someone get started with using the solution? 

[LS] To get started with the solution, users simply need to download and install the required code environment. They should then follow the data model schema provided in the wiki to prepare their input data. Once that is done, they can easily create an application instance and generate results with just a few clicks.

Key Benefits of the Financial Forecasting Solution  

Finance teams can use this customizable template to quickly improve and enhance financial forecasts. By blending machine learning and enhancing existing techniques, teams can improve results while reducing effort, all without requiring the involvement of highly technical data profiles. 

→ Dataiku Financial Forecasting Solution: Technical Requirements

You May Also Like

Alteryx to Dataiku: Working With Datasets

Read More

Demystifying Multimodal LLMs

Read More

I Have AWS, Why Do I Need Dataiku?

Read More

Why Data Quality Matters in the Age of Generative AI

Read More