
Building An Analytics Driven Budget


Patrick Harms, AVP Data Analytics, Credit Union of America
Given the ever-increasing complexity of business, just the word “budget” is enough to make any CFO’s head spin. While forecasting for an accurate budget is never going to get less complex, there are more options than ever for making sense of all the potential factors involved. Those working at financial institutions, or in any industry for that matter, know that this year has been more challenging and that those challenges will also be present going forward. This has only added complexity to budgeting, but by using a combination of data analytics and budgeting techniques, these challenges can be overcome.
While most budgets are built under the watchful eye of the CFO, all managers should be involved as they have the best knowledge about what drives their income and expenditures. This is not always the case though. Managers may have a highlevel idea of what effect the environment will have on their budget but may not know what which factors produce an accurate forecast or what coefficients to use. At this point, a data analyst should become involved to determine what outside factors correlate to income and expenditures. These drivers will have different effects on the output and should be run through a regression model and then backtested for accuracy.
Depending on what is being forecasted, there may be many different drivers and therefore many different coefficients produced by such a model. To produce accurate and reliable forecasts, a wide scope of factors may need to be input leading to extremely complex models. At this point two things must be taken into consideration: overfitting and reasonability of inputs. Overfitting may seem simple to avoid, however many do continue to introduce inputs to models until the model is “right”all the time. As it turns out this means that the model will predict its training data correctly and nothing else. Only if the future exactly follows the past would such a model be accurate or even useful. Inputs to any model must be reasonable and relevant. In heavily regulated industries, this is not only a best practice, but also mandated by regulators. Additionally, staff performing the modelling will be thankful to not have to forecast or at least enter additional factors.
"Managers may have a highlevel idea of what effect the environment will have on their budget but may not know what factors produce an accurate forecast or what coefficients to use. At this point, a data analyst should become involved to determine what outside factors correlate to income and expenditures"
Even though statistical learning is becoming more common, not every company may have access to data analysts with statistical learning experience. Luckily, there are now several different companies that make statistical learning software that does not require coding experience or more than a basic understanding of modelling. While such drag and drop applications may not allow for as much fine tuning, they can still provide an accurate forecast for budgeting purposes and will still be more accurate than a straight-line forecast based on a gut-feeling percentage.
Technology has only made it easier to predict income and expenditures for the coming year. However, technology is only one piece of the puzzle. Uncertainty has presented itself in nearly every aspect of business. To help deal with this, it may be possible to budget certain items on a rolling basis so as to get only the most up to date and relevant inputs. Depending on the technology available, there may even be an opportunity for automating aspects of the budgeting process using inputs from the company’s operational system. In all cases, CFOs should use all resources at their disposal to create a reliable budget.
Featured Vendors
EDITOR'S PICK
Essential Technology Elements Necessary To Enable...
By Leni Kaufman, VP & CIO, Newport News Shipbuilding
Comparative Data Among Physician Peers
By George Evans, CIO, Singing River Health System
Monitoring Technologies Without Human Intervention
By John Kamin, EVP and CIO, Old National Bancorp
Unlocking the Value of Connected Cars
By Elliot Garbus, VP-IoT Solutions Group & GM-Automotive...
Digital Innovation Giving Rise to New Capabilities
By Gregory Morrison, SVP & CIO, Cox Enterprises
Staying Connected to Organizational Priorities is Vital...
By Alberto Ruocco, CIO, American Electric Power
Comprehensible Distribution of Training and Information...
By Sam Lamonica, CIO & VP Information Systems, Rosendin...
The Current Focus is On Comprehensive Solutions
By Sergey Cherkasov, CIO, PhosAgro
Big Data Analytics and Its Impact on the Supply Chain
By Pascal Becotte, MD-Global Supply Chain Practice for the...
Technology's Impact on Field Services
By Stephen Caulfield, Executive Director, Global Field...
Carmax, the Automobile Business with IT at the Core
By Shamim Mohammad, SVP & CIO, CarMax
The CIO's role in rethinking the scope of EPM for...
By Ronald Seymore, Managing Director, Enterprise Performance...
Driving Insurance Agent Productivity with Mobile and Big...
By Brad Bodell, SVP and CIO, CNO Financial Group, Inc.
Transformative Impact On The IT Landscape
By Jim Whitehurst, CEO, Red Hat
Get Ready for an IT Renaissance: Brought to You by Big...
By Clark Golestani, EVP and CIO, Merck
Four Initiatives Driving ECM Innovation
By Scott Craig, Vice President of Product Marketing, Lexmark...
Technology to Leverage and Enable
By Dave Kipe, SVP, Global Operations, Scholastic Inc.
By Meerah Rajavel, CIO, Forcepoint
AI is the New UI-AI + UX + DesignOps
By Amit Bahree, Executive, Global Technology and Innovation,...
Evolving Role of the CIO - Enabling Business Execution...
By Greg Tacchetti, CIO, State Auto Insurance
Read Also
What It Truly Means For IT Security To Bea Business Enabler
Digital Transformation 2 Requires a CIO v2.x
Leverage ChatGPT the Right Way through Well-Designed Prompts
Water Strategies for Climate Adaption
Policy is a Key Solution to Stopping Packaging Waste
Congestion-Driven Basis Risk, A Challenge for the Development of...
