Harness the power of data analytics to optimize your internal audit function

    Today’s chief audit executives face unique challenges stemming from the frenetic pace of market changes, emerging technologies, and other environmental dynamics. While cybersecurity, privacy, fraud, and third-party risks are obvious vulnerabilities, it’s the as-yet unknown trends and anomalies that are keeping these executives, board members, and management awake at night.

    The good news is that data, the building blocks of a performance-driven organization, can be a game changer for the internal audit function. By strategically harnessing the power of data and advanced technologies, internal auditors can increase the speed and efficiency in which data is examined to more accurately and comprehensively inform the identification, management, and reporting of risk.

    In addition, embedding a powerful data analytics program into the auditing function enables:

    Laser-sharp audits founded on the most up-to-date data patterns, trends, and relationships, as well as anomalies

    Continuous auditing and monitoring routines that allow for more agile problem-solving

    More accurate audit coverage, fraud detection, and compliance

    Heightened audit efficiencies and cost savings

    Enhanced organizational awareness related to data availability and governance

    Satisfaction of third-party expectations and regulations relating to data analytics capabilities

    The recognition of internal audit as a value-added agent of change, with a stronghold on the current risk landscape and informed perspective of future challenges 

    Yet, despite these potential benefits and opportunities, many organizations are at a standstill, unsure of where or even how to embed data analytics into their IA functions. To get there, a re-tooling of talent and a shift in corporate culture are needed. But this isn’t the only barrier to overcome, and indeed, the constraints to transforming to a data-driven audit function may at first glance seem daunting. 

    Challenges to incorporating data analytics

    There are several common challenges that may arise during the transformation process, including:

    - An incomplete understanding of what data is available, and where it is housed

    - The maturity level of the organization’s data governance processes and the ease with which data can be accessed

    - The overall quality and integrity of available data

    - The level of existing talent and skillsets needed to develop, implement, and sustain an internal data-driven IA function

    - The lack of senior leadership support to allocate resources toward developing a continuous and technology-based data analytics program

    Though significant, these challenges are not insurmountable. In fact, there are numerous steps internal auditors can take to mitigate these barriers and develop a strong data analytics program that facilitates an even stronger internal audit function.

    A virtually unlimited flow of data requires a means to harness and capitalize upon it in real time.

    How to get there: Incorporating analytics into the internal audit program

    Organizations that are committed to developing a data-driven IA function employ a strategic approach to migrate data analytics into their methodologies, using an approach not too dissimilar from how they conduct their traditional audits. Essentially, it involves planning, execution, and reporting phases in which results of one build upon the previous step. The steps below illustrate some specific tasks that would be considered in establishing a strong data analytics program. Importantly, this strategic approach is aimed
    at integrating data analytics into the audit culture and informing the resources required to transform the function on a continuous and long-term basis.


    - Establish audit objectives

    - Identify and locate available data to support objectives

    Request data (can be challenging)

    Convert data into a usable format and load data into a DA tool

    Review data for completeness, identify any gaps, and address as needed

    Develop test scripts and queries


    - Execute DA scripts

    - Interpret and analyze results

    Research and investigate based on results of query (e.g., outliers, anomalies, trends, variances)

    Review preliminary results with management and confirm findings

    Identify root causes and make recommendations as needed

    Assess results against objectives, and adjust and reperform if necessary


    - Create a high-impact report using a visualization tool

    - Report should describe analytics performed, results of analytics, and recommendations

    - Report should also include any difficulties or limitations noted that relate to the analytics performed (continuous improvement)

    Of course, not all organizations are on the same plane of use. Some companies today employ data analytics on a moderate scale. Some are further along, and still others are in the nascent stages of capitalizing on the wealth of data at their disposal. This is why flexibility and deep understanding of company resources and readiness are key.

    How fast one proceeds is perhaps secondary to the core fact that organizations today are increasingly reliant upon data to manage everyday business-critical activities and make decisions that will impact future performance and profitability. Internal auditors can lead the way by communicating the value of analytics and the urgent need to incorporate data into risk management functions within the companies they serve. By embedding advanced data analytics into auditing culture and practices, companies may realize benefits that far outweigh the challenges of initially constructing the program, including a more efficient audit cycle, access to real-time data, and enhanced risk management and decision-making.


    George Gallinger, Principal, Governance, Risk & Compliance National Director


    Daniel Fornelius, Director, Governance, Risk, and Compliance


    Subject matter expertise

    • Contact George George+Gallinger george.gallinger@cohnreznick.com
      George Gallinger

      CIA, CFE, Principal, Risk Advisory, Global Consulting Solutions

    • dan fornelious
      Contact Daniel Daniel+Fornelius daniel.fornelius@cohnreznick.com
      Daniel Fornelius

      CIA, Director, Risk Advisory Services

    • Close


      Let’s start a conversation about your company’s strategic goals and vision for the future.

      Please fill all required fields*

      Please verify your information and check to see if all require fields have been filled in.

      Please select job function
      Please select job level
      Please select country
      Please select state
      Please select industry
      Please select topic
    This has been prepared for information purposes and general guidance only and does not constitute legal or professional advice. You should not act upon the information contained in this publication without obtaining specific professional advice. No representation or warranty (express or implied) is made as to the accuracy or completeness of the information contained in this publication, and CohnReznick LLP, its partners, employees and agents accept no liability, and disclaim all responsibility, for the consequences of you or anyone else acting, or refraining to act, in reliance on the information contained in this publication or for any decision based on it.