
- 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
- 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
IFRS in Practice - Part 2 [N155]