ICDL Data Analytics Foundation: Excel & Power BI Training

(With WSQ Funding & SkillsFuture)

Starts from only $48 after 90% WSQ Grant*

Use SkillsFuture to offset this amount

Learn PowerBI Dashboards Data Analysis Pivot Tables PowerBI Timelines PowerBI Slicers PowerBI Visualizations To Share PowerBI

The Data Analytics Foundation training course provides essential knowledge &  skills to analyze data with modern tools. Statistical Analysis, Excel Pivot Tables, Power BI Data Visualization are used to analyze big data from a diverse source set.  WSQ Grants & SkillsFuture can be used for Data Analytics Training Course.

A great course for Beginners to learn Data Analysis with the #1 Business Intelligence tools: Microsoft Power BI & Microsoft Excel.

Data Analytics make it easy to understand the past data, forecast future trends, helping you make sense and decide on the Best course of action, with our Step-by-step, Practical, Hands-on training!

Excel & Power BI Data Analytics
Excel & Power BI Data Analytics Training in Singapore

Course Objectives

PowerBI Bar, Line, Column & Donut Charts

PowerBI Bar, Line, Column & Donut Charts

The ICDL Data Analytics With Excel & Power BI training teaches you how to get started into Data Analysis, use Statistical techniques in Excel, create Pivot Table Reports, and Visualize Data with Power BI Dashboards easily.

This course provides essential knowledge and skills relating to data analytics concepts, statistical analysis, data set preparation, data set summarization and data visualization successfully.

You will gain expertise in analyzing production data and chart future course of action confidently with these sophisticated Data Analytics Tools

Our objective is to train you to  be able to perform the following Data Analytics Tasks well:

  • Understand the key concepts 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 & Tools.
  • Create and Share Interactive Reports & Dashboards with the Best Data Visualization Tool – Power BI.

HIGHLY Recommended for People who want to Upgrade themselves & Move to the Next Level.

Power BI Dashboard With Map, Slicers, KPI & Sliders
Power BI Dashboard

Need a Course Brochure?
We'll send you one!

Course Outline

ICDL Data Analytics Foundation Certification With Excel & Power BI

Type of Data Analytics

  • Business Benefits
  • Data Analysis Process
  • Data Protection Considerations


  • Summary Statistics Introduction
  • Measures of Central Tendency
  • Calculating Central Tendency
  • Measures of Variation
  • Calculating Variation


  • Importing Data Sets
  • Importing from Text Files
  • Importing from Spreadsheets
  • Importing from Websites
  • Importing Data from Database Tables


  • Removing Duplicate Data
  • Validating Data Using VLOOKUP
  • Validating Data Using IF
  • Extracting Values Using Text Functions


  • Formatting Data Sets as Tables
  • Using Table Slicers


  • Summarising Data Introduction
  • Changing Aggregation Methods
  • Displaying Multiple Aggregation Values
  • Using Built-in Calculations


  • Grouping Data, Time and Numeric Data
  • Create Custom Groups
  • Ungrouping Data


  • Using Report Filters
  • Using Pivot Table Slicers
  • Using Timelines


  • Inserting Pivot Charts from Pivot Tables
  • Creating Pivot Charts from Tables


  • Key Features of Data Visualization Tools
  • Data Visualization Tools Setup Visualization Tool Environment
  • Importing Data Sets from Spreadsheets


  • Creating Table Visualizations
  • Creating Chart Visualizations
  • Enhancing Visualizations Using Conditional Formatting
  • Enhancing Visualizations
  • Using Visual Level Filters
  • Creating Visualizations Using Maps


  • Creating Visualizations to Measure Progress
  • Creating Card Visualizations
  • Creating Matrix Visualizations
  • Adding Interactivity Using Slicers


  • Creating and preparing to Share Reports
  • Publishing and Sharing Reports
  • Creating Dashboards
  • Sharing Dashboards
  • Good Design Practice
  • Evaluating Results
WSQ funded Training Programs

Target Audience

Power BI Dashboard
Power BI Dashboard

Course Duration:  2 Days full days 

Course Timings: 8.45 am – 5.45 pm

Target Audience: For beginner in Data Analytics, or even complete newbies to Power BI.

You will learn the initial steps in understanding and analyzing data, use statistical analysis, import large datasets from Excel, Websites or Databases, shape data with formulas & functions, aggregate it with Excel Pivot Tables, create Frequency Distributions and finally create Dashboards to visualize it with amazing charts in Power BI.

Prerequisites: Basic knowledge of PC skills, Microsoft Excel, Windows and an open mind, interested to explore and learn new things. Prior knowledge of Power BI is not required.

ICDL LogoCertification: Successful trainees will receive the internationally recognized ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore. This is a joint certification between SSG and ICDL Singapore. Student must pass a 60 minutes online assessment at the end of the Data Analytics training course to qualify for the Grants & Certification.

Student using LaptopLearners’ Profile:

      1. Any learner with a basic proficiency in reading, writing, and understanding English, basic knowledge of Excel can pick up the Data Analytics Skills with Power BI
      2. We look for participants with Secondary education as a per-requisite
      3. Participants should have completed the Basic PC Skills training, Basic Excel Training and be familiar with Windows operating system.

What Our Happy Participants Say

Training Course Fees

The full course fees for this training is S$480, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6296-4663 for Details or WhatsApp Now at +65-9066-9991

up to 90% Grant

$432 Funding by SSG
Pay $48
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture

up to 50% Grant

$240 Funding by SSG
Pay $240
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • Grant Capped at $15/training hour

Do You Have Any Questions

On Course Fee, WSQ Grant or Funding?

Ask Us. We’ll be happy to assist you.

Course Dates

Learn With Intellisoft & Boost Your Career

Intellisoft Training at Central Singapore

How to Register for Data Analytics Training in Singapore?

Simply fill this Online Registration Form to book your seat.
Our Training Officer will get in touch with you to confirm your seat shortly.

You can call at at +65 6296-4663 or 9066-9991 (Whatsapp now) if you have any questions.
Register Now

Get in Touch

Intellisoft Training Pte Ltd

5001 Beach Road, #06-05 Golden Mile Complex,
Singapore 199588

(65) 6296-4663 (Call)

(65) 9066-9991 (Whatsapp now)

Free Training on Data Analytics with Excel & Power BI

Thursday, 9 December 2021, 3pm
(Live Webinar on Zoom)

This Webinar has ended. Signup for the next one. We will inform you once the date is confirmed.

Signup Now & Learn How to get started into Data Analysis For Free