ICAEW.com works better with JavaScript enabled.

Data analytics articles and features

Articles and features on data analytics.

Displaying 1-50 of 252 results
INSIGHTS VIEWPOINT Leading data-led decision making in local government
  • 05 Dec 2024
  • ICAEW Insights
Finance professionals are pivotal in ensuring local authority decisions on service delivery are grounded in robust data analysis. CIPFA’s Iain Murray outlines the role of finance teams in ensuring data-led decision-making and the skills required for success.
The ABCD+ of technology: data
  • 04 Dec 2024
  • ICAEW Insights
In the fifth of our series on the biggest tech trends, ICAEW’s Head of Tech Ian Pay gives us the lowdown on data.
Exclusive EXCEL TIP OF THE WEEK Your Excel Community – Highlights from 2024
  • 29 Nov 2024
  • Bani Lamba
As we approach a new year, it’s time to reflect on the best content from the Excel Community in 2024 and look ahead as the community grows and develops. Whether you’re new or an existing member, we invite you to explore the insights and learnings the community has delivered for you over this last year.
Exclusive EXCEL TIP OF THE WEEK Your Excel Community – Highlights from 2024
  • 29 Nov 2024
  • Bani Lamba
As we approach a new year, it’s time to reflect on the best content from the Excel Community in 2024 and look ahead as the community grows and develops. Whether you’re new or an existing member, we invite you to explore the insights and learnings the community has delivered for you over this last year.
Excel’s GROUPBY & PIVOTBY functions vs PivotTables
  • 29 Nov 2024
  • David Benaim
One of Excel’s most significant updates this decade is without a doubt the new GROUPBY and PIVOTBY functions, these can replicate PivotTables functionality through formulas, so here I will compare and contrast both methods whilst providing possibly the most complete guide on the internet currently of GROUPBY.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL AI skills gap is a ticking time bomb
  • 13 Nov 2024
  • ICAEW Insights
Estimates predict that with the adoption of AI technology, 40% of the workforce will need to re-skill in the next three years. So what’s the risk of losing your competitive edge if you fail to upskill your staff?
INSIGHTS VIEWPOINT ECONOMIC UPDATE ICAEW launches Financial Due Diligence guideline
  • 12 Nov 2024
  • ICAEW Insights
Although the use of technology has revolutionised the financial due diligence process, it also brings with it certain important risks and issues that members and firms working in the deal space need to manage very carefully, best practice guideline warns.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL Understanding AI: what is – and isn’t – artificial intelligence?
  • 05 Nov 2024
  • ICAEW Insights
An in-depth awareness of AI is no longer the preserve of data science professionals or technology enthusiasts. In the first of two articles, BDO’s Paul Ekwere explains what AI actually is – and what it isn’t.
INSIGHTS VIEWPOINT CYBER ROUND-UP Payment scams, data hacks and Cyber Security Awareness Month
  • 31 Oct 2024
  • ICAEW Insights
Cyber round-up: the continuing payment scams and personal data attacks on individuals, key takeaways from ICAEW’s Cyber Security Awareness Month campaign, and how to safeguard your data and business from harm.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL AI use cases: eight ways AI can help
  • 29 Oct 2024
  • ICAEW Insights
AI can be used for a variety of tasks to assist accountants in business and practice. Here are eight ways in which AI can help increase productivity and efficiency in finance and accounting teams.
Exclusive RICS' International Valuations Standards Agenda Consultation response: implications for accountancy professionals
  • 23 Oct 2024
  • Jonathan Fothergill
The International Valuation Standards Council (IVSC) plays a crucial role in establishing global standards for real estate valuation. The IVSC has published its 2024 Agenda Consultation, aiming to shape the future of the International Valuation Standards (IVS). This triennial consultation invites stakeholders to provide their input on key valuation topics that are crucial for the ongoing development of IVS.
INSIGHTS VIEWPOINT Cyber: your personal accounts could be arming cyber criminals
  • 18 Oct 2024
  • ICAEW Insights
Cyber Security Awareness Month: Attendees at ICAEW’s annual cyber lecture learned about the government’s moves to tackle cybercrime, and how personal digital footprints can leave businesses vulnerable.
INSIGHTS VIEWPOINT Cyber: the importance of security in supply chains
  • 16 Oct 2024
  • ICAEW Insights
