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

Excel Tip of the Week #429 - Revisiting cross-sheet formulas

Hello all and welcome back to the Excel Tip of the Week! This week we have a General User post in which we’re taking a fresh look at how to write and work with formulas that reference cells on other worksheets. This was first discussed in TOTW #275.

Displaying reports by date – Excel versus Power BI

When working with reports interactively, it's often useful to be able to set a date or range of dates to filter the information. Here, we are going to compare the way date filtering works in Excel and in the free Power BI Desktop app.

Webinars and recordings

What's your data strategy?

Demystifying data. Before organisations can gain any value from data it is critical to have a clear data strategy that ties into an organisation's overall strategy.

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

The essential guide to data analytics

Data analytics allows firms to harness data, both internal and external, to provide faster, deeper analysis for better decision-making. These tools offer accountants the ability to track client performance at a more granular level and identify ways to build in efficiencies.

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

BVB Insights 2021 overview

An in-depth overview of transaction multiples paid for UK private companies for the year ended December 2020.

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.

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.

Data visualisation with Python: create an impact with meaningful data insights using interactive and engaging visuals

Understand, explore, and effectively present data using the powerful data visualization techniques of Python programming.

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.

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

Taking a look into the future

Article looks at how data analytics and forecasting tools are critical for the accountancy firms of tomorrow.

It's time for leaders to get real about hybrid

Article looks at the disconnect between employers wanting people back in the office and their employees not wanting to return.

Three keys to building a more skilled postpandemic workforce.

Article discusses the need for new workplace skills in the wake of the pandemic and the move to hybrid working . Employees are energized by it being made clear that reskilling was an investment in talent and directly supported growth plans.

The spread and use of blockchain

Article looks for evidence that companies have moved from investigating the use of Blockchain to successful adoption.

Latest trends in blockchain and crypto

Article outlines some recent developments in distributive ledger technology and cryptocurrencies and what they might mean for accountants and finance processionals moving forward.

Your 5-year upskilling plan

Author discusses how business success and professional development both rely on continuous upskilling and keeping current with technical opportunities and challenges as they arise.

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.