Data analytics courses
Our Excel data analysis course and data analysis training will give you the skills to harness the power of big data, gain predictive and prescriptive analytical skills and transform the way finance adds value to the business. Our data analytics courses cover an array of topics in data analytics, including data visualisation, programming languages, and Excel training.
All CDP data analysis training courses are live virtual classrooms and can be delivered in-house.
Virtual data analytics courses
Data visualisation
Gain accessible and comprehensive understanding of the subject of data visualisation: how to effectively communicate data visually.
Data Analytics Certificate
Excel FP&A – system data and automating month-end reporting
An Excel course to help you to apply best practice techniques to extract information from databases and produce monthly management accounts and rolling strategic plans.
Excel modelling - decision support, Monte Carlo analysis and using Visual Basic
This course will provide you with skills to apply best practice Excel and Visual Basic techniques to produce an enhanced business model with Monte Carlo analysis and dependency ranking of assumptions.
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 with this Excel data analysis course.
Introduction to Python
Discover the high-level programming language for general-purpose programming, an introduction to Python.
Month-end in Power BI
Increase the impact, efficiency and accuracy of your commercial month-end reporting by learning how to build dynamic, real time close reports in Microsoft Power BI.
Power Query: Streamline the automation of key business reports
This big data training course will help you to extract, load, customise and transform data automatically, freeing you up to append more time analysing and less time preparing reports.
Use SQL to gain powerful insights
Understand the basics of SQL and empower yourself to formulate SQL statements and directly query your databases.
Additional data analytics courses available for in-house delivery
For more information on how you can run any of the below data analysis training courses for your team or to find out how they can be tailored to your company, please email academy@icaew.com.
Advanced data analytics: distribution, sampling, classification and regression
Advanced analytics training can help businesses predict outcomes and answer business questions.
An introduction to statistical data analysis
This one day data analysis training 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.
Intermediate trend forecasting and analysis
A data analysis training course covering how you can prove a trend exists using statistical analysis and then extrapolate trends to create forecasts.
Introduction to R
This course is intended as an introduction to the R programming language for individuals working in the financial sector.
PivotTable refresher and Power Pivot
During this excel data analysis course you will learn to create more powerful PivotTable reports, summarise multi-dimensional PivotTables and dissect data to produce detailed information for business reporting and forecasting purposes with this data analytics course.
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.