Trajectory: Qualified Data Translator in Finance

In the dynamic landscape of the finance industry, financial data has emerged as a powerful force. While data scientists with advanced degrees play a crucial role, a new position is on the rise - the Business Data Translator. These professionals possess a deep understanding of finance coupled with a strong aptitude for financial data, eliminating the need for an advanced data-related degree.

Business data translator excel in transforming complex data analytics into actionable insights and strategic plans for organizations. They closely collaborate with data scientists and analysts to ensure that analytical solutions align with business goals. These experts serve as part strategist and part project manager, focusing on key questions, defining project scopes, and ensuring that analyses lead to tangible actions.

Communication is key. They skilfully present their findings to various stakeholders, both technical and non-technical.

Embark on the trajectory of mastering data translation in finance and become a proficient Qualified Data Translator in Finance.

By the end of this training, participants will be able to:

• develop data literacy by understanding basics, types, and sources for informed decision-making;
• master advanced data modelling in MS Excel with Power Pivot and DAX, and create interactive visualizations with Power BI;
• gain proficiency in SQL and Python for data retrieval and analysis;
• excel in translating complex analytics into actionable insights, presenting findings effectively, and acting as a project business manager.

Groupe cible

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;
• …

Connaissances préalables

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.

Méthodologie

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

Professeurs

Betsy Calcoen
Personal development

Kevin Francus
Personal development

Tom De Witte
Personal development