Cyber Security Awareness Month: often the weakest link in a company’s cyber security infrastructure, supply chains must be tightened to avoid costly, malicious breaches.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL Partnering effectively with AI, part 1: choosing a solution
  • 16 Oct 2024
  • ICAEW Insights
Before you can think about partnering with an AI tool, you will need to have a clear understanding of which use case(s) you want it to answer.
INSIGHTS VIEWPOINT Cyber: enhancing security when data sharing
  • 15 Oct 2024
  • ICAEW Insights
Cyber Security Awareness Month: we consider the common cyber risks around data sharing and what processes, procedures and measures should be taken to mitigate them.
Harnessing AI’s potential: a guide for finance professionals
  • 15 Oct 2024
  • ICAEW Insights
Artificial intelligence opens a world of seemingly endless possibilities, boosting efficiency and quality across business operations. But how can finance professionals identify effective and ethical ways to implement relevant AI solutions?
The benefits of using AI during a deal
  • 15 Oct 2024
AI tools are increasingly being used throughout the deal cycle to achieve a list of advantages.
Exclusive Definitions and types of AI
  • 15 Oct 2024
Read definitions of on AI and learn more about the different types of AI.
INSIGHTS VIEWPOINT Cyber: accountants can mitigate supply chain concentration risk
  • 10 Oct 2024
  • ICAEW Insights
Cyber Security Awareness Month: does your business risk relying too heavily on a few key suppliers? Diversifying and strengthening your supply chain could be essential for long-term resilience.
INSIGHTS VIEWPOINT Cyber: how to help staff keep up with cybercrime
  • 10 Oct 2024
  • ICAEW Insights
Cyber Security Awareness Month: Cyber threats are changing all the time, putting pressure on companies to educate staff effectively. But what is the right amount of training and what sort of tone should it take?
INSIGHTS VIEWPOINT Cyber: is your insurance adequate in 2024?
  • 08 Oct 2024
  • ICAEW Insights
Cyber Security Awareness Month: with the dynamic threat of cyber attacks and evolving regulations, businesses must ensure their cyber insurance policies are comprehensive and adaptable.
INSIGHTS VIEWPOINT Why small accounting firms are prime targets for cybercriminals
  • 08 Oct 2024
  • ICAEW Insights
Cyber Security Awareness Month: SMEs and small accounting firms are not taking cyber security seriously enough, according to Daniel Teacher.
INSIGHTS VIEWPOINT Major cyber security risks and trends in 2025
  • 07 Oct 2024
  • ICAEW Insights
Cyber Security Awareness Month: Organisations need to address risks through processes, protocols and procedures and not just buy that latest shiny technology.
The ABCD+ of technology: cloud
  • 03 Oct 2024
  • ICAEW Insights
In the fourth of our series on tech trends, ICAEW’s Head of Tech Ian Pay and cloud expert Barry Iacovou discuss the pros and cons of web-based computing.
Exclusive EXCEL TIP OF THE WEEK Excel Tips and Tricks #495 - Excel “Tick”ery!
  • 27 Sep 2024
  • Ian Pay
Welcome back to Excel Tips and Tricks! For our latest tip, we have a General User post exploring one of the latest pieces of Excel functionality – Checkboxes.
YOUR QUESTIONS ANSWERED Your Questions Answered #11 – Tips and Tricks Live extended
  • 11 Jul 2024
  • David Benaim
In last month’s ‘Excel Tips and Tricks live – your questions answered’ webinar, David Benaim and Ian Pay tackled Excel questions and queries covering best practices when using Power Query, the use of formulas such as XLOOKUP, and a range of techniques for data handling and analysis in Excel. In this article, David returns to answer some of the unanswered questions from the webinar.
INSIGHTS VIEWPOINT INSIGHTS SPECIAL Is AI really taking your job?
  • 13 Jun 2024
  • ICAEW Insights
Fresh analysis suggests AI skills could help to bridge the UK productivity gap with other nations.
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.
Displaying 1-50 of 252 results