ICAEW.com works better with JavaScript enabled.

Data analytics articles and features

Articles and features on data analytics.

Displaying 1-50 of 233 results
Exclusive Leveraging maths and stats in Excel for deeper data insights – part 6
  • 05 Dec 2023
  • John Tennent
The final part of this series will explore normal distribution curves and probabilities of success.
INSIGHTS VIEWPOINT CYBER ROUND-UP ICAEW Cyber round-up: November 2023
  • 27 Nov 2023
  • ICAEW Insights
As the run-up to Christmas starts in earnest, we observe more news in the cyber realm, from threats to the organs of our nation to how attacks might come from unexpected places.
EXCEL TIP OF THE WEEK Excel Tips & Tricks #484 – Best of 2023
  • 24 Nov 2023
  • Bani Lamba
As we approach the end of the year, we pause to reflect on the best content from the Excel Community this year and look ahead as the community grows.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL Audit quality drives search for AI tools
  • 15 Nov 2023
  • ICAEW Insights
Creating a space for firms to trial, test and fail will be critical to advancing AI in audit, says MHA partner Andrew Moyser, who was a keynote speaker at this year’s ICAEW annual conference.
INSIGHTS VIEWPOINT Blockchain can ensure trust in financial services
  • 13 Nov 2023
  • ICAEW Insights
Enhanced trust, efficiency and security in financial markets make blockchain a promising innovation for the future of trading and asset management.
INSIGHTS VIEWPOINT ICAEW Conference: AI, automated ESG and copilots
  • 10 Nov 2023
  • ICAEW Insights
Key takeaways from the ICAEW Annual Conference, where artificial intelligence and technology took centre stage.
INSIGHTS VIEWPOINT Quantum computing is a cyber security gamechanger
  • 30 Oct 2023
  • ICAEW Insights
In the ever-evolving arms race in cyber security, a new tool is emerging on the scene: quantum computing.
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks 482 – Get Data From Picture
  • 30 Oct 2023
  • Ian Pay
Hello all and welcome back to Excel Tips and Tricks! This week, we have a Creator level post in which we're covering some relatively new functionality that allows users to capture data into a spreadsheet from an image.
Exclusive Leveraging maths and stats in Excel for deeper data insights – part 5
  • 30 Oct 2023
  • John Tennent
Part 4 of this series explored a range of calendar functions for budgeting and interpreting monthly performance data. The fifth part of this series will delve techniques for forecasting revenue and bass diffusion curves to forecast future volumes and market shares.
Exclusive Histogram Hiccoughs part 2
  • 27 Oct 2023
  • Liam Bastick
Last time, I provided several reasons why Excel’s built-in Histogram charts can cause problems. This time, I consider workarounds to achieve the same visualisations.
Exclusive Histogram Hiccoughs Part 1
  • 27 Oct 2023
  • Liam Bastick
The Histogram chart helps us to analyse the distribution of the data, where we have many data points that can be grouped into categories, or “buckets”. We begin by looking at the standard Excel Histogram chart, which is available in Excel 2016 onwards.
INSIGHTS VIEWPOINT CYBER ROUND-UP ICAEW cyber round-up: October 2023
  • 27 Oct 2023
  • ICAEW Insights
This October marks the 20th anniversary of Global Cyber Security Awareness Month. In this round-up, we look at how cyber threats have evolved over the years and what this means for businesses and finance professionals.
INSIGHTS VIEWPOINT You’ve been hacked: should you pay ransomware attackers?
  • 26 Oct 2023
  • ICAEW Insights
In part two of our short series on what to do if you’ve been hacked, we look at whether you should pay up if you are the victim of a ransomware attack.
INSIGHTS VIEWPOINT You’ve been hacked: how to respond in the first 48 hours
  • 25 Oct 2023
  • ICAEW Insights
Your response in the first 48 hours after a cyber attack is critical. In the first in a short series, we look at the steps you should take to minimise the damage to your organisation and its reputation.
INSIGHTS VIEWPOINT Why collaboration is key to better cyber security
  • 24 Oct 2023
  • ICAEW Insights
While CFOs need to be more conscious of cyber risk in the workplace, cyber teams should also be increasing their own awareness of business needs.
NCSC marks 20 years of Cyber Security Awareness month with a ‘Digital Defenders’ campaign
  • 20 Oct 2023
The National Cyber Security Centre (NCSC) is running a campaign on the theme of ‘Digital Defenders’ to mark 20 years of Cyber Security Awareness Month during October.
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #481 – Refreshing Cell Styles
  • 20 Oct 2023
  • Ian Pay
