DSAI

Fundamentals of Data Wrangling, Analysis & Visualisations

Enquiry
Programme Code D120
Domain
General Digital Literacy
Data Science & AI
Level
Foundation
Learning Partner(s)
Republic Polytechnic
Duration
4 Days
Format In-person
Rating
Competencies
Machine Learning Statistical Techniques Scripting Exploration Analysis Data Storytelling Data Science Data Collection Charts & Dashboards
Job Roles
Public Service Officer (non-ICT&SS)

Overview

Harness the power of data to gain perspectives you never thought available. This programme will provide you with a good foundation to conduct data wrangling, perform data analysis, create effective visualisation charts, build interactive dashboards and compose convincing data-driven stories using Microsoft Excel and Tableau to support data-driven business decisions.

Key Takeaways

At the end of this programme, you will be able to:
  • Apply data cleansing and data transformation techniques
  • Apply mathematical and statistical functions to derive insights from the data
  • Create PivotTables and PivotCharts to calculate, summarise, analyse, and visualise data
  • Apply visualisation principles for creating effective visualisations
  • Create and interpret visualisation charts
  • Build interactive dashboards for monitoring key metrics
  • Create data-driven stories for communicating key insights

Who Should Attend

  • Please refer to the job roles section.
  • Ideal for Public Service Officers who are interested to conduct data wrangling, perform data analysis, create visualisation charts, dashboards, and data stories using Microsoft Excel and Tableau to support data-driven business decisions.

Prerequisites

You should have basic IT literacy.

Programme Structure

This instructor-led programme is delivered both physically and virtually, and will cover the following topics:

Day 1 & Day 2 (Using MS Excel)
  • Data Collection
  • Data Wrangling
  • Data Exploration & Analysis
  • Data Mining Techniques
   
Day 3 & Day 4 (Using Tableau)
  • Data Visualisation Principles
  • Tableau 101
  • Interactive Data Visualisation
  • Interactive Dashboard
  • Data-Drive Stories

Full Fee

Full programme fee

S$1140

9% GST on nett programme fee

S$102.60

Total nett programme fee payable, including GSTS$1242.60

With effect from 1 Jan 2024

NOTE
Funding is available for this programme. Please visit the learning partner’s website to find out about the updated programme fee funding breakdown, eligibility, terms and conditions.

Upcoming Classes

Class 1
09 May 2024 to 14 May 2024 (Full Time)
Duration: 4 days
When: May - 09, 10, 13, 14
Time : 9.00am - 5.00pm
Class 2
06 Jun 2024 to 11 Jun 2024 (Full Time)
Duration: 4 days
When: Jun - 06, 07, 10, 11
Time : 9.00am - 5.00pm
Class 3
18 Jul 2024 to 23 Jul 2024 (Full Time)
Duration: 4 days
When: Jul - 18, 19, 22, 23
Time : 9.00am - 5.00pm
Class 4
15 Aug 2024 to 20 Aug 2024 (Full Time)
Duration: 4 days
When: Aug - 15, 16, 19, 20
Time : 9.00am - 5.00pm
Class 5
19 Sep 2024 to 24 Sep 2024 (Full Time)
Duration: 4 days
When: Sep - 19, 20, 23, 24
Time : 9.00am - 5.00pm
Class 6
03 Oct 2024 to 08 Oct 2024 (Full Time)
Duration: 4 days
When: Oct - 03, 04, 07, 08
Time : 9.00am - 5.00pm
Class 7
07 Nov 2024 to 12 Nov 2024 (Full Time)
Duration: 4 days
When: Nov - 07, 08, 11, 12
Time : 9.00am - 5.00pm
Class 8
20 Feb 2025 to 25 Feb 2025 (Full Time)
Duration: 4 days
When:
Time : 9.00am - 5.00pm
Class 9
06 Mar 2025 to 11 Mar 2025 (Full Time)
Duration: 4 days
When: Mar - 06, 07, 10, 11
Time : 9.00am - 5.00pm

How To Register


Agency-sponsored

Step 1 Apply through your organisation's training request system.

Step 2 Your organisation's training request system (or relevant HR staff) confirms your organisation's approval for you to take the programme. Your organisation will send registration information to the academy.

Organisation HR L&D or or equivalent staff can register directly through the learning partner's registration portal.

Click here to register for 9 to 14 May run.

Click here to register for 6 to 11 Jun run.

Click here to register for 18 to 23 Jul run.

Click here to register for 15 to 20 Aug run.

Click here to register for 19 to 24 Sep run.


Step 3 The learning partner will inform you whether you have been successful in enrolment.