Fundamentals of Data Wrangling, Analysis & Visualisations

Overview

Overview

Duration 4 days
Course Time 9.00am -5.00pm
Enquiry Click here to contact us

This course is delivered by Republic Polytechnic.

Harness the power of data to gain perspectives you never thought available. This course will provide participants 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

Key Takeaways

At the end of this course, the participants will be able to:

  • Apply data cleansing and data transformation techniques
  • Apply mathematical and statistical functions for deriving insights from 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

Who Should Attend

This course is ideal for managers, professionals, executives and support staff 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
Participants should have basic IT literacy.


ICT and SS Competency Framework

ICT and SS Competency Framework

As part of the ICTCF, this course falls under the Data Science & AI functional clusters and tagged to the following competencies:
  • Data Collection
  • Data Quality
  • Exploration Analysis
  • Statistical Techniques
  • Machine Learning
  • Visual Analytics Principles
  • Charts & Dashboards
  • Data Storytelling
  • Scripting

The course is mapped to the following job roles:
  • General Public Officers

Course Structure

Course Structure

This instructor-led course 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

Instructors

Instructors


Fees and Funding

Fees and Funding


Full Fee

Full course fee

S$1140

7% GST on nett course fee

S$79.80

Total nett course fee payable, including GST S$1219.80


NOTE: Funding is available for this course. Please visit the training provider’s website to find out about the updated course fee funding breakdown, eligibility, terms and conditions.

Upcoming Classes

Upcoming Classes

Class 1

Duration: 4 days

11 Oct 2022 to 14 Oct 2022 (Full Time)

When :
Oct:
11, 12, 13, 14

Time : 9.00am - 5.00pm
Registration:

Class 2

Duration: 4 days

03 Nov 2022 to 08 Nov 2022 (Full Time)

When :
Nov:
03, 04, 07, 08

Time : 9.00am - 5.00pm
Registration:

Class 3

Duration: 4 days

13 Dec 2022 to 16 Dec 2022 (Full Time)

When :
Time : 9.00am - 5.00pm
Registration:

How To Register

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 course.

Your organisation will send registration information to the academy.

Organisation HR L&D or equivalent staff can click here for details of the registration submission process.


Step 3 The Digital Academy will inform you whether you have been successful in enrolment.