Hello all and welcome back to Excel Tips and Tricks! This week, we have a General User post in which we're revisiting the topic of cell styles to help support consistency of formatting.
INSIGHTS VIEWPOINT Cyber month: CFOs should take the lead
  • 17 Oct 2023
  • ICAEW Insights
Cyber security is a major priority for most large organisations, but the best prepared have CFOs who take an active role in managing cyber risk.
INSIGHTS VIEWPOINT Cyber month: why AI offers both security and threat
  • 12 Oct 2023
  • ICAEW Insights
The average cost of data breaches is increasing, particularly for smaller firms, while AI is increasingly used for both cyber security and malware.
Insider dealing: Quantexa hits unicorn status
  • 11 Oct 2023
  • Nicholas Neveling
  • Corporate Financier
In one of the toughest funding round markets in years, AlbionVC portfolio company Quantexa achieved unicorn status in April. Nicholas Neveling says this proves that tech firms with great prospects are still being backed to grow.
Exclusive TECH NEWS EXCEL TIP OF THE WEEK Excel Tips and Tricks #480 – Refreshing securing workbooks
  • 11 Oct 2023
  • Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week we have a Creator level post where we revisit various ways of securing Excel workbooks containing sensitive and confidential data.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL The 21st-century evolution of cyber security
  • 09 Oct 2023
  • ICAEW Insights
Cyber security has evolved hugely over the past two decades but the fundamental principle of good cyber hygiene is as relevant to accountancy firms now as it was then.
Exclusive Leveraging maths and stats in Excel for deeper data insights – part 4
  • 27 Sep 2023
  • John Tennent
Part 3 of this series explored regression analysis and methods to identify ‘lines of best fit’ through data and then use this to extrapolate future values. The fourth part of this series will deep dive into a range of calendar functions that help with budgeting and interpreting monthly performance data.
YOUR QUESTIONS ANSWERED Your Questions Answered #8 – Does Power BI leave the underlying data source unchanged?
  • 27 Sep 2023
  • Monica Odysseos
In a recent ‘Power Tools Part 2: Harness the potential of Power BI’ webinar, Monica Odysseos explored the fundamentals of Power BI, including loading data and understanding its structure. Monica returns to answer some questions from the webinar she was unable to respond to during the session.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL Boards must be more cyber savvy, says report
  • 25 Sep 2023
  • ICAEW Insights
Low levels of cyber expertise among board members and an overt deference towards jargon-focused CISOs cited as key vulnerabilities in corporate governance.
SPONSORED CONTENT Cyber risk management – a board level responsibility
  • 22 Sep 2023
  • Mitigo
Mitigo highlight why senior leaders must take responsibility for their cyber risk management to counter a growing threat.
Volunteering globally for ICAEW: Junaidy Ab-Mutalib tells his story
  • 18 Sep 2023
Based in Kuala Lumpur, Malaysia, Junaidy Ab-Mutalib has global reach. He outlines the benefits of volunteering for ICAEW wherever you are in the world.
Exclusive Formatting Slicers
  • 30 Aug 2023
  • Liam Bastick
In earlier versions of Microsoft Excel, you can use report filters to filter data in a PivotTable report, but it is not easy to see the current filtering state when you filter on multiple items. In Microsoft Excel 2010 and later versions (that is, from when Slicers were introduced), you have the option to use Slicers to filter the data
INSIGHTS VIEWPOINT INSIGHTS SPECIAL ChatGPT will assume tasks, not take jobs
  • 29 Aug 2023
  • ICAEW Insights
The rapid rise of generative AI models such as ChatGPT has led to discussions about what it might mean for the future of jobs. According to the EMEA AI lead at Microsoft, it’s an opportunity, not a threat.
Exclusive Leveraging maths and stats in Excel for deeper data insights – part 3
  • 25 Aug 2023
  • John Tennent
Part 2 of this series explored methods of smoothing historic data to understand trends and patterns. The third part of this series will look at regression and methods of using least squares regression analysis to identify ‘lines of best fit’ through data and then use this to extrapolate future values
Exclusive YOUR QUESTIONS ANSWERED Your Questions Answered #7 - How do I combine tables from multiple files into a single table?
  • 24 Aug 2023
  • Ian Pay
In a recent ‘Excel Tips and Tricks live – your questions answered’ webinar, Ben Ducker and Ian Pay tackled excel questions and queries covering best practice, the use of functions and functionality, and application of Excel techniques to accounting scenarios. Ian returns to deep dive into how tables from multiple files in different locations can be combined into a single table in Excel.
INSIGHTS VIEWPOINT CYBER ROUND-UP ICAEW cyber round-up: July 2023
  • 26 Jul 2023
  • ICAEW Insights
