Work with Data Processing in DCS
Work with Data Processing in DCS is the beginner level course for “DCS for Actuarial” series, which aims to introduce underlying concepts of data processing using DCS (“Data Conversion System”), which is a supplementary application comes along with the popular actuarial software, Prophet. DCS is widely used by actuarial expertise in preparing Model Point files for Prophet, as well as some data manipulation exercises required for actuarial valuation and experience studies.
This course is organized using “building-block” approach, starting with introducing crucial components in DCS. Course Participants learn to perform runs and produce results under different requirements, such as Model Point files on both seriatim and grouped basis. Furthermore, Course Participants also learn how to create a new DCS program used to handle different types of policy data files and reporting requirements.
Through this solving-based course, the Course Participants will learn techniques that are useful and relevant to their daily work, as the problems presented during this course are simulated from the real-life actuarial works of an insurance company.
Course Level: Beginner
Target Audience: New actuarial entries / Junior & senior actuarial executives (1-3 years of experience) / Actuarial valuation team
Course Outlines
Chapter 1: What is DCS?
This Chapter covers a walkthrough on the key components of DCS, including run settings, codes, input format, output format. Course participants will obtain an overall idea of the characteristics and functions of each component above.
Chapter 2: Perform Runs Using Different Data Files
This Chapter explains how a data processing exercise is carried out in DCS, specifically used to generate Model Point files for Prophet runs – by using sample programs created for this Course. Upon completion of run, Course Participants learn to reconcile the input and output files using data summary files.
(Not Included. Stated here to provide complete explanation on topics covered under Chapter 2) In addition, Course Participants learn the techniques used to update run setting and input formats, to handle changes made in the data files. These changes include:
- Addition or deletion of fields in input file.
- Change of field types (from number to text or vice versa).
- Change of field delimiters.
- Addition or deletion of variables to be included in the result files.
Photo by Joel Filipe on Unsplash