Key concepts and resources
Advanced analytics explained
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
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
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
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
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
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.
Techniques and applications
DATA ANALYTICS COMMUNITY
Data analysis methods: an overview
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
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
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
Why and how to cross validate a model?
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
ICAEW’s Excel Community has worked with a broad swathe of modelling organisations and experts, taking a half dozen methodologies and paring down to the commonly held, widely accepted beliefs about what constitutes good modelling. Thus, we’ve created the Financial Modelling Code.
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
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
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
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
View 49 videos covering many facets of machine learning and automation of data analysis.
DATA ANALYTICS COMMUNITY
High-throughput sequencing
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
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.
Courses from the ICAEW Academy of Professional Development
EDUCATION AND TRAINING
Advanced data analytics: distribution, sampling, classification and regression | Various dates
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
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.