ICDL Data Analytics Foundation: Excel & Power BI Training

(With WSQ Funding & SkillsFuture)

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

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 summarisation 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 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.
  • Summarise 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.

Data Analysis Training With Excel & Power BI in Singapore
Excel & Power BI Data Analytics
Students using Laptop
Training Schedule for Upcoming Workshop in Singapore
4, 5 Jun 2020
9, 10 Jul 2020

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


STATISITICAL ANALYSIS

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


IMPORTING DATA SETS

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


SHAPING DATA SETS

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


FILTERING DATA SETS

  • Formatting Data Sets as Tables
  • Using Table Slicers


PIVOT TABLE DATA AGGREGATION

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


PIVOT TABLE FREQUENCY ANALYSIS

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

FILTERING PIVOT TABLES

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


USING PIVOT CHARTS

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


DATA VISUALIZATION TOOLS

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


CREATING BASIC DATA VISUALIZATIONS

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


CREATING ADDITIONAL DATA VISUALIZATIONS

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


PUBLISHING AND SHARING

  • Creating and preparing to Share Reports
  • Publishing and Sharing Reports
  • Creating Dashboards
  • Sharing Dashboards
  • Good Design Practice
  • Evaluating Results
ICDL WSQ SF Funding

Target Audience

Power BI Dashboard
Power BI Dashboard

Course Duration: 2 Days full days (Weekdays or Weekends)

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

The full training fee of this course is S$480.
This is applicable for Foreigners, and Singaporeans below 21 years of age.

If you are above 21 years old, see below for applicable Government Grants & the Nett amount you need to pay.

WTS Letter

$424
$56 You Pay
  • Singaporean, Above 35 Years, &
  • Holding a valid WTS Letter
  • Use SkillsFuture to offset balance fee
  • Grant is capped at $26.5 per hour

90% Grant

$400
$80
You Pay
  • Singaporean, Above 40 Years &
  • For SME Companies
  • Use SkillsFuture to offset balance fee
  • Grant is capped at $25 per hour

80% Grant

$272
$208
You Pay
  • Singaporean, Below 40 Years &
  • PRs / MNC Companies
  • Singaporeans can use SkillsFuture to offset balance fee
  • Grant is capped at $17 per hour.

Do You Have Any Questions

On Course Fee, WSQ Grant or Funding?

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

Course Dates

Excel & Power BI Data Analytics
Excel & Power BI Data Analytics Training in Singapore
Training Schedule for Upcoming Workshop in Singapore
4, 5 Jun 2020
9, 10 Jul 2020

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

Send us a message

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

Monday, June 22, 2020, 4- 5 PM
(Live Webinar)

Days
Hours
Minutes
Seconds
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

  • Statistical Techniques
  • Table Reports
  • Quick Tips