Data Extractor – Intermediate

Course Objective:

The purpose of the course is to give participants advanced knowledge about our integrated Data Extractor tool and the Dimension database that it is used.

You know how to create a simple DEX but sometimes:

  • You get multiplied outputs in inline views / joined tables
  • You cannot find a path to the more exotic fields
  • You cannot get the right aggregation level of some values
  • In general, understand the concept of Data Extraction but feel you could use some more practice

The course will be a mixture of theory, SimCorp Dimension presentations, hands-on exercises and Home assignments. A 1-on-1 session is organized to go through the assignments and discuss questions, problems faced.

Main Learning Topics:

Database Overview
Data Extractor (DEX) – Basic

  • Extraction Definitions
  • Extraction Setups
  • Extracts Exporter
  • Extracts Viewer

Data Extractor (DEX) – Advanced

  • Inline View
  • Sub query
  • Formulas
  • DEX in DEX / Extract table
  • Plugins

Reference Files

  • Standard
  • Smart

Homework Assignments & 1-on-1 session to discuss the assignments

Pre-requisites:

  • Ability to use Skype with an external party (SimCorp) for the 1-on-1 session
  • Basic knowledge on and hands on experience creating simple Extraction Definitions
  • Basic knowledge on the table structure of SimCorp Dimension

Duration:

Days: 1 day Course + 1-on-1 skype session
Daily training hours: 9:00-17:00

How to register for this course:

Click your preferred date below and register by filling out the form.
If no date is found for your preferred course please contact [email protected] to request the course.