ICAEW.com works better with JavaScript enabled.

Data modelling

Find out about modelling, mining and statistical techniques.
Contents
Back to top

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.

View all

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
  • 06 Nov 2018
  • PDF (1,590kb)
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.
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.

View all

Courses from the ICAEW Academy of Professional Development

LEARNING AND PROFESSIONAL DEVELOPMENT 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.
LEARNING AND PROFESSIONAL DEVELOPMENT 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.
LEARNING AND PROFESSIONAL DEVELOPMENT Introduction to statistical data analysis and trend forecasting | Various dates
  • 27 Mar 2019
  • Academy of Professional Development
This one-day course from ICAEW introduces delegates to statistics and analysis and takes them through the six key concepts that underlie all statistical thinking and analysis: probability, risk, distribution, expectation, variance and correlation. The course shows delegates how to apply these concepts using Microsoft Excel.
View all

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 a world of sustainable economies.
Find out more
Rodin's The Thinker
Information

Some of the content on this web page was provided by the Chartered Accountants’ Trust for Education and Research, a registered charity, which owns the library and operates it for ICAEW.