Key concepts and resources
Exclusive
Introduction to data analytics: the normal distribution, sampling and regression
- Webinar
- 30 Oct 2019
A Data Analytics Community webinar presented by Professor Maureen Meadows and Dr Alessandro Merendino.
Exclusive
Introduction to statistical data analysis
- Webinar
- 30 Oct 2019
A Data Analytics Community webinar introducing statistical data analysis presented by Nigel Marriott.
Exclusive
Trend analysis and forecasting
- Webinar
- 30 Oct 2019
A Data Analytics Community webinar on trend analysis and forecasting presented by Nigel Marriott.
Advanced analytics explained
- 23 Sep 2019
This podcast taken from ICAEW's Finance in a Digital World introduces some of the statistical techniques used to perform data analytics.
Statsoft's Electronic Statistics Textbook
- Website
- 23 Sep 2019
This electronic textbook offers training in the understanding and application of statistics and data mining. Beginning with an overview of the relevant elementary concepts, it continues with a more in-depth exploration of specific areas of statistics.
StatQuest with Josh Starmer
- Website
- 23 Sep 2019
StatQuest videos break down complicated statistics and machine learning methods into small, bite-sized pieces that are easy to understand. This page introduces the series and below we have individual links to the main titles in the series.
eBooks
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.
Exclusive
LIBRARY
Data science for business: what you need to know about data mining and data-analytic thinking
- 01 Aug 2013
- Foster Provost, Tom Fawcett
This guide introduces the fundamental principles of data science and walks through the "data-analytic thinking" necessary for extracting useful knowledge and business value from data.
Exclusive
LIBRARY
M is for (data) monkey: the Excel Pro's definitive guide to Power Query
- 01 Jan 2015
- Ken Puls, Miguel Escobar
Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and "M" is the name of the programming language created by it. This book shows how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot, and is solely devoted to Power Query dashboarding and reporting.
Exclusive
LIBRARY
Power Pivot and Power BI: the Excel user's guide to DAX, Power Query, Power BI and Power Pivot in Excel 2010-2016
- 01 Jan 2016
- Rob Collie, Avichal Singh
Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience.
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.
Techniques and applications
DATA ANALYTICS COMMUNITY
Data analysis methods: an overview
- 26 Jun 2019
- Cory Sarver
This article gives an overview of data analysis methods, including: types of variables; data cleaning; statistical indicators; types of distributions; predictive methods; simulation techniques; and classification and clustering.
DATA ANALYTICS COMMUNITY
A refresher on regression analysis
- 11 May 2015
- Amy Gallo
- Harvard Business Review
This article looks at regression analysis. This is a way of mathematically sorting out which data variable is important to your business, for example which variables affect sales.
DATA ANALYTICS COMMUNITY
Neural networks
- 01 Aug 2018
- 3Blue1Brown
Four YouTube videos related to neural networks: What is a neural network?; Gradient descent, how neural networks learn; What is backpropagation doing?; and Backpropagation calculus.
DATA ANALYTICS COMMUNITY
Business analytics and data mining
- 13 Dec 2018
- Galit Shmueli
Series of videos on various data mining methods and approaches, in the context of business analytics.
DATA ANALYTICS COMMUNITY
Why and how to cross validate a model?
- 03 Nov 2018
- Sanjay M
This article looks at common techniques for cross validation, which is one of the methods used to test the effectiveness of machine learning models. It is also a re-sampling procedure used to evaluate a model if there is limited data.
Financial Modelling code
- 22 Aug 2024
- PDF (755kb)
ICAEW’s Excel Community has worked with modelling experts, taking a half dozen methodologies and paring down to the widely accepted beliefs about what constitutes good modelling to inform the Financial Modelling Code.
Terms of use
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.
Statquest videos on YouTube
StatQuest videos break down complicated statistics and machine learning methods into small, bite-sized pieces that are easy to understand.
DATA ANALYTICS COMMUNITY
The basics
- 01 Aug 2019
- Josh Starmer
Thirty-five videos covering the fundamentals of statistics and statistical analysis. They include explanations of normal distribution, sampling errors, correlation, standard deviation, standard error and so on.
DATA ANALYTICS COMMUNITY
Linear regression
- 01 Aug 2019
- Josh Starmer
Nineteen videos explaining linear regression. This series covers matters such as logistic regression, coefficients, the P-value, R-squared and other relevant issues.
DATA ANALYTICS COMMUNITY
Logistic regression
- 01 Aug 2019
- Josh Starmer
Logistic regression is a traditional statistics technique that is also very popular as a machine learning tool. View Josh Starmer's six videos on this subject.
DATA ANALYTICS COMMUNITY
Machine learning
- 01 Aug 2019
- Josh Starmer
View 49 videos covering many facets of machine learning and automation of data analysis.
DATA ANALYTICS COMMUNITY
High-throughput sequencing
- 01 Aug 2019
- Josh Starmer
Developed in the biosciences, the introduction of high-throughput sequencing technologies has greatly accelerated the rate at which data can be collected. This series of videos examines the role of big data in genomics.
DATA ANALYTICS COMMUNITY
Statistics in R
- 01 Aug 2019
- Josh Starmer
A play list of nine videos covering the application of R in statistics. R is an elegant and comprehensive statistical and graphical programming language, but has a steep learning curve.
terms of use
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.
eLearning courses
DATA ANALYTICS COMMUNITY
Exploratory data analysis
- 07 Oct 2019
- Coursera
This course covers the essential exploratory techniques for summarising data. These techniques are typically applied before formal modelling starts and can help inform the development of more complex statistical models. Exploratory techniques are also important for eliminating or sharpening potential hypotheses about the world that can be addressed by the data.
DATA ANALYTICS COMMUNITY
Business statistics and analysis specialisation
- 07 Oct 2019
- Coursera
Build data analysis and business modelling skills. Gain the ability to apply statistics and data analysis tools to various business applications.
DATA ANALYTICS COMMUNITY
Statistics for data science and business analytics
- 18 Oct 2019
Statistics you need in the office: descriptive and inferential statistics, hypothesis testing and regression analysis.
Terms of use
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.
Courses from the ICAEW Academy of Professional Development
EDUCATION AND TRAINING
Advanced data analytics: distribution, sampling, classification and regression | Various dates
- 15 Oct 2019
- Academy of Professional Development
Advanced analytics can help businesses predict outcomes and answer business questions such as “how much will a given customer spend on a particular product?” and “amongst our customers, who is more likely to respond positively to our new product?” The purpose of this day is to build or refresh the statistical skills of participants, with a particular focus on sampling and regression analysis.
EDUCATION AND TRAINING
Intermediate trend forecasting and analysis | Various dates
- 15 Oct 2019
- Academy of Professional Development
This one-day course introduces delegates to statistical forecasting. It is designed for anyone involved in business planning and performance analysis. The course uses a mixture of stimulating discussions and real-life case studies. Each concept will be carefully explained, its relevance to forecasting highlighted and show how the relevant calculations can be done in Excel.
Thought leadership
Our thought leadership is intended to change thinking and behaviour. We want to help our members do their jobs as best they can. Ultimately, this will enable people everywhere to do business with confidence..
Find out more 