NICF - DATA APPRECIATION FOR OPERATIONS (SF)

NICF - DATA APPRECIATION FOR OPERATIONS (SF)

Funded

Course Duration

16.0 hr(s)

Mode of Assessment

Participants will be required to complete paper-based NICF assessment during class.

Who Should Attend

  1. Business Analysts
  2. Data Analysts
  3. Data Engineers
  4. This course is also intended for company-sponsored candidates who are working for organisations that have enrolled in NTUCs Company Training Committee (CTC)

Course Overview

This course provides learners the analytical capabilities of Excel spreadsheets and foundation to learn about more advanced data analytics with Excel or Power BI.

Next available schedule

See All Schedules

Course Objectives

Upon completion of this course, learners will be able to:

1. Understand the project life cycle of data analytics

2. Work with different data sources

3. Appreciate how data affects an organization

4. Know the different types of data product

Pre-requisites

Prior to attending this course, learners should have the skills, knowledge and experience of:

  • Knowledge of Microsoft Windows operating system and its core functionality
  • Working knowledge of Microsoft Access
  • Advanced working knowledge of Excel spreadsheets including formulas

Hardware & Software

Laptop with Microsoft Windows 10 (8GB RAM minimum) installed (MAC not supported). This course will be conducted as a Virtual Live Class (VLC) via Zoom platform. Participants must have a laptop or a desktop with “Zoom Client for Meetings” installed. This can be downloaded from https://zoom.us/download

 

Minimum Specs

Recommended Specs

Others
  • Internet Connection: Wired or Wireless broadband (min 10 mbps)
  • Speakers and Microphone: built-in or USB plug-in or wireless Bluetooth
  • Webcam: built-in or USB plug-in
  

Software
  • MS Excel and MS Access to be installed before class starts

8GB RAM

Course Outline

  • Understanding and Practice How Filter, Format and Charts Works
  • Implementing the Use of Excel Data Tables and Summarising Data
  • Implementing the Use of Pivot Tables and Pivot Charts
  • Implementing and Creating a Dashboard and Analyse Data Pivot Tables
  • Understanding and Implementing the Use of Hierarchies
  • Understanding the Use of Data Model and How to Work with External Data
  • Implementing the Use Data Model and How to Work with External Data

Certificate Obtained and Conferred by

  • Statement of Attainment from SkillsFuture Singapore (SSG)

Upon meeting at least 75% attendance and passing the assessment(s), Statement of Attainment (SOAs) will be issued by SkillsFuture Singapore (SSG) to certify that the participant has achieved the following Competency Standard(s):

ICT-DIT-2005-1.1 Data Engineering

Additional Details

Medium of Instruction: English
Trainer to Trainee Ratio is 1:20

Price

For Classes commencing on or after 1st Jan 2023 (GST 8 %)

  

Individual Sponsored 

Company Sponsored 

 

Non-SME 

SME 

Before GST 

With GST 

Before GST 

With GST 

Before GST 

With GST 

For International Students (Full Course Fee) 

$455.00

$491.40

$455.00

$491.40

$455.00

$491.40

For Singapore Citizens and PRs aged 21 years and above

$136.50

$147.42

$136.50

$147.42

$45.50

$56.42

For Singapore Citizens aged 40 years and above 

$45.50

$56.42

$45.50

$56.42

$45.50

$56.42
-----

 

Remarks:

  • Singaporeans / PRs sponsored by SMEs will be eligible to claim additional 20% funding ($156) via SkillsConnect
  • Singaporeans aged >= 40 years of age, regardless of sponsored by SME or Non-SME will be eligible to claim additional 20% funding ($156) via SkillsConnect
  • Singaporeans aged >=35 years & earning a salary <= $2,000 per month will be eligible to claim additional 25% funding ($195) via SkillsConnect

Company Sponsored Trainee

Absentee Payroll (AP) Funding:

  • $4.50 per hour, capped at $100,000 per enterprise per calendar year
  • AP funding will be computed based on the actual number of training hours attended by the trainee
  • Note: Courses / Modules under Career Conversion Programme (CCP) will not be eligible for AP funding claim.

Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.
Prices are subject to other LHUB miscellaneous fees.

What Others Also Enrolled In

Funded

NICF - DATA APPRECIATION TO EXTRACT BUSINESS VALUE (SF) (SYNCHRONOUS E-LEARNING)

View detail
Before Funding $780.00
View detail
Funded

NICF - DATA APPRECIATION FOR OPERATIONS (SF)

View detail
Before Funding $780.00
View detail
Funded

NICF - DATA VISUALIZATION WITH QLIK SENSE (SF) (SYNCHRONOUS E-LEARNING)

View detail
Before Funding $900.00
View detail