ICAEW.com works better with JavaScript enabled.

Modelling tools

Learn about Power BI, Python, R, SQL and other modelling tools.
Contents
Back to top

Key concepts and resources

Exclusive Getting over the Excel hump
  • Webinar
  • 30 Oct 2019
A Data Analytics Community webinar on using programming languages for data modelling presented by Dr Rob Mastrodomenico.
Python v R for data science
  • Website
  • 31 Jan 2018
Overview and comparison of the benefits of R and Python - two popular programming tools for data science work.
Python Data Analysis Library
  • Website
  • 10 Oct 2019
PANDAS is an open source library providing high-performance, easy-to-use data structures and data analysis tools for the Python programming language.
Introduction to R
  • Website
  • 05 Jul 2019
Notes on R: a programming environment for data analysis and graphics.
Learn Power BI
  • Website
  • 04 Nov 2019
Official Microsoft Power Bi site with guided learning, samples, documentation and blogs.

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 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

Tools and their useage

Useful links from external websites on data modelling tools such as Power BI, Python, SQL and R.
DATA ANALYTICS COMMUNITY The definitive list of data analytics tools
  • 20 Jun 2019
  • Alexander Eakins
A list of useful software to use in data analytics, from initial data collection and mining to programming languages like R and Python.
DATA ANALYTICS COMMUNITY Beginners guide to Python
  • 26 Sep 2019
Official information on how to get started with Python, with links to tutorials.
DATA ANALYTICS COMMUNITY Beginners SQL tutorial
  • 09 Oct 2019
This beginner SQL tutorial website teaches you the basics of SQL code and trains you how to write and programme SQL queries.
DATA ANALYTICS COMMUNITY Introduction to R
  • 05 Jul 2019
  • W N Venables, D M Smith, R Core Team
Notes on R: a programming environment for data analysis and graphics.
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

eLearning courses

DATA ANALYTICS COMMUNITY Statistics with R specialisation
  • 09 Oct 2019
  • Coursera
Master statistics with R. Statistical mastery of data analysis including inference, modelling and Bayesian approaches.
DATA ANALYTICS COMMUNITY Learn: Python
  • 17 Oct 2019
Acquire new skills fast in courses that combine short expert videos with immediate hands-on-keyboard exercises. A collection of courses using Python, from an introduction, to modules and data importing, data cleaning, and data visualisation all using Python.
DATA ANALYTICS COMMUNITY Data Science A-Z™
  • 21 Oct 2019
This course will give you a full overview of the data science journey. Upon completion, you will know: how to clean and prepare your data for analysis; how to perform basic visualisation of your data; how to model your data; how to curve-fit your data; and how to present your findings.
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 SQL programming - the next level | Various dates
  • 18 Oct 2019
  • Academy of Professional Development
Learn to write powerful, customisable SQL queries directly to the database that are lightweight and fast. This course will give you the foundation to build upon and, in future, produce some reports that your application is unable to currently generate. Liberate yourself from the limitations of an application and IT department – simply do it yourself.
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.
LEARNING AND PROFESSIONAL DEVELOPMENT Introduction to R | Various dates
  • 17 Oct 2019
  • Academy of Professional Development
This course is intended as an introduction to the R programming language for individuals working in the financial sector. Through the use of taught material and practical examples, which all have a financial twist, participants will build up the skills needed to perform data analysis using R.
LEARNING AND PROFESSIONAL DEVELOPMENT SQL fundamentals | Various dates
  • 15 Oct 2019
  • Academy of Professional Development
You may have heard of SQL Server and that it can be an incredibly useful tool, but what exactly is it and how can you utilise it? This course provides a gentle introduction and will teach you the basics of formulating SQL statements that you can then use to directly query a database.
LEARNING AND PROFESSIONAL DEVELOPMENT Introduction to Python | Various dates
  • 17 Oct 2019
  • Academy of Professional Development
This course is intended as an introduction to the Python programming language for individuals working in the financial sector. Through the use of taught material and practical examples, which all have a financial twist, participants will build up the skills needed to perform data analysis using Python.
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.