Trajectory: Qualified Data Translator in Finance

Target group

This training course can be followed by multiple target groups:

• employees who want to develop their financial data skills:
• process & Business analysts:
• business manager in insurance companies or financial institutions:
• product manager:
• anyone who wants to increase his/her knowledge with regard to data analysis;
• …

Required prior knowledge

Advanced level training: this training requires a general basic knowledge of the subject.

Programme

CONTENT

Module 1 : Introduction to Data Literacy (duration 2h live webinar)

Lecturer: Tom De Witte

• Understanding the fundamentals of data and its relevance in decision-making.
• Exploring key concepts such as data types, data sources, and data quality.
• Developing effective communication skills to convey data insights to various stakeholders.

Module 2 : Advanced Data Analysis in MS Excel: Power Pivot & DAX (duration 1 day 6h classroom)

Lecturer: Betsy Calcoen

• Mastering advanced data modelling techniques using Power Pivot.
• Introduction to Data Analysis Expressions (DAX) for creating powerful formulas in Excel.

Module 3 : SQL Fundamentals (duration 2 days, 6h classroom per day)

Lecturer: Kevin Francus

• Understanding the basics of Structured Query Language (SQL).
• Practical application of SQL for data retrieval, manipulation, and database management.

Module 4 : Python for data analyses (duration 1 day 6h classroom)

Lecturer: Tom De Witte

• Basic introduction to Python programming language.
• Hands-on exercises for data manipulation and analysis using popular Python libraries.

Module 5 : Power BI  (duration 2 days, 6h classroom per day)

Lecturer: Betsy Calcoen

• Introduction to Power BI for creating interactive and insightful data visualizations.
• Building dashboards and reports to communicate data-driven insights effectively.

PRACTICAL INFORMATION

• Duration: 6 days of training (6 x 6 class hours) + 2h live webinar
• Hours:
  • Live webinar : 10:00 to 12:00 
  • Classroom training : 09:00 to 17:00
• Location: Febelfin Academy: Phoenix building, Koning Albert II-laan/Boulevard du Roi Albert II 19, 1210 Brussels
• Language: This training will be given in English.
• Qualification: This course gives you a complete overview through 5 modules.  The course leads to the certification "Qualified Data Translator in Finance" after successful completion of all modules and the accompanying test. 
• Examination information: After following the modules, one can obtain the certification "Qualified Data Translator in Finance" at the conclusion of the full programme and after completing a successful examination. The tests for module 1 & 4 at the end of the course consist of multiple-choice questions (no disc correction). You get 2 attempts to pass these tests.  The tests for modules 2, 3 & 5 consist of group assignments.  These cannot be retaken. For a satisfactory result, you must obtain at least 60% for each module. If you pass, you will receive the certificate proving that you have passed the test and that you have the required technical knowledge. One must complete the online-tests within a month of taking the training.

Methodology

You follow a ‘Classroom training’ in a group. You, the other participants and the teacher are all present in the same classroom at an agreed time. There is an opportunity for interaction and feedback, both from the participants to the teacher and vice versa. The teaching material consists as a basis of a presentation via the MyFA learning platform, supplemented with various other items (such as digital syllabus, presentation, audiovisual fragments, etc.).

Training material: 

• PowerPoint slides
• Various pre-course materials