crunch-time-data-banner

Perspectives

The CFO guide to data management strategy

Modernizing data infrastructure with data management tools

This section is an infogram

This message and the space it occupies will not be displayed when viewing this page either in Live, Preview, or "View as published" modes

Cutting through the noise

As companies generate more and more data each day, finance teams have seemingly limitless opportunities to glean new insights and boost their value to the business. But if it were easy, everyone would do it. The problem is, the amount of data emanating daily from various sources can be overwhelming. In our Finance 2025 series, we call this the data tsunami. To manage it, businesses need a data management strategy for collecting, processing, and acting upon reams of information.

Transitioning to a cloud-based ERP is one way to tackle the problem. We’ve covered this approach in depth in other Crunch time reports. But many data challenges can be addressed throughout the enterprise with simpler or more targeted solutions—and that’s the focus here.

The CFO guide to data management strategy

Getting a handle on your data:

Financial planning

Shift from spreadsheet models and intuition to automated, analytic-based models

Integrate cloud planning systems with data lakes to address combined internal and external data needs

Ensure consistent data categories and federated aggregation processes from the corporate core

Finance operations

Create hierarchies that can handle evolving management, financial, and regulatory reporting

Streamline workflows and automate reconciliations across sources to increase journal entry traceability and audit responsiveness

Leverage advanced analytics using machine learning for exception and risk identification

Decision support

Clarify data definitions across business units, geographies, and source systems

Unlock insights using a big data or cloud-based data-staging environment so data is accessible anywhere it resides, including the ERP

Create interactive reports that let users drill down through multiple layers of information

Leveraging technology in finance transformation

Advances in digital technology offer CFOs new options in data management—particularly when your current systems are not on speaking terms. Cloud-based architecture can organize and reassemble data on the fly. Advanced analytics tools let you draw conclusions from data points spanning multiple platforms. Machine learning and AI can apply controls and monitor risks—enabling course corrections in real-time.

Here are some ways Finance and IT, across diverse industries, are leveraging technology to extract more value from the data they collect.

Health care: Linking tabular product and contract data with an invoice and purchase-order data to detect spend and savings patterns   Automotive: Using a tool called CogniSteward™ to create business dashboards based on data from Excel and other sources
Consumer products: Using analytics to gain new insights from marketing spend and sales performance data, resulting in more targeted marketing programs   Aerospace: Deploying another tool—CogX—to extract data from engineering drawings and store it in Excel, facilitating new business insights
Banking: Applying quantitative techniques to understand correlations between business performance, macroeconomic conditions, and internal results   Energy: Allowing data quality queries to be plugged directly into CogniSteward so the tool could perform consolidated data analysis, match, and merge for future M&A
Asset management: Using analytics to enhance all-in profitability analyses across the enterprise, enabling leaders to pinpoint what’s truly driving performance   Cable: Employing sparse matrix algorithms to simulate the effects of data outages from 15 minutes to 12 weeks, producing predictions within 12 to 18 seconds of actual viewership
Payment processing: Leveraging machine learning to spot new patterns and formulate rules for automating cash-allocation categorization   Food service: Using CogniSteward to integrate customer data across systems and apply machine learning based clustering algorithms to identify overlapping customers
 
In short, digital tools and techniques are fundamentally changing how Finance gathers and consumes data—and enhances its value to the business.
 

This section is an infogram

This message and the space it occupies will not be displayed when viewing this page either in Live, Preview, or "View as published" modes

So you’re ready to improve your data. Now what?

If you want to improve the quality of your data and boost Finance’s core capabilities, start with solutions using your existing systems, with an eye toward eventually automating and enhancing how your data is developed, delivered, and consumed. Follow these six steps, and you’ll be on your way.

${tab-1-img-alt}

Decide what insights you need to run the business. What questions do you need answered and what metrics help answer those questions? This may involve financial results or nonfinancial information related to employees, customers, products, market conditions—basically anything that can affect business outcomes.

${tab-2-img-alt}

Consider the data management tools available to collect, manipulate, analyze, and deliver necessary information. Getting your desired data to refresh automatically in real time is the ultimate goal. But in the near term, see what you can gather manually. Start with no more than 10 business questions initially so you can create visualizations of important results and explore relationships across data points. Once you begin automating your data, you can layer in more components to flesh out the picture.

${tab-3-img-alt}

Align your leadership team. All key parties need to agree on what will be measured, how it will be defined, who owns it, who will be accountable for producing it, and the business mandate being addressed. At heavily matrixed companies, getting everyone on board is no easy feat, but taking the time to do this up front is crucial.

${tab-4-img-alt}

Build your data ecosystem, working toward enabling automated data feeds, data set integration, true self-service capabilities, and new tools for insight-driven decision-making. Set your priorities based on business value and ease of implementation. Then start small with something manageable. Test out a concept in one market or line of business, create a prototype, and socialize your idea to gauge support. Be sure to involve the people who will be using the new capability you plan to introduce.

${tab-5-img-alt}

Equip your workforce. A data ecosystem based on next-generation digital technologies will demand new or enhanced workforce skills and capabilities, such as storytelling with data, problem-solving using advanced analytics, and business partnering. Consider ways to build or buy the talent you’ll need.

For more on this topic, see Crunch time: The finance workforce in a digital world
${tab-6-img-alt}

If it’s feasible, test different approaches in different markets. This will let you compare results to gauge what’s best for the company long term. Yes, there’s an expense associated with doing that. And yes, it may add to the overall timeline. But the downside pales in comparison to the cost of rolling out a company-wide data management tool that proves wrong for the business.

And yes, it may add to the overall timeline. But the downside pales in comparison to the cost of rolling out a company-wide data management tool that proves wrong for the business.

The last word

For any business, big or small, achieving desired outcomes starts with good data. And new tools using artificial intelligence, machine learning, natural language processing, robotic process automation, and other emerging technologies can automate data management and improve data quality—better and faster than ever before.

You don’t need to spend a fortune to reap the benefits, and you don’t need to tie up your resources for years. Instead, set your priorities, explore your options, and take small steps you can build on over time. With a little poking around, you might be surprised at what’s possible.

Explore other Crunch time reports and case studies

Explore other reports and guides in our Finance in a Digital WorldTM Crunch time series, and read case studies about digital transformation in the finance function.