Data Analysis

INTRODUCTION

Data and coding skills are becoming an essential tool for financial institutions.

We deliver programs covering these two topic areas for finance professionals and engineers to get them quickly up-to-speed on both the essentials and the more advanced.

Case Study: Combining Technical Training with Data Analytics at a Leading Securities Exchange

Data analytic tools, such as Python and SQL, are becoming increasingly sought after in the financial industry. But how quickly can firms skill up their employees?

A leading financial institution was looking to combine technical training with in-depth data analytics, ranging from advanced Excel and VBA to SQL. They approached us to design a program that would show graduates how and why data science is applicable to the finance industry in less than a week.

Our Solution

  • We assumed no prior programming experience to ensure that the course was accessible for everyone who attended.
  • Participants initially learned about financial products and their pricing, including regulatory considerations, follow by in-depth data analysis tools.
  • We tailored the course by incorporating project work and daily senior manager presentations.
  • Participants evaluated data attainment from new/alternate sources in the context of an acquisition by the financial institution, working closely with the data science team to establish a feasible solution.
  • Everyone was placed in groups of 2-3 people and assigned a project. As the group was composed of business and technology participants, we provided 2 business-based projects and 1 data/technology program.
  • On the final day of the training program FE, along with the client, assessed the live, virtual delivery of the final projects. It was a great culmination to the training program and provided the participants with feedback on their outputs as well as giving the business an assessment of their skills.

The Result

The program has proved such a success that it has been running over the past two years, delivered to both interns and graduates.

KEY STATS

77
Participants taught
14
Days of training in total, split between two programs
3
Expert instructors delivering the training
2
Years since the program first launched and continues to run today

Modules

SQL Applied to Finance

  • Getting started with SQL
  • Fundamental concepts
  • Organizing data
  • Manipulating data
  • Joining objects

JAVA Applied to Finance

  • Getting started with JAVA
  • Fundamental concepts
  • Building functions
  • Working with classes
  • Working with packages and API
  • Scenario learning

Python

  • Getting started
  • Basics
  • Building functions
  • Introduction to libraries
  • NumPy
  • Pandas
  • Matplotlib
  • Dates and times
  • Scenario learning

Types of client

INVESTMENT BANKS

ASSET MANAGERS

EXCHANGES

HEDGE FUNDS