(SCTP) Advanced Data Analytics and Visualisation (Classroom, Synchronous & Asynchronous e-learning)

Offered by School of Interdisciplinary Studies

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

Note: Please note that all applications for programmes will be done via STEP. Click the 'APPLY' button on this page to proceed to STEP. You are required to use your Singpass to activate your STEP account. To receive an alert about the future runs for this course, please click the 'INDICATE INTEREST' button. Thank you. STEP, the Skills Training and Enhancement Portal, is a one-stop digital platform for your training needs..
Course Information
Learning Outcomes
Course Schedule
Lesson Plan
Trainer Profile
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- Admin Executive, 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: End-Oct 2024 – Mid-Feb 2025
Application Period: End-July to 9 Sep 2024
Duration: 3 months (part-time)
Time: Tue, Wed, Thu evenings (6pm to 10pm)
Delivery Mode:  Classroom and Online
Venue: Ngee Ann Polytechnic/Online

For more information on course schedule, click here

 

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

 

Trainer's Profile

Hui Kah Seng

Hui Kah Seng graduated from NTU School of Physical and Mathematical Sciences with a BSc in Mathematical Sciences, majoring in Statistics.  

Kah Seng has worked on various projects involving analytics, implementation, prediction, and optimisation. The projects covered industrial application, process flow optimisation, automation, prediction, and decision-making. He has worked with our National Water Agency in the field of water usage analytics prior to joining Ngee Ann Polytechnic. 

In his time with NP, Kah Seng has helped kickstart departments’ analytics champions in their journey towards data-approached decisions, streamlining work processes with automation and reducing man-hours on tasks and processes. He was also involved in the implementation of the data-mart within NP and the usage of Tableau as the main analytical tool within the organisation. He has since embarked on CET courses, with successful runs using asynchronous materials that helped many adult learners bridge the gap on Data Analytics. 

Karen Tan

Educator, Data Analyst, Innovator, Certified Adult Trainer 

Karen is a youth-adult education specialist with over a decade of experience in crafting and delivering transformative training programmes in the field of data science, engineering mathematics, and innovation. She is adept at leveraging a unique blend of industry expertise, engaging communication, and innovative teaching methods to drive participant success. Committed to inspiring and empowering individuals and teams to achieve their full potential. 

In Ngee Ann Polytechnic, Karen leads the Data Science Bootcamp for adult learners, teaches Design Thinking & Innovation to youths, and mentors multiple interdisciplinary team projects.  

Outside of Ngee Ann Polytechnic, she is involved in diverse business and analytical projects, including analysing the Quality of Life of Singaporean Youths and Children in a Tableau tournament, enabling a research trial for an Autonomous Vehicle research project, investigating AI courseware and learning outcomes that prepare for the emerging industry needs, etc. 

Karen holds an M.Sc. in Management of Technology (National University of Singapore) and a B.Eng. with honours in Mechanical Engineering (Nanyang Technological University). She is an ACTA-certified Adult Educator (Singapore Training & Development Association) and has received additional certifications such as the LUMA Practitioner certification, Data Champions Bootcamp (certified track) and Algoritma Design Science Train-the-Trainer for both Data Visualisation and Machine Learning Specialisations, etc. 

Loh Wai Tuck

Loh Wai Tuck graduated from National University of Singapore with a Bachelor of Engineering (Electrical) and a Master of Technology (Software Engineering). 

Prior to teaching in the Polytechnic, Wai Tuck has 14 years of extensive experience in the software industry. He has worked in multiple IT projects (Geographical Information Systems, Office Automation projects and turnkey projects), undergoing the full software development life cycle. He was a senior consultant in Geographical Information Systems, and worked in countries like Singapore, Malaysia, Vietnam, Germany and England. Wai Tuck has also worked in the corporate risk & review management division; he has conducted independent reviews on software development projects to identify risks (financial and legal risks) in projects, monitoring the project costs and delivery milestones. 

