Data Wrangling, Analysis and Visualisation

Overview

Overview

Duration 3 days
Course Time 9:00am to 5:00pm
Enquiry Click here to contact us
This course is delivered by Singapore Polytechnic.

Data Wrangling, Analysis and Visualisation are critical skills that are necessary in the handling the challenges in a variety of modern-day data-driven businesses. In today's era of big data where the computer and network are everywhere and business process may be translated to data, data manipulation and visualisation skills are much needed to make insightful decisions. Knowledge in data analysis and visualisation provide one with the necessary skills that form the basis for deeper quantitative reasoning needed for data and predictive analytics work. Data may be in abundance; however, making it comprehensible and meaningful to stakeholders require a data driven skillsets.

This course enables the skills to turn raw datasets into interactive and dynamic visualisations and dashboards providing the platform to draw insights for decision making.


Key Takeaways

Key Takeaways

This course aims to equip participants with the skills to clean data, perform simple analysis and create useful and interactive visualisations and dashboards for presentation and recommendations to stakeholders. Participants will learn how to achieve this using Excel and Tableau software.

By the end of the course, participants will be able to:

  • Prepare, clean, format and manage data using Excel for analysis
  • Summarise and represent data meaningfully using excel for further analysis and decision making
  • Prepare and manipulate data for visualisation using Tableau
  • Visualise data using Tableau basics
  • Apply advanced visualisation using charting capabilities in Tableau
  • Build Interactive Dashboards using Tableau

Who Should Attend

Who Should Attend

This course is targeted at:

  • Data Analysts
  • Business and Quantitative Analysts
Prerequisites

Basic communication skills in the English language. Experience in working with data would be an advantage


ICT and SS Competency Framework

ICT and SS Competency Framework

As part of the ICTCF, this course falls under the Data Science & AI functional cluster and tagged to the following competencies:
  • Apps Management: Data Management & Analytics
  • Data Science & AI: Data Collection
  • Data Science & AI: Data Quality
  • Data Science & AI: Exploration Analysis
  • Data Science & AI: Statistical Techniques
  • Data Science & AI: Machine Learning
  • Data Science & AI: Visual Analytics Principles
  • Data Science & AI: Charts & Dashboards
  • Data Science & AI: Data Storytelling
  • Data Science & AI: Scripting
The course is mapped to the following job roles:
  • Digital Business Analyst
  • Digital Services Manager
  • General Public Officers
  • Quantitative Analyst

Course Structure

Course Structure

This course is delivered via instructor-led virtual mode and will cover the following topics:

Part 1 Collecting and Managing Business Data

  • Getting external data from various sources (CSV files, text files, database files, web data, etc.).
  • Preparing and cleaning data using text manipulation (trimming spaces, extracting parts of the cell to create a new column, replacing values etc.)
  • Extracting data with Essential Formulae/Functions.
  • Formatting and conditional formatting.
  • Tapping into real data from Internet for business analysis.
  • Data format required for analysis

Part 2: Understanding your Data

Data Calculations and Management

  • Using functions and formulae for calculations and data preparations.
  • Exploring data using AutoFilter and Excel tables.
  • Summarising and analysing worksheet data using PivotTables
  • Visualising summary report using PivotCharts

Decision making using What-If Analysis

  • Using Goal Seek to find desired output.
  • Building Data Tables for sensitivity analysis.
  • Using Scenario Manager for reporting different scenarios.

Part 3: Prep your Data with Tableau Prep

Tableau Prep Introduction

  • Tableau Prep Interface and Options
  • Tableau Prep Cleaning Options
  • Reading multiple sheets and files
  • Data aggregation
  • Workflow and joining files
  • Pivot data with Tableau Prep

Part 4: Visualising your Data

Tableau Basics

  • Visual Analytics Principles
  • Intro to Tableau software
  • Basic data import
  • Basic chartsBasic sorting
  • Basic filtering and paging
  • Using ShowMe
  • Basic Dashboarding
  • Tableau Story Design

Advanced Tableau Charting

  • Geographical maps
  • Histograms, scatter plots, box plots
  • Calculated fields
  • Clustering using Tableau
  • Sharing charts and dashboards

Interactive Dashboarding

  • Action filters
  • KPIs and Parameter controls
  • Groups and Sets

Instructors

Instructors


Fees and Funding

Fees and Funding


Full Fee

Full course fee

S$650

7% GST on nett course fee

S$45.50

Total nett course fee payable, including GST S$695.50


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: 3 days

19 Oct 2022 to 21 Oct 2022 (Full Time)

When :
Oct:
19, 20, 21

Time : 9:00 AM to 5:00 PM
Registration:

Class 2

Duration: 3 days

23 Nov 2022 to 25 Nov 2022 (Full Time)

When :
Nov:
23, 24, 25

Time : 9:00 AM to 5:00 PM
Registration:

Class 3

Duration: 3 days

21 Dec 2022 to 23 Dec 2022 (Full Time)

When :
Dec:
21, 22, 23

Time : 9:00 AM to 5:00 PM
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.