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.
Certification
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 |
Notes:
- 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.