ICAEW.com works better with JavaScript enabled.

Data analytics articles and features

Articles and features on data analytics.

Displaying 1-50 of 225 results
Exclusive Unsung heroes, navigating career challenges to drive value
  • 09 Apr 2024
  • Steven Brown
ICAEW recently hosted a webinar where three experienced internal audit professionals shared their insights on the evolving landscape of internal audit, the skills needed to succeed in this field, and strategies for overcoming common challenges.
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #489 – The basics of charts in Excel part 2: Combo charts
  • 08 Apr 2024
  • Tom Edmunds
Hello and welcome back to Excel Tips and Tricks! This week, we have a Creator level post exploring the concept of a combo chart in Excel that can be used for two or more series of data.
INSIGHTS VIEWPOINT CYBER ROUND-UP Cyber round-up: March 2024
  • 27 Mar 2024
  • ICAEW Insights
This month we look at what can be learned from state-sponsored cyber attacks, how to avoid falling victim to increasingly sophisticated account takeover scams, and the ICO guidance on levels of fines for data breaches.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL New £7.4m AI training fund open to accountants
  • 19 Mar 2024
  • ICAEW Insights
ICAEW is urging accountancy firms to sign up to a new £7.4m funding pot to help staff at small and medium sized businesses boost their artificial intelligence (AI) skills.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL ICAEW/RQ tie-up aids integrated advisory
  • 19 Mar 2024
  • ICAEW Insights
RQ platform puts ICAEW members at the heart of a professional services eco-system that enables them to provide more integrated advice and support to their clients.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL PwC adopts AI co-pilot for tax support
  • 15 Mar 2024
  • ICAEW Insights
AI assistant will provide support to more than 2,000 PwC employees in the UK, with further potential to plug directly into clients’ tax functions.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL How AI is blazing a trail in ESG reporting
  • 08 Mar 2024
  • ICAEW Insights
Businesses are seeking the aid of artificial intelligence to drive efficiencies in their ESG reporting work – but users should be aware of some crucial caveats.
Transforming accounting through technology: embracing big data, AI and blockchain for a better tomorrow
  • 05 Mar 2024
  • Zayd Maniar, International Liaison Partner, Crowe UAE
The accounting profession has been adapting to technology since the invention of the abacus in the second century BC. Now, with the explosion of big data, the increasing affordability of advanced analytics, and the adoption of artificial intelligence (AI) and blockchain, the industry is entering a new era of transformation. This digital transformation will revolutionise the practice of accountancy and have implications for entire businesses, societies and economies. By embracing the technological changes of the Fourth Industrial Revolution, Chartered Accountants can ensure they remain relevant...
INSIGHTS VIEWPOINT CYBER ROUND-UP Cyber round-up: February 2024
  • 28 Feb 2024
  • ICAEW Insights
This month we look at the latest stories in the world of cyber, the lessons 2023 has taught us on how to improve cyber security, and the changes to the Online Safety Act.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL What makes generative AI such a game changer?
  • 23 Feb 2024
  • ICAEW Insights
While older types of AI were in many ways process-based machines, Gen-AI displays strong signs of intuition, initiative and creativity. What does this distinction between ‘new’ and ‘old’ AI actually mean?
INSIGHTS VIEWPOINT INSIGHTS SPECIAL How generative AI is set to disrupt finance
  • 20 Feb 2024
  • ICAEW Insights
As its capabilities grow, Gen-AI is poised to shake up the finance function in general and accountancy in particular – but its risks and drawbacks cannot be ignored.
Exclusive Automated data extraction - where do I start?
  • 12 Feb 2024
  • Dext
You may already be on the road to becoming fully automated. But if clients still bring you boxes of receipts and paper bank statements, which you manually enter into systems like Xero and QuickBooks, then it might be time to consider automated data extraction. The question is where do you begin?
INSIGHTS VIEWPOINT EFRAG aids SMEs with new sustainability data standard
  • 06 Feb 2024
  • ICAEW Insights
Exposure Draft proposes a simple reporting tool to help SMEs respond to requests for sustainability data from business partners such as banks, investors or larger company clients.
INSIGHTS VIEWPOINT CYBER ROUND-UP Cyber round-up: January 2024
  • 30 Jan 2024
  • ICAEW Insights
As the year begins, organisations reflect on lessons learned in 2023, and set priorities and develop strategies for improving cyber security in 2024.
Environmental risks could hit the point of no return, warns report
  • 16 Jan 2024
  • ICAEW
Key findings from the 2024 World Economic Forum (WEF) Global Risks Report.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL Finance leaders highlight AI skills shortage
  • 15 Jan 2024
  • ICAEW Insights
Resilience and efficiency is at risk as CFOs warn finance teams don’t have the necessary skills to embrace new technologies.
Exclusive New to the Excel community in 2024? Start here…
  • 19 Dec 2023
  • Bani Lamba
As we welcome a new year, we’re also delighted to welcome all our members to the growing and evolving Excel Community in 2024. So, if you’re new or an existing member looking for a refresher, start here to learn how to make the best use of your community.
Exclusive How concerned should we be about a digital pound?
  • 12 Dec 2023
  • ICAEW Financial Services Faculty
The Treasury and Bank of England’s consultation on introducing a digital pound received 50,000 responses.
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.
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.
Exclusive Data sharing as a policy intervention
  • 21 Nov 2023
  • David Bholat
The recent and spectacular advances made in generative artificial intelligence have been possible because of shared data.
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.
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.
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.
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.
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
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.
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.
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.
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.
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.
Top tips from tutors
  • 19 Apr 2023
ACA tutors from around the world attended the Tutor Conference this year.
Displaying 1-50 of 225 results