As ever-more businesses rush to develop generative AI tools, there are concerns that cyber security is being overlooked. Meanwhile, MOVEit has issued a service pack to deal with the hack that has affected millions.
Exclusive Coming soon: graphic details in PivotTables
  • 24 Jul 2023
  • Simon Hurst
An imminent Excel enhancement will allow you to include Data Types and images in your PivotTables. Is this your chance to build PivotTables containing employee photos and product pictures?
Exclusive Leveraging maths and stats in Excel for deeper data insights – part 2
  • 21 Jul 2023
  • John Tennent
Part 1 of this series explored the practical applications of using maths and statistics functions in Excel. This second part of the series will focus on forecasting and how to use moving averages, weighted averages, and exponential smoothing in Excel to derive deeper insights into data.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL Unlocking the next wave of automation
  • 13 Jul 2023
  • ICAEW Insights
Next generation AI is set to have a profound impact on accounting, saving thousands of hours in audit time, says Shamus Rae, CEO, Engine B.
How to get started with generative AI
  • 12 Jul 2023
  • ICAEW Insights
With the increasing immersion of generative AI into the workplace, Franki Hackett, Head of Data Ethics at Engine B and Sarah Schlobohm, Data and AI Leader, discuss the skills accountants need to use it effectively.
Carbon Accounting: Empowering SMEs to Measure and Mitigate Environmental Impact
  • 11 Jul 2023
In today's rapidly evolving business landscape, the need for organizations to address their environmental impact has become paramount. Carbon accounting, a technique used to measure and manage carbon emissions, has emerged as a powerful tool for businesses to understand and reduce their carbon footprint. In this article, we will explore what carbon accounting entails, how it can benefit small and medium-sized enterprises (SMEs), and why chartered accountants should embrace carbon accounting.
Creating a development plan to future proof your career
  • 11 Jul 2023
  • ICAEW Insights
Executive coach Oliver Deacon and ICAEW Head of Jobs Claire Brandon provide tips on how to develop and showcase your skills to make yourself stand out and keep pace with changing finance functions.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL KPMG: Just 7% of auditors’ tasks open to generative AI
  • 10 Jul 2023
  • ICAEW Insights
Increasingly sophisticated branch of AI is still a long way off from assuming the majority of tasks completed by organic auditors, says Big Four firm
Exclusive Audit and technology – a new era
  • 07 Jul 2023
  • ICAEW
  • Audit and Beyond
ICAEW’s new audit and technology hub highlights tech-led changes that are transforming audit, and offers resources to help firms on the journey
Exclusive Leveraging maths and stats in Excel for deeper data insights - part 1
  • 03 Jul 2023
  • John Tennent
This is part 1 of a series of articles that will show you the practical application of using the maths and statistics functions in Excel to derive deeper insights into data.
Specialised software and underdeveloped areas
  • 29 Jun 2023
The move to the cloud is in full flight, but the picture is variable depending on specific software categories and firm size, and areas of software underdevelopment remain.
Key drivers of software adoption
  • 29 Jun 2023
Staff wellbeing, functionality, user experience and integration are among key considerations for firms in adopting specialist software.
Research methodology
  • 29 Jun 2023
ICAEW has conducted research into mid-tier practice firms, exploring the technology landscape, the solutions that firms are currently using, and areas that they see as opportunities and challenges for the future.
Challenges, opportunities and next steps
  • 29 Jun 2023
The technology landscape has changed significantly in recent years, and the pace of change appears to be accelerating. Our research shows optimism, but also some critical areas of focus if the full potential of technology is to be realised.
ICAEW's mid-tier research highlights shifts in technology adoption
  • 29 Jun 2023
  • Ian Pay
Ian Pay, Head of Data Analytics and Tech at ICAEW, outlines the aims of the research and key themes that have emerged from the findings.
INSIGHTS VIEWPOINT University and accounting firm in digital audit project
  • 20 Jun 2023
  • ICAEW Insights
The partnership between Aston University and Beever and Struthers highlights the benefit of knowledge-sharing as firms increasingly move to adopt more digital tools in audit.
The future of audit technology, part 3: larger firms
  • 06 Jun 2023
  • ICAEW
As audited companies become increasingly data rich, new technologies are helping larger audit firms to hone the quality, accuracy and insight of their audits.
Enhancing interconnectedness for audit teams and clients
  • 06 Jun 2023
  • ICAEW
New digital tools are transforming the way auditors and clients work, with greater collaboration and frictionless workflow heralding a new audit journey.
INSIGHTS VIEWPOINT How’s the accountancy recruitment market?
  • 04 May 2023
  • ICAEW Insights
Which skills are most sought after by employers, and how can you make the most of the current marketplace?
Displaying 1-50 of 233 results