ICDL Data Analytics

TGS-2020505592

Course Overview

This module gives you the essential knowledge and skills relating to key data analytics concepts, statistical analysis, data set summarisation and data visualization. Developed with input from subject matter experts, it develops a knowledge of key concepts and a practical understanding of how to use data analytics in business. Once you have developed the skills and knowledge set out in this course, you will be able to become certified in an international standard in this area – ICDL Data Analytics – Foundation.


Training Type

Full Time


Mode of Assessment

ICDL Online Assessment


Who Should Attend

Anyone interested in developing data analysis skills


Course Duration

2 Days


Total Training Duration (Hour)

16 Hours


Course Outline

Lesson 1 – Key Concepts

Lesson 2 – Statistical Analysis

Lesson 3 – Importing Data Sets

Lesson 4 – Shaping Data Sets

Lesson 4 – Shaping Data Sets (Continuation)

Lesson 5 – Filtering Data Sets

Lesson 6 – Pivot Table Data

Lesson 7 – Pivot Table Frequency Analysis

Lesson 8 – Filtering Pivot Tables

Lesson 9 – Using Pivot Charts

Lesson 10 – Data Visualization Tools

Lesson 11 – Creating Basic Data Visualizations

Lesson 12 – Creating Additional Data Visualizations

Lesson 13 – Publishing and Sharing


Certification Obtained and Conferred by

Avantus Certificate of Attendance (upon achieving minimum 75% class attendance)



Course Learning Outcome
  • Understand the key concepts relating to the application of data analytics in business
  • Understand and apply key statistical analysis concepts
  • Import data into a spreadsheet and prepare it for analysis using data cleansing and filtering techniques
  • Summarize data sets using pivot tables and pivot charts
  • Understand and apply data visualization techniques and tools
  • Create and share reports and dashboards in a data visualization tool

Pre-requisites

Proficient in using a Microsoft Windows computer and spreadsheet software


Medium of Instruction & Trainer

English


Funding Information

Skillsfuture Singapore (SSG) Non-Certifiable Funding, Cat B


Criteria:

  • Applicant must either be a Singapore Citizen or Permanent Resident of Singapore and;
  • Applicant must be at least 21 years old and;
  • Applicant must achieve at least 75% attendance, and pass all examinations/assessments and;
  • Applicant is taking the course for the first time


Avantus reserves the right to charge the full course fee (without subsidy) if any of the conditions above are not met.


SSG Funding Validity Period

13 Aug 2020 – 12 Aug 2022


Singapore Citizens aged 25 years and above will be able to utilize their Skillsfuture Credits to offset against nett fee payable


Additional Notes

Assessment Retake fee at $80 (before GST)


Documents


Price
Course Fee Payable
Original Fee Before GST With GST (9%)
Course Fee $480.00 $523.20
Individual Pricing (Fee payable to Training Provider) Before GST With GST (9%)
SkillsFuture >=40 years old, Singapore Citizens $144.00 $187.20
SkillsFuture >=21 years old $240.00 $283.20
Corporate Pricing (Fee payable to Training Provider)
Non-SME Before GST With GST (9%)
SkillsFuture >=21 years old $240.00 $283.20
SkillsFuture >= 40 years old $144.00 $187.20
SME Before GST With GST (9%)
SkillsFuture $144.00 $187.20

Please note that prices are subject to change.
Back to Catalogue →
Next Available Schedules
Course Name:
Category:
Delivered By:
Trainer:
Venue:
Language:
Session Dates: Please view schedule
Registration Date:
From To
Keyword Tags
Data Analytics Analysis Dashboard Data Aggregation Data Visualisation Filter Pivot Chart Pivot Table Report Slicer Spreadsheets Statistics Timeline Vlookup