ICAEW.com works better with JavaScript enabled.

Data Analytics

Harness the power of big data, gain predictive and prescriptive analytical skills and transform the way finance adds value to the business.

Please read

Due to the COVID-19 outbreak some courses have been postponed. The courses which are still running will be delivered virtually via virtual classrooms. See the virtual classrooms section below to view which courses are available.

Virtual classrooms

Excel modelling - investment appraisal, valuation and business cases

Apply best practice Excel techniques to produce a robust business model for the evaluation of investment opportunities.

Excel FP&A – system data and automating month-end reporting

Apply best practice Excel techniques to extract information from databases and produce monthly management accounts and rolling strategic plans.

Postponed courses (currently unavailable)

Courses which are currently unavailable can still be run for team bookings and tailored to company needs. For more information please email academy@iacew.com.

Advanced data analytics: distribution, sampling, classification and regression

Advanced analytics can help businesses predict outcomes and answer business questions.

An introduction to statistical data analysis

This one day course introduces delegates to statistics and analyses and takes them through the six key concepts that underlie all statistical thinking and analysis.

Business and analytical problem framing

To maximise the benefits that data and its analysis can offer, the analyst requires an understanding of the data-driven decision-making framework and its basic concepts.

Data preparation and ethics

Explore a range of different data sources and formats as well as the legal and ethical issues related to data-handling.

Data visualisation

Gain accessible and comprehensive understanding of the subject of data visualisation: how to effectively communicate data visually.

Intermediate trend forecasting and analysis

How you can prove a trend exists using statistical analysis and then extrapolate trends to create forecasts.

Introduction to Python

Discover the high-level programming language for general-purpose programming, an introduction to Python.

Introduction to R

This course is intended as an introduction to the R programming language for individuals working in the financial sector.

SQL fundamentals

Understand the basics of SQL and empower yourself to formulate SQL statements and directly query your databases.

SQL programming - the next level

Learn to write powerful, customisable SQL queries directly to the database that are lightweight and fast.

Successful data strategies and case applications in business

Get an up-to-date overview of big data and how to apply it to your organisation.