ICAEW.com works better with JavaScript enabled.

Data

Resources covering data analytics and big data, data handling, data protection and GDPR, and data presentation.

In this section

Accountants and data scientists - collaborating for success

How can finance departments and internal audit make the most of data science? This was the main question Centrica's internal audit team and ICAEW discussed at a workshop on 15 October 2018. With the rapidly growing volume of data available for decision-making and risk management, finance departments will need to work out how they are going to take advantage of this data. This summary aims to help by looking at how data science capabilities can be developed.

Ethics and new technologies

Ethics is particularly important for the accountancy profession, with a code for professional ethics based on five basic principles – integrity, objectivity, competence and due care, confidentiality and professional behaviour. However, the emergence of new technologies raises some new challenges for the profession to address.

Think again

With fears that artificial intelligence could take away jobs from financial services, Matt Weston looks at how it’s potentially changing hiring for the better

Excel - cumulative totals

There are many situations where you might want to calculate a cumulative total in an Excel spreadsheet, from a straightforward running total for a list of bank transactions to cumulative values for use with an Excel chart that is animated over time.

Power BI Desktop - Part two

Simon Hurst continues his guide to data display with some tips on how to keep up to date with changes and enhancements to customise your content.

Power BI Desktop - Part one

Power BI Desktop offers new ways to visualise and present data. In part one of his guide, Simon Hurst uses Facebook posts to demonstrate some of its capabilities.

Excel emojis

Although it's generally a good idea to keep reports as simple and clear as possible, the sparing use of unusual graphics can sometimes add to impact.

Finance in a digital world

Finance in a Digital World

ICAEW is collaborating with Deloitte to ensure its members have the knowledge and skills to take advantage of the opportunities offered by the fourth industrial revolution and to meet its challenges head on. Complete eLearning, watch webinars and read bite-sized summaries on individual technologies and the broader impact of digital technologies on finance.