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.
Writing for the Institute and Faculty of Actuaries, ICAEW’s Head of Financial Services Philippa Kelly explores how the COVID-19 pandemic and Black Lives Matter movement have brought issues with our relationships to financial services and data into sharp relief.
In Blog 5 we explored how to create Column and Bar charts, in this Blog we will continue using these to create Funnel and Tornado charts. From 2016 onwards there is a Funnel chart option within Excel, but this only displays one set of data with bars that are of equal length either side of the centre (equivalent to centring the bars on a chart rather than left justifying them). For two sets of data with differing sized bars either side of the centre we must use the traditional method of a stacked bar chart.
Our quarterly digest of new features across Microsoft 365 & other business tech products in written, images & video format.
How to safeguard your programs from bias
The growth of computer power, and rise of automation and artificial intelligence will increasingly affect analytical tasks. Accountants will need to find new ways to add value in response.
Some deeper questions about our use of big data and analytics and how it can influence society.
While there are lots of ways in which accountants are making use of new capabilities in data and analytics, we need to recognise a number of practical barriers and challenges.
In the second episode of the More Than number podcast series, Louise Cooper and guests discussed whether numbers would always be subverted and who can we depend on to stop it.
Power Pivot is freely available in Excel, but is often overlooked. But the powerful add-in can supercharge your PivotTables, allowing more nuanced and detailed calculations and summaries than ever before.
Technology is transforming audit.
Power BI Desktop is a free application that can turn financial data into animated and interactive visualisations.
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.
Choose the Analyst pathway to develop your skills in data analytics, to better support your business and clients with forward-looking powerful insight (e.g. predictive forecasts) and assurance (e.g. anomaly detection).
Choose the Analyst pathway to develop your skills in data analytics, to better support your business and clients with forward-looking powerful insight (e.g. predictive forecasts) and assurance (e.g. anomaly detection).
Final Strategy Report
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
This book takes a thoughtful look at how the industry is evolving, and it explains how to integrate concepts of digital finance into existing traditional finance platforms. It explores what successful companies are doing to maximize their opportunities in this context and offers suggestions on how to introduce digital finance into a firm's structure. Specific strategies for a digital future are presented, alongside numerous case studies that explore key attributes of success.
This book walks the reader through the wrangling process by exploring several factors-time, granularity, scope, and structure-that you need to consider as you begin to work with data.
A must-have guide to creating a robust data strategy. Explaining how to identify your strategic data needs, what methods to use to collect the data and, most importantly, how to translate your data into organizational insights for improved business decision-making and performance, this is essential reading for anyone aiming to leverage the value of their business data and gain competitive advantage.
Chapter 10 of this title deals with: data ownership and privacy; data security; best practice in data governance.
This fifth edition of this title covers all areas in the various valuation approaches, methods, and techniques in an easy-to-read style.
Offers an in-depth insight into how specific companies use big data.
This book provides visualization methods that will help you navigate today's cluttered landscape of financial markets. It starts with a review of current, commonly used methods for communicating financial data and then offers methods to refine or enhance them, or create new types of visualisations that are easy to use, elegant, and that facilitate better decision-making. Many break with today's common practices for communicating data, but improve efficiency and clarity.
Provides an essential guide to how visualization works. It will help you turn plain, uninspiring charts that merely present information into smart, effective visualizations that powerfully convey ideas.
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.
The Library & Information Service provides a hand-picked collection of industry press articles as a benefit of membership. If you are unable to access an article, please see our Help and support or contact library@icaew.com
Article discusses the possible challenges faced by companies in managing their unstructured data, as well as the potential benefits of unstructured data in business success.
The article looks at the importance of an ethics map as a component of any company's artificial intelligence (AI) usage and AI-based decision-making strategy.
The article examines the possible effects of data bias in analytical models on the implementation by organizations and businesses of their diversity and inclusion programs. Also cited are the key role played by finance, accounting and corporate professionals in preventing the use of data bias in decision making, the data life cycle process, and ways to minimize data error or bias.
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.
This guide, from the Fraud Prevention Panel, provides an overview of the common methods of data mining and analytics and explains how you can use them to guard against fraud.
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.