ICAEW.com works better with JavaScript enabled.

Data analytics for auditors: five essentials

Author: ICAEW Insights

Published: 07 Mar 2025

Data analytics is often overlooked in favour of flashier technologies, but it is a critical skill set for the modern auditor.

Data analytics is becoming a cornerstone of the audit profession and data-enabled audit techniques are growing in prominence.

As artificial intelligence (AI) garners more of the headlines, data capabilities are often overlooked, but to fully capitalise on the potential of AI, auditors must first develop key data skills, according to ICAEW’s Head of Data Analytics and Tech, Ian Pay.

“AI will undoubtedly bring seismic changes to the audit profession, but there are still obstacles to overcome,” says Pay. “Many auditors are cautious about AI, particularly generative AI, due to concerns about its output consistency and risks, such as hallucinations.”

However, Pay adds that more traditional AI capabilities, such as machine learning, may offer far greater potential. “These techniques are tried and tested in their ability to support areas such as anomaly detection, and data analytics will play a pivotal role in driving these changes.”

Avoiding common pitfalls in data analytics adoption

Auditors can face several challenges when adopting data analytics tools. Underestimating the importance of obtaining high-quality data from clients can be one such issue, says Pay. Another is failing to secure client buy-in from the start, which can create resistance later in the process.

Poor planning and last-minute implementation also frequently cause problems, as does relying too heavily on tools without adequate human oversight. Additionally, auditors sometimes expect immediate results without recognising that effective implementation takes time and requires patience, often over multiple audit cycles.

To navigate these challenges, firms should adopt a phased, strategic approach when introducing new tools. This means starting with simpler cases or lower-stakes audits to ensure successful implementation, before moving on to more complex situations.

Pay recommends trialling data analytics solutions on clients based on proper risk profiling, considering the complexity of the client’s IT systems, their amenability and strength of relationship, and always testing out the approach well in advance of the audit year-end.

The five essential skills

As firms incorporate data analytics into their audit processes, auditors need to develop five key competencies to maximise its effectiveness:

  1. Basic data literacy: An understanding of fundamental data principles and how to work with data effectively.
  2. Data acquisition: The ability to collect complete, accurate and reliable data from clients – a skill often undervalued.
  3. Data quality assessment: The ability to recognise good versus bad data and to identify quality issues early, which will prevent delays in audits.
  4. Data ethics: Ensuring integrity, objectivity and confidentiality when handling data to foster trust in analytics-driven audits.
  5. Awareness of the ‘art of the possible’: An understanding of the potential of data analytics, even if auditors lack the technical expertise to develop the solutions themselves. This is where collaboration with specialists can bridge the gap.

Technology and audit standards

Looking ahead, auditors should monitor developments in technology-related auditing standards. “The International Auditing and Assurance Standards Board (IAASB) is increasingly engaging with audit technology, suggesting shifts in regulatory expectations. Firms that embrace technology proactively will be better positioned to adapt,” Pay says.

Smaller firms and individual practitioners may assume that adopting data analytics requires expensive software or advanced coding skills. “In reality, many effective tools are available at little or no cost. Excel with Power Query is a robust solution when used well, and open-source, low-code platforms such as KNIME provide an accessible entry point for more advanced capabilities without programming expertise.

“By leveraging these tools, smaller firms can enhance audit quality and efficiency without significant financial investment,” Pay explains.

The future of AI in auditing

Join Pay at the upcoming Festival of Accounting & Bookkeeping, where he will be taking part in a panel discussion titled ‘Is AI really going to change everything?’ on 12 March. In addition, ICAEW will have a stand at the event on both 12-13 March, offering valuable insights on practical AI adoption strategies and the evolving regulatory landscape. This two-day event is free for ICAEW members to attend.

Pay emphasises that a key takeaway from his panel session will be that “good AI needs good data”. To ensure AI-driven solutions are effective and trustworthy, firms must establish solid data foundations, alongside other critical components, which will be explored during the session and throughout the event.

More audit and assurance resources

Resources
hand finger pointing digital screen computer audit technology ICAEW
Audit and technology

Innovative analytical and artificial intelligence tools are transforming audit, enabling auditors to be more collaborative and provide greater insights in real time. Read the latest on how technology is reshaping audit

Browse resources
ICAEW Faculty
ICAEW's Audit and Assurance Faculty can help you stay ahead of the curve with its essential guidance and technical advice.
Audit and Assurance

An internationally recognised network of professionals focused on keeping ahead of the changes to the audit and assurance landscape.

Find out more
ICAEW support
A hand holding a magnifying glass looking at some papers
Training and events

Browse upcoming and on-demand ICAEW events, webinars and training on audit and assurance. Don't miss the latest developments in practice and regulation.

Events and webinars CPD courses and more
Open AddCPD icon

Add Verified CPD Activity

Introducing AddCPD, a new way to record your CPD activities!

Log in to start using the AddCPD tool. Available only to ICAEW members.

Add this page to your CPD activity

Step 1 of 3
Download recorded
Download not recorded

Please download the related document if you wish to add this activity to your record

What time are you claiming for this activity?
Mandatory fields

Add this page to your CPD activity

Step 2 of 3
Mandatory field

Add activity to my record

Step 3 of 3
Mandatory field

Activity added

An error has occurred
Please try again

If the problem persists please contact our helpline on +44 (0)1908 248 250