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

Dark data: from overload to insight

Businesses today have the opportunity to capture and analyse unprecedented amounts of data. By analysing data about the needs, preferences and actions of their customers, suppliers and competitors, businesses can replace guesswork with hard evidence, transforming their decision-making. And yet, in most cases, businesses are not making the most of this data.

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.