Mastering fundamental data calculations: Introduction to AI algorithms [D497]
  • Data analytics, statistics, data analysis - Fundamental knowledge of statistics, data analysis (including correlation, regression and segmentation) and forecasting methods - Growth (decay), index calculations
  • Modeling, simulation, scenarios - Modeling, simulation, scenarios
  • Spreadsheets for finance (Excel ) - Mastery of spreadsheets for finance

Acquire the fundamentals

Target audience

- Financial analysts
- Internal auditors
- Bankers / Account managers
- Financial managers and controllers
- Chartered accountants
- Treasurers

2 day

Prerequisites

No special prerequisites are required.

Objectives

- Understanding the basics of AI algorithms

- Know and use the tools and data analysis useful in corporate finance

Contents

> Definitions and reminders

- Notions of individual, variable, population, sample
- Indicators of distribution, shape, positioning and dispersion

> Learn about the main dataviz graphics: how to construct and interpret them

> Advanced

- Notion of inference
- The main statistical tests
- How to establish a confidence interval

> Application of data science tools on spreadsheets (Excel)

- Identify a correlation (with quantitative and/or qualitative variables) and measure its intensity
- Model a linear regression (with two or more variables) and judge its quality
- Reduce typical curves (logarithmic, exponential, logistic, etc.) to a linear function
- Set up clusters , create categories and measure their relevance
- Know Bayesian statistics and the conditional approach

Why choose this course?

Knowledge of the fundamentals of statistics and associated mathematical calculations is a prerequisite for Data Analytics. This course takes a fun, visual approach to these concepts, making them accessible to everyone. The majority of FinHarmony's Data Analytics training courses are based on the knowledge acquired during these two days.

Teaching and assessment methods

Before : practical information sheets on each tool

During the session: alternating theoretical developments, illustrations and fun, interactive case studies, scripted in several stages. These numerous exchanges help validate the acquisition of skills throughout the course.

After: the participant keeps all Excel templates.
The trainer is available to answer any questions relating to the training.

General training | FinHarmony Conseil & Formation

See our full training catalog.

Price

1,860 EXCL.

Media

Testimonials

Data fundamentals training

Data fundamentals training

Data fundamentals training

Jonathan C.
Company
Training