In Ngee Ann Polytechnic, Wai Tuck has taught various IT subjects (Database, Programming, IT applications like Photoshop and MS Office products) and Mathematics. In recent years, he has also taught short courses for adult learners in Data Science (using R programming language) and Data Analytics (using Excel, Tableau and R programming language) related courses. Wai Tuck was attached to GovTech Data Science & Artificial Intelligence division, where he was involved in data cleaning and data preparation using Python. 

Ong Su Kit

Ong Su Kit received his BA from NUS, majoring in Economics and Mathematics. He is also a trained educator who received his Postgraduate Diploma in Education (NIE). In a professional capacity, Su Kit is a Neuro-Linguistics Programming Practitioner and a certified trainer in LUMA Certified Human-Centered Design Practitioner programme. He is also a ACTA certified Adult Educator. 

Ong Su Kit is an educator with 18 years of experience in teaching, primarily in the area of Mathematics in MOE secondary schools and Engineering Mathematics in tertiary institutions. 

While teaching in secondary schools, Su Kit has developed expertise in working with students from the Normal Academic and Normal Technical streams as a master trainer, be it academic in the field of Mathematics or as a life skills practitioner.  

Trained in Neuro Linguistics Programming, Su Kit has also developed curriculum and strategies for facilitation of life skills modules at tertiary level to prepare students for self-awareness and self-betterment.  

Su Kit is also a certified LUMA practitioner to bring Design Thinking principles in his educational teaching journey where he is involved in incorporating Design Thinking elements into existing curriculum of life skills at tertiary level.  

He is also an experienced advisor to student development groups organising major school events like Freshmen Orientation Camps and Student Leadership camps.  

Su Kit is also a recipient of the Ngee Ann Polytechnic Teaching Award in 2022.

Max Lam

Max Lam has a BSc in Mathematics from National University of Singapore, an Post Grad Dip in Systems Analysis from the Institute of Systems Science and a MA in Instructional Design & Technologies from the National Institute of Education. 

Max is a veteran educator who has been teaching Innovation and Entrepreneurship (Design Thinking) to Ngee Ann Polytechnic students in the last two decades, to develop critical thinking and problem solving skills and mindsets. 

He was also one of the pioneers of GIA, the Global Innovation Alliance office, and was responsible for identifying and connecting with Innovative Start-Ups around the world for entrepreneurial talent development. As the Senior Manager (Business Development), Max was responsible for connecting and building relations with start-up founders in Helsinki, HCMC, Jakarta and Hong Kong. 

Max is the curator of the Instructional Design (2016) programme of Gnowbe, an online micro-learning platform and is a Certified NLP Practitioner trained under Mind Kinesis of the Neuro Linguistic Programming Academy. 

Max subscribes to Transformational Design (So-Young Kang, Awaken Group) and Transformative Learning (Jack Mezirow) and freely shares his experiences through mentoring and coaching sessions with start-up founders. 

Between his teaching portfolio in Ngee Ann, Max was also involved in remote learning and instructional design using Blackboard, and in the creation of a Specialist Diploma in IT. He was involved in the piloting efforts of Innovation & Enterprise in Ngee Ann and even started a Specialised Independent School as the Vice Principal. He returned briefly to mainstream industry in an American founded management consulting company, doing management consulting. 

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. Minimum O levels/NITEC
  2. Applicants with other qualifications are welcome to apply

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 and have Microsoft Office installed.

 

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.

GST Increment in 2024
Please note that the GST rate will be revised to 9% with effect from 1 Jan 2024, as such any payable course fees will be subjected to the new GST rate adjustments in 2024. Please refer to our STEP portal for the updated fees. (Click on STEP)

Note:

  • The fees below are determined based on prevailing funding policies and subject to review and revision.
  • Please refer to our FAQs for more information.

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

Applicants / Eligibility Fees
Full course fee$10900.00
Additional course fee funding support$770.00
SkillsFuture Mid-Career Enhanced Subsidy$1270.00
SkillsFuture Baseline Funding for Singapore Citizen aged below 40$3270.00
SkillsFuture Baseline Funding for SPR$3270.00