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

When data meets society: managing data ethically

Writing for the Institute and Faculty of Actuaries, ICAEW’s Head of Financial Services Philippa Kelly explores how the COVID-19 pandemic and Black Lives Matter movement have brought issues with our relationships to financial services and data into sharp relief.

Exploring charts (graphs) in Excel - Part 6: enhancing bar charts – creating funnel and tornado charts

In Blog 5 we explored how to create Column and Bar charts, in this Blog we will continue using these to create Funnel and Tornado charts. From 2016 onwards there is a Funnel chart option within Excel, but this only displays one set of data with bars that are of equal length either side of the centre (equivalent to centring the bars on a chart rather than left justifying them). For two sets of data with differing sized bars either side of the centre we must use the traditional method of a stacked bar chart.

Blog series

Big data and the profession - what does the future hold?

The growth of computer power, and rise of automation and artificial intelligence will increasingly affect analytical tasks. Accountants will need to find new ways to add value in response.

Webinars and recordings

Truth, Lies and Numbers

In the second episode of the More Than number podcast series, Louise Cooper and guests discussed whether numbers would always be subverted and who can we depend on to stop it.

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

Analyst Pathway

Choose the Analyst pathway to develop your skills in data analytics, to better support your business and clients with forward-looking powerful insight (e.g. predictive forecasts) and assurance (e.g. anomaly detection).

Analyst pathway

Choose the Analyst pathway to develop your skills in data analytics, to better support your business and clients with forward-looking powerful insight (e.g. predictive forecasts) and assurance (e.g. anomaly detection).

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

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

This book takes a thoughtful look at how the industry is evolving, and it explains how to integrate concepts of digital finance into existing traditional finance platforms. It explores what successful companies are doing to maximize their opportunities in this context and offers suggestions on how to introduce digital finance into a firm's structure. Specific strategies for a digital future are presented, alongside numerous case studies that explore key attributes of success.

Principles of data wrangling: practical techniques for data preparation

This book walks the reader through the wrangling process by exploring several factors-time, granularity, scope, and structure-that you need to consider as you begin to work with data.

Data strategy: how to profit from a world of big data, analytics and the internet of things

A must-have guide to creating a robust data strategy. Explaining how to identify your strategic data needs, what methods to use to collect the data and, most importantly, how to translate your data into organizational insights for improved business decision-making and performance, this is essential reading for anyone aiming to leverage the value of their business data and gain competitive advantage.

Ensuring your data doesn't become a liability

Chapter 10 of this title deals with: data ownership and privacy; data security; best practice in data governance.

Understanding business valuation: a practical guide to valuing small to medium sized businesses

This fifth edition of this title covers all areas in the various valuation approaches, methods, and techniques in an easy-to-read style.

Big data in practice: how 45 successful companies used big data analytics to deliver extraordinary results

Offers an in-depth insight into how specific companies use big data.

Visualizing financial data

This book provides visualization methods that will help you navigate today's cluttered landscape of financial markets. It starts with a review of current, commonly used methods for communicating financial data and then offers methods to refine or enhance them, or create new types of visualisations that are easy to use, elegant, and that facilitate better decision-making. Many break with today's common practices for communicating data, but improve efficiency and clarity.

Good charts: the HBR guide to making smarter, more persuasive data visualizations

Provides an essential guide to how visualization works. It will help you turn plain, uninspiring charts that merely present information into smart, effective visualizations that powerfully convey ideas.

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.

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

Five key points about unstructured data storage

Article discusses the possible challenges faced by companies in managing their unstructured data, as well as the potential benefits of unstructured data in business success.

Ethics maps for AI analytics

The article looks at the importance of an ethics map as a component of any company's artificial intelligence (AI) usage and AI-based decision-making strategy.

Data bias and diversity and inclusion

The article examines the possible effects of data bias in analytical models on the implementation by organizations and businesses of their diversity and inclusion programs. Also cited are the key role played by finance, accounting and corporate professionals in preventing the use of data bias in decision making, the data life cycle process, and ways to minimize data error or bias.

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.