Data Wrangling, Analysis and Visualisation

Course Date:
To be confirmed

Registration Period:
To be confirmed

Duration:
21 hours / 3 days

Time:
9am to 6pm (Tues, Wed and Thurs)

Mode of Training:
Classroom

Venue:
Singapore Polytechnic


Course Introduction
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.


Course Objective
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.


Course Outline

This course aims to equip participants with the skills to clean data, perform simple analysis and create useful and interactive visualizations 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
• Summarize and represent data meaningfully using excel for further analysis and decision making
• Prepare and manipulate data for visualisation using Tableau
• Visualize data using Tableau basics
• Apply advanced visualisation using charting capabilities in Tableau
• Build Interactive Dashboards using Tableau

Course Content & Structure

Topic
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.
□ Summarizing 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 charts
□ Basic 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

Suitable for
Data Analyst, Business and Quantitative Analysts


Minimum Entry Requirements / Assumed Skills and Knowledge
Basic communication skills in the English language. Experience in working with data would be an advantage.


Award / Certification / Accreditation
• Certificate of Performance (electronic Certificate)
A Certificate of Performance will be awarded to participants who pass the examination and meet at least 75% attendance rate

Course Fees payable:

Singapore Citizens aged below 40 and Singapore PRsSingapore CitizensOthers
Non-SME sponsored1Sponsored by SME2Aged 40 and aboveNil
$208.65
(incl. GST)
$78.65
(incl. GST)
$78.65
(incl. GST)
Nil$695.50
(incl. GST)

Singaporeans aged 25 years and above may use **SkillsFuture Credit balance to offset respective course fees.
1 Under the Enhanced Training Support for Small & Medium Enterprises (SMEs) Scheme. For more information, click herePlease submit the attached “Declaration Form for Enhanced Training Support Scheme for SME” together with your online application.
2 Under the SkillsFuture Mid-career Enhanced Subsidy. For more information, visit the SkillsFuture website here.


Funding Incentives

Please click here for more information on funding incentives.


 

Register Here
Eligible for SkillsFuture Credit

Terms and Conditions

*Please note that once the maximum class size is reached, the online registration will be closed.

Application Procedure

1. All applications must be made via Online Registration at www.pace.sp.edu.sg
Course fees can be paid by the following payment modes:

a) Credit Cards, Internet Banking, NETS (Not Applicable for company sponsored)
For e-payment using Visa/Master cards and Internet Banking, please click on the ‘Make e-Payment’ button on the acknowledgement page to proceed.

b) For NETS payment, you can pay at:
Singapore Polytechnic
PACE Academy

c) Cheques
Please make cheques payable to “Singapore Polytechnic”. Do cross the cheque and write the Registration Reference ID, Applicant Name and NRIC/FIN number at the back of the cheque. When you have completed required details, you may mail the cheque here

Please note that an administrative charge of $15 will be imposed for any returned cheques from the bank or financial institution.

2. All successful applicants will be notified with a letter of confirmation via email.

Chat with us