Introduction to Data Cleansing, Shaping and Synthesis

This course aims to equip participants with the skills and knowledge to clean, shape and synthesise data in preparation for data-driven business decision making.

Participants are trained to retrieve data from multiple sources, recognise common data quality issues, correct data quality issues, derive new data from existing data, perform aggregation of data, supplement data with additional external sources, and store cleansed and transformed data in different formats.

Learning Objectives

  • Describe the different data quality and preparation scenarios that necessitate data cleansing and transformation.
  • Perform retrieval of data from multiple sources, e.g. .csc, .xlxs
  • Apply appropriate data cleansing and transformation practices to address data quality issues using Tableau Prep Builder.
  • Derive new data from existing data through segmentation, combination and aggregation.
  • Explain the limitations of data cleansing and transformation software.
  • Include additional data from external resources accessible through APIs, e.g. currency exchange rates.
  • Store cleansed and transformed data in different formats, e.g. .csv & Tableau packages.

Who should attend?

Business users or officers who run non-technical projects and programmes; and/or produce business reports. Other functional roles involve basic data recording, collection, handling, analysis, and reporting.

Entry Requirement

Basic computer literacy. Some working knowledge of Excel is beneficial but not critical.


Participants will be awarded a certificate of completion upon meeting the 75% course attendance requirement.

For courses with assessment component, participants will be awarded the certification of completion upon passing the assessment. Otherwise, a certification of attendance will be issued instead upon meeting the 75% course attendance requirement.

Course Dates

Click "APPLY NOW" to check available course dates and to register.

Course Duration

2 days

If you are not available on the dates listed in our registration portal, we would like to hear from you by clicking here

Fees for 2022

Full course fee (with GST) Singapore Citizens aged 39 & below OR Singapore PR Singapore Citizens aged 40 & above SME-sponsored Singapore Citizens OR Singapore PR
$545.70 $163.71 $54.57 $61.71

Fees for 2023

Full Course Fees (with GST) Singapore Citizens aged 39 & below Singapore Citizens aged 40 & above Singapore PR SME-sponsored Singapore Citizens SME-sponsored Singapore PR
$550.80 $163.71 $54.57 $165.24 $61.71 $63.24
- Payment may be made using SkillsFuture Credit.
- Fees reflected are inclusive of Goods and Services Tax (GST). In line with the government fee freeze directive from 1 Jan to 31 Dec 2023, the fees in 2023 for Singapore Citizen will remain the same as 2022. RP will absorb the additional 1% GST for Singapore Citizen in 2023 only.

Republic Polytechnic reserves the right to make changes to the course fee and application closing dates without prior notice. The commencement of each course is subject to sufficient number of participants. 

All information is accurate at time of publishing. 

Last updated on 17 Nov 2022

Need more help?

If you are still unsure about which course to pursue, please contact our Academy for Continuing Education