ICAEW.com works better with JavaScript enabled.

Data analytics and big data

Get advanced data analysis, from number crunching and spreadsheets to decision-support and strategy, including access to useful and practical Excel guidance. Plus, find out how big data is used and can benefit the accountancy profession.

In this section

Features and articles

Your Excel Community – Highlights from 2024

As we approach a new year, it’s time to reflect on the best content from the Excel Community in 2024 and look ahead as the community grows and develops. Whether you’re new or an existing member, we invite you to explore the insights and learnings the community has delivered for you over this last year.

Your Excel Community – Highlights from 2024

As we approach a new year, it’s time to reflect on the best content from the Excel Community in 2024 and look ahead as the community grows and develops. Whether you’re new or an existing member, we invite you to explore the insights and learnings the community has delivered for you over this last year.

Webinars and recordings

A UK tax update for international ICAEW members

This session will bring you up to date with a range of practical tax issues likely to be relevant to UK ex-pats overseas and members of their family back in the UK. It will focus on personal and capital taxes and the practical things that you may need to do or advise family members to do to keep up to date and compliant with UK tax issues.

A UK tax update for international ICAEW members

This session will bring you up to date with a range of practical tax issues likely to be relevant to UK ex-pats overseas and members of their family back in the UK. It will focus on personal and capital taxes and the practical things that you may need to do or advise family members to do to keep up to date and compliant with UK tax issues.

Critical Skills series: Cultivating a growth mindset for resilience and overcoming disappointment

Strong EQ and AQ are vital for career growth in today's workplace. Improving these skills can boost leadership, relationship-building, adaptability, and success in a dynamic economy. This interactive workshop explores how individuals can maximise their resilience to work to their full potential. It provides an opportunity to create an individual plan to help participants cope more effectively with setbacks and challenges both in and outside of the workplace.

Automate & reshape data with Power Query and macros

Excel’s game changing tool can run processes which Excel has never been able to. The same Power Query program now exists inside of Excel for Windows, Mac and Power BI, so learning it can accelerate your performance on the other platforms. Macros is another automation tool to be used in certain instances, we will cover the process and some common use cases.

Disclaimer: The opinions expressed by external guest speakers in interviews or other publications included on this website are, by their nature, those of the speaker. They are not necessarily fully endorsed by the ICAEW or purport to reflect the official policies and views of the ICAEW or its members.

Reports, guidance and thought leadership

ICAEW Financial Due Diligence guideline

This guideline explores the what, why, who and how of performing effective financial due diligence (FDD) and the outcomes it should achieve. It considers how FDD interacts with other areas of due diligence and how rapidly evolving technology, including artificial intelligence (AI), is reshaping the FDD process.

Ethics and AI

In 2024, ICAEW’s Trust and Ethics Team hosted roundtables on shaping guidance for the accountancy profession on the ethical use of artificial intelligence. Read an overview of the discussions, offering insights into real-life use cases and the risks that must be managed.

ICAEW LGPS Guide

ICAEW and the LGPS Scheme Advisory Board are pleased to publish a Local Government Pension Scheme Informer.

The Library & Information Service provides a hand-picked collection of eBooks as a benefit of membership. If you are unable to access an eBook, please see our Help and support or contact library@icaew.com

Python for accounting and business

The first of a two-volume series covering Python, a general-purpose programming language, for accounting and business tasks. This volume covers the concepts of Python and select foundational libraries using examples, codes, and accompanying outputs. Examples are tailored to accounting and business use-cases.

Guerrilla data analysis using Microsoft Excel: conquering crap data and Excel skirmishes.

Includes examples and case studies that teach users the tricks for analysing data in Excel.

Excel data analysis for dummies

For those new to data analysis. Takes the reader on a tour of Excel's data analysis tools.

Data visualization with Excel dashboards and reports

Large corporations like IBM and Oracle are using Excel dashboards and reports as a Business Intelligence tool, and many other smaller businesses are looking to these tools in order to cut costs for budgetary reasons.

Accounting disrupted

This book delivers a powerful analysis of the new technological forces buffeting the accounting profession. Using case studies and practical examples, the author demonstrates how big data, blockchain, robotic process automation and artificial intelligence can help accountants adapt to new realities.

