Data Analytics
Harness the power of big data, gain predictive and prescriptive analytical skills and transform the way finance adds value to the business.
All courses are live virtual classrooms and can be delivered in-house.
Virtual classrooms
Data visualisation
Gain accessible and comprehensive understanding of the subject of data visualisation: how to effectively communicate data visually.
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.
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.
Introduction to SQL
Understand the basics of SQL and empower yourself to formulate SQL statements and directly query your databases.
PivotTable refresher and Power Pivot
Create more powerful PivotTable reports, summarise multi-dimensional PivotTables and dissect data to produce detailed information for business reporting and forecasting purposes.
Power Query: Streamline the automation of key business reports
This 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.
Additional courses available for in-house delivery
For more information on how you can run any of the below courses for your team or to find out how they can be tailored to your company, 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.
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.