Advanced Data Analytics and Visualisation

Offered by School of Interdisciplinary Studies

SkillsFuture Career Transition Programme (SCTP) / 3 months / TGS-2022012589

Course Information
Learning Outcomes
Course Schedule
Lesson Plan
Certification
Entry Requirements
Course Fees

Course Information

The Advanced Data Analytics and Visualisation Course allow participants to acquire advanced skills in one of the most important workplace computer programmes, MS Excel, to optimise data analysis. Through the course, participants will acquire data visualization techniques to represent data in an accessible and easy-to-understand manner.  They will also be equipped to analyse data, perform predictive modelling and build data analytics projects using workplace data sets.

This part-time course is relevant for the following job roles- Administration Manager, Data Operations/Admin Executive, Admin Assistant, Data Entry, Data Curator.

Learning Outcomes

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

  • Acquire information organisation and processing techniques efficiently
  • Cleanse, prepare and manipulate data that will be useful for analysis
  • Build data visualisations and dashboards using MS Excel to obtain insights and for reporting
  • Perform data analytics using Excel tools and predict data using regression models
  • Create automated data processes for organisations

Course 
Schedule

Course Date: Jan 2023
Application Period: TBC
Duration: 3 months (part-time)
Time: TBC
Delivery Mode:  Classroom and Online
Venue: TBC

Lesson Plan

Data Preparation & Visualisation with MS Excel
  • Using data types in Excel
  • Data collection and validation
  • Data preparation
  • Formula and functions
  • Understanding good data visualisation practices
  • Obtain insights with data visualisation using charts and Pivot tables/charts
1.2 Data Analytics (MS Excel) & Reporting Skills
  • Analyse data
  • Data analytics
  • Predictive modelling
  • Building a dashboard with intermediate Excel tools (slicers, timelines etc.)
  • Effective Reporting and Data Communication
1.3 Automated Data Processing
  • Automation with Macros
  • Macros with VBA
  • Basic programming with VBA
  • Basic automation with TagUI
1.4 Project/Practicum
  • Apply acquired skills on workplace data sets
  • Build a data analytics project

 

Certification

Certificate of Performance will be awarded to participants who achieve at least 75% attendance and pass assessments.


Entry Requirements

Applicants with any of the following qualifications are invited to apply for the course:
  1. The following GCE ‘O’ Level grades and with at least 3 years of relevant work experience:
    – English Language (Grade 1-6)
    – Mathematics (Grade 1-6)
    – One other subject(Grade 1-6)
  2. NITEC with GPA >=3.5 with at least 2 years of relevant work experience
  3. Higher NITEC with at least 1 year of relevant work experience
  4. NITEC in Technology or Services with GPA >= 3.5 and with at least 2 years of relevant working experience
  5. Higher NITEC in Technology or Services with at least 1 year of relevant working experience
  6. Relevant WSQ Diploma qualifications (depending on sector, Programme & level – bridging course may be required) with at least 3 years of relevant working experience
  7. WPLN (Level >= 6) may be accepted as ‘O’ Level equivalent English Language & Mathematics requirements

Preferred: have a working knowledge of Microsoft Office e.g. Word, Excel and Powerpoint.

Important: Students enrolled in the course are expected to bring their personal laptops with the Windows 10 operating system.

 

Course Fees

Funding period for this course is from 1 Oct 2021 to 30 Sep 2024.

SkillsFuture Credit
All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses. Visit the SkillsFuture Credit website to choose from the courses available on the Training Exchange course directory.

Union Training Assistance Programme (UTAP)
NTUC members enjoy 50% unfunded course fee support for up to $250 each year (or up to $500 for NTUC members aged 40 years old and above) when you sign up for courses supported under UTAP (Union Training Assistance Programme). Please visit e2i’s website to find out more.

*Additional course fee funding
Additional course fee funding support of up to 95% of course fees for jobseekers with greater needs. Individuals must be Singapore Citizens and meet one of the following eligibility criteria:

  • Long-term unemployed individuals (unemployed for six months or more); or
  • Individuals in need of financial assistance – ComCare, Short-to-Medium Term Assistance (SMTA) recipients or Workfare Income Supplement (WIS) recipients; or
  • Persons with Disabilities

For more information on course fee subsidies, please refer to SSG website here.

Ngee Ann Polytechnic reserves the right to reschedule/cancel any programme, modify the fees and amend information without prior notice.

(Course fee is payable upon acceptance. It is inclusive of 7% GST and subject to review.)

GST payable for all funding-eligible applicants* $210
GST payable for full course fees $700

*As per SSG’s policy, the GST payable is calculated based on 7% after the baseline funding subsidy of 70%.

Applicants / Eligibility Fees
Full course fee$10700.00
Singaporeans aged below 40, Permanent Residents$3210.00
Singaporeans aged 40 & above qualified for SkillsFuture Mid-Career Enhanced Subsidy$1210.00
Eligible Applicants for Additional Course Fee Funding Support*$710.00