Analytics and big data for accountants

This book will help accountants and financial managers better understand big data and analytics, including its history and current trends. It dives into the platforms and operating tools that will help you measure program impacts and ROI, visualize data and business processes, and uncover the relationship between key performance indicators.

Audit analytics: data science for the accounting profession

This book hopes to provide the reader with an inventory of basic algorithms which can be easily expanded and customized to fit an auditor's specific challenges. Accessible and comprehensive tools for these additional approaches are covered in this book, as are research approaches to take advantage of the additional explanatory power that these approaches offer to auditing. Coverage of software, methodologies, and fit statistics provide a concise reference for the conduct of audits, helping assure that audit opinions and decisions are defensible, fair, and accurate.

Digital finance: big data, start-ups, and the future of financial services

This book takes a thoughtful look at how the digital finance industry is evolving. It explains how to integrate digital finance concepts into existing traditional finance platforms and explores what successful companies are doing to maximize their opportunities in this context.

Terms of use: You are permitted to access, download, copy, or print out content from eBooks for your own research or study only, subject to the terms of use set by our suppliers and any restrictions imposed by individual publishers. Please see individual supplier pages for full terms of use.

Industry press

The Library & Information Service provides a hand-picked collection of industry press articles as a benefit of membership. If you are unable to access an article, please see our Help and support or contact library@icaew.com

Data management trends: privacy, security and AI

This article discusses the importance of data management for accountancy firms, focusing on the trends of privacy, security, and artificial intelligence (AI). It highlights the challenges posed by cyberthreats and regulatory requirements, emphasizing the need to prioritize privacy and security measures. The article suggests strategies such as data encryption, cybersecurity measures, and staff training to enhance data management. It also recommends leveraging AI tools for automation, predictive analytics, and data visualization.

No more 'wait and see'

Article discusses how accounting firms are increasingly embracing artificial intelligence (AI) and generative AI to improve efficiency and gain a competitive edge. Many firms are exploring the various applications of AI, such as internal virtual agents, client communication and automation, data analysis and anomaly detection, and tax and client services. While there is a growing acceptance of AI within the profession, some accountants still have concerns about work quality, data accuracy, fiscal costs, undetected bias, and ethical issues. It is important for firms to have proper AI guidelines and policies in place to address these concerns and ensure privacy, transparency, and fairness

In the dark about data

Article discusses openness and transparency in data collection from customers. The authors argue that companies that are open about what they are doing with customer data and offer something fair in exchange are at an advantage over companies that are not trusted with data.

The data-driven supply chain raises new governance and security issues

The article highlights the importance of data management and security in today's digital supply chain, where every enterprise is considered a "data enterprise." As companies transition to digitally integrated supply chains, they must prioritize data stewardship, embed data governance and security into their operations, and adapt to changing practices and regulations.

Getting data sorted

The article focuses on data classification as a pre-requisite for data protection, security, and compliance, and it explores the tools available for data classification, including offerings from major tech companies as well as open-source options. It mentions these tools use machine learning and artificial intelligence to automate data classification, ensuring accurate data management and governance.

Managing people's data ethically

Article discusses how Ai-driven decisions have led to discrimination against women and minorities in recruitment, criminal sentencing, medical diagnosis and credit approval and led to thousand of fines under GDPR. An overview of a robust ethical review is given and the 'Five Ps of ethical data handling'

Terms of use: You are permitted to access articles subject to the terms of use set by our suppliers and any restrictions imposed by individual publishers. Please see individual supplier pages for full terms of use.

Useful links

Electronic Statistics Textbook

Provided by Tibco this textbook offers support on the application of statistics and data mining. It covers a variety of applications, including: business statistics, credit scoring, forecasting and survey research, data mining and quality control.

ICAEW accepts no responsibility for the content on any site to which a hypertext link from this site exists. The links are provided ‘as is’ with no warranty, express or implied, for the information provided within them. Please see the full copyright and disclaimer notice.

* Some of the content on this web page was provided by the Chartered Accountants’ Trust for Education and Research, a registered charity, which owns the library and operates it for ICAEW.