ICAEW.com works better with JavaScript enabled.

Data analytics articles and features

Articles and features on data analytics.

Displaying 1-50 of 243 results
INSIGHTS VIEWPOINT INSIGHTS SPECIAL European Union launches new AI Office
  • 11 Jun 2024
  • ICAEW Insights
The EU is set to open its AI Office following the application of its recent world-first comprehensive law on Artificial Intelligence.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL How we applied AI to combat modern slavery
  • 10 Jun 2024
  • ICAEW Insights
The iEARTHS project is a causal AI system designed to tackle modern slavery. David Wray, ICAEW member and one of its creators, explains the considerations that went into its development.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL Government extends deadline for AI skills grants
  • 04 Jun 2024
  • ICAEW Insights
Accountancy firms now have until 18 August to apply for grants under the pilot of the government’s new AI Upskilling Fund, after the government extended the deadline by 11 weeks.
My ACA Journey: the home straight
  • 28 May 2024
  • ICAEW Insights
As she prepares for her first Advanced Level exams, Ashwini Poopalasingham looks back at everything she’s learned so far, and forwards to life after the qualification.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL Over-reliance on automation: a cautionary tale from Plato
  • 27 May 2024
  • ICAEW Insights
The dangers of too much tech are not a new concern – Konrad Bukowski-Kruszyna explains why accountants can take a sceptical cue from the ancient Greeks when it comes to AI.
Evolution of mid-tier accountancy firms
  • 23 May 2024
ICAEW's latest research into mid-tier practices reveals reaction to the increase in private equity funding to the sector, as well as expectations for profit growth and shifts in services lines over the next three years.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL How auditors can meet the client tech challenge
  • 22 May 2024
  • ICAEW Insights
Understanding how clients’ tech systems are operating is vital due to the demands of the revised ISA 315, but there are many strategies and tools that can help.
INSIGHTS VIEWPOINT The enduring role of the accountant
  • 22 May 2024
  • ICAEW Insights
In his speech at the recent ICAEW Annual Dinner at Chartered Accountants' Hall, ICAEW President Mark Rhys outlined the continuing relevancy of accountancy to some of the biggest global challenges, and the need for the profession to continue to evolve.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL Updated: 20 Principles for Good Spreadsheet Practice
  • 21 May 2024
  • ICAEW Insights
ICAEW issues fourth edition of 20 Principles for Good Spreadsheet Practice in recognition of changed ways of working and the need to work effectively with ever-increasing volumes of data.
Monica Odysseos’s volunteering journey from Student to Member
  • 16 May 2024
  • ICAEW
Monica Odysseos has volunteered with ICAEW throughout her career as a professional accountant. She explains why Students and Members across the globe should get involved.
Capacity Building for Sustainable Finance gains momentum
  • 10 May 2024
  • ICAEW
The Sustainable Finance Education Charter (SFEC) has released its third Annual Progress Report, showcasing the progress made by professional bodies throughout 2023 in advancing education and training in sustainable finance.
INSIGHTS VIEWPOINT Corporate data: a new type of intangible
  • 08 May 2024
  • ICAEW Insights
Research by ICAEW and the China Accounting Standard Committee highlights the challenges of accounting for corporate data resources and suggests a new framework for their treatment in financial statements.
INSIGHTS VIEWPOINT New laws to bolster smart device security
  • 07 May 2024
  • ICAEW Insights
Ban on default passwords part of legislation to help protect consumers from having their internet-enabled devices interfered with by hackers or cybercriminals.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL New AI training fund now open for applications
  • 07 May 2024
  • ICAEW Insights
Accountancy firms can now apply for a grant from a government £6.4m funding pot to help staff at small and medium sized UK businesses boost their artificial intelligence (AI) skills.
Ensure that your trustee decisions are legal
  • 25 Apr 2024
  • Kristina Kopic, Head of Charity and Voluntary Sector
This article provides a guide on how to navigate decision-making within charities. From understanding how the charity’s legal structure and governing document impact decision-making, to documenting decisions in compliance with charity regulation and law, this guide aims to equip you with the knowledge necessary to make informed and legally sound decisions.
State of the sector what is the outlook for charities
  • 24 Apr 2024
  • Kristina Kopic, Head of Charity and Voluntary Sector
Drawing insights from recent reports and analyses, this article provides an overview of the current state of the charity sector and offers advice on how to respond to the key challenges currently facing charities.
INSIGHTS VIEWPOINT Just what is an AI co-pilot? A practical guide
  • 23 Apr 2024
  • ICAEW Insights
A new generation of digital assistants are promising accountants enhanced speed, accuracy and efficiency, but will they live up to the hype?
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 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
Displaying 1-50 of 243 results