Get advanced data analysis, from number crunching and spreadsheets to decision-support and strategy, including access to useful and practical Excel guidance. Plus, find out how big data is used and can benefit the accountancy profession.
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.
Fresh analysis suggests AI skills could help to bridge the UK productivity gap with other nations.
The EU is set to open its AI Office following the application of its recent world-first comprehensive law on Artificial Intelligence.
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.
Oracle explores how AI and Generative AI are impacting finance teams, but also the wider business. You'll come to understand the associated benefits and risks to be aware of, and how these are supported by appropriate data governance and risk management to ensure humans continue to stay in control and use AI responsibly.
webinar slides
This webinar explores the fundamentals of Power Pivot and how to best use this functionality in Excel to structure and analyse data, based on real-life examples accounting and finance professionals will encounter.
Could bad data be holding your forecasts back? If you want to perform incisive cash flow forecasts and empower your clients to make the best business decisions, you need to have a focus on data quality. In this webinar, we will delve into the impact of good data on your cash flow forecasting. We will consider the processes you can implement today to ensure your clients’ data is captured, processed, and presented in the most effective manner, and look at how Futrli can help.
Disclaimer: The opinions expressed by external guest speakers in interviews or other publications included on this website are, by their nature, those of the speaker. They are not necessarily fully endorsed by the ICAEW or purport to reflect the official policies and views of the ICAEW or its members.
ICAEW and the LGPS Scheme Advisory Board are pleased to publish a Local Government Pension Scheme Informer.
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.
ICAEW's latest research reveals the polarised reactions to private equity funding within the sector, as well as expectations for profit growth and shifts in services lines over the next three years.
The Library & Information Service provides a hand-picked collection of eBooks as a benefit of membership. If you are unable to access an eBook, please see our Help and support or contact library@icaew.com
The first of a two-volume series covering Python, a general-purpose programming language, for accounting and business tasks. This volume covers the concepts of Python and select foundational libraries using examples, codes, and accompanying outputs. Examples are tailored to accounting and business use-cases.
Includes examples and case studies that teach users the tricks for analysing data in Excel.
For those new to data analysis. Takes the reader on a tour of Excel's data analysis tools.
Large corporations like IBM and Oracle are using Excel dashboards and reports as a Business Intelligence tool, and many other smaller businesses are looking to these tools in order to cut costs for budgetary reasons.
This book delivers a powerful analysis of the new technological forces buffeting the accounting profession. Using case studies and practical examples, the author demonstrates how big data, blockchain, robotic process automation and artificial intelligence can help accountants adapt to new realities.
This book will help accountants and financial managers better understand big data and analytics, including its history and current trends. It dives into the platforms and operating tools that will help you measure program impacts and ROI, visualize data and business processes, and uncover the relationship between key performance indicators.
This book hopes to provide the reader with an inventory of basic algorithms which can be easily expanded and customized to fit an auditor's specific challenges. Accessible and comprehensive tools for these additional approaches are covered in this book, as are research approaches to take advantage of the additional explanatory power that these approaches offer to auditing. Coverage of software, methodologies, and fit statistics provide a concise reference for the conduct of audits, helping assure that audit opinions and decisions are defensible, fair, and accurate.
This book takes a thoughtful look at how the digital finance industry is evolving. It explains how to integrate digital finance concepts into existing traditional finance platforms and explores what successful companies are doing to maximize their opportunities in this context.
Terms of use: You are permitted to access, download, copy, or print out content from eBooks for your own research or study only, subject to the terms of use set by our suppliers and any restrictions imposed by individual publishers. Please see individual supplier pages for full terms of use.
Article discusses openness and transparency in data collection from customers. The authors argue that companies that are open about what they are doing with customer data and offer something fair in exchange are at an advantage over companies that are not trusted with data.
The article highlights the importance of data management and security in today's digital supply chain, where every enterprise is considered a "data enterprise." As companies transition to digitally integrated supply chains, they must prioritize data stewardship, embed data governance and security into their operations, and adapt to changing practices and regulations.
The article focuses on data classification as a pre-requisite for data protection, security, and compliance, and it explores the tools available for data classification, including offerings from major tech companies as well as open-source options. It mentions these tools use machine learning and artificial intelligence to automate data classification, ensuring accurate data management and governance.
Article discusses how Ai-driven decisions have led to discrimination against women and minorities in recruitment, criminal sentencing, medical diagnosis and credit approval and led to thousand of fines under GDPR. An overview of a robust ethical review is given and the 'Five Ps of ethical data handling'
Article explains that descriptive analytics is the process of analysing data to find trends and patterns that support decision-making, monitoring, and other initiatives. It's the most fundamental building block of data analytics.
The article discusses the need for finance leaders to recognize the importance of data analytics to become effective in their roles. The need to ensure that employees work in a culture that sustains collaboration and exchange of ideas and information by leaders is noted. It discusses ways in which management accountants can demonstrate leadership such as competence in financial planning and imparting technical accounting knowledge.
Terms of use: You are permitted to access articles subject to the terms of use set by our suppliers and any restrictions imposed by individual publishers. Please see individual supplier pages for full terms of use.
Provided by Tibco this textbook offers support on the application of statistics and data mining. It covers a variety of applications, including: business statistics, credit scoring, forecasting and survey research, data mining and quality control.
Case studies of the use of analytics, searchable by industry, application, benefit or function
This discussion paper looks at the implications of big data, artificial intelligence (AI) and machine learning for data protection, and explains the ICO’s views on these.
ICAEW accepts no responsibility for the content on any site to which a hypertext link from this site exists. The links are provided ‘as is’ with no warranty, express or implied, for the information provided within them. Please see the full copyright and disclaimer notice.