UEN No.: 198802365N

Introduction to Data Analysis using Excel and Power BI

Funding Validity Period

25 April 2023

24 April 2027

Course Overview

This course sets out the foundational skills and knowledge to introduce learners to data analysis
using Excel functions and formulae and creation of data visualisation to generate business insights
by identifying trends and patterns

Skills Acquired

By the end of this course, learners will be able to:

Apply Excel functions and formulas to create statistical techniques like mean, median and regression analysis.
Identify various trends and patterns from data sets using techniques for statistical analysis.
Apply Statistical Functions for Data Analysis
Identify Data Requirement with Stakeholder for Further Analysis

Learning Modules

Learning Unit 1 – Understand Data Analysis Process and Using Functions for Statistical Analysis

What is Data Analysis
Benefits of Data Analytics
The Data Analysis Cycle
Data Protection Laws and Data Anonymity
The 4 Types of Data Analysis
The Types of Data
What are Statistics?
The Statistical Functions in Excel

Learning Unit 2 – Importing and Shaping Data Sets for Analysis of Trends and Patterns

Importing Data from Different Data Sources into Excel
Using Functions to Prepare Data for Statistical Analysis
Creating interactive dashboards to illustrate patterns and trends

Learning Unit 3 – Using Functions and Features to Create Statistical Data Visualisation in Excel and Power BI

Introduction to Power BI Desktop
Navigating around Power BI
Creating statistical visuals
Creating conditional formatting to highlight patterns
Creating trendlines and slicers

Learning Unit 4 – Create Interactive Basic Visualisation and Dashboards for Further Insights

Introduction to basic DAX function and formulas
Creating KPIs, Scorecards, Gauge visualisation
Publishing Power BI reports to Power BI Analysis Services

What is Data Analysis
Benefits of Data Analytics
The Data Analysis Cycle
Data Protection Laws and Data Anonymity
The 4 Types of Data Analysis
The Types of Data
What are Statistics?

Importing Data from Different Data Sources into Excel
Using Functions to Prepare Data for Statistical Analysis
Creating interactive dashboards to illustrate patterns and trends

Introduction to Power BI Desktop
Navigating around Power BI
Creating statistical visuals
Creating conditional formatting to highlight patterns
Creating trendlines and slicers

Introduction to basic DAX function and formulas
Creating KPIs, Scorecards, Gauge visualisation

Who is this course is for

This training is relevant to PMETs who are new to data analysis and is keen to expand their knowledge of Excel to include the use of data analysis functions and dashboards as well as apply data visualization tools for interactive data

Academic prerequisites

Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 3.
Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 3.
Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 3.
- Learners to have minimum GCE ‘O’ level or ITE certificate education
- Learner should have at least 1 year’s working experience in any industry.
- Learners must be able to operate a personal computer, use keyboard and mouse

Course Fees

Company Sponsored

Fees	Small Medium Enterprises (SMEs)	Non Small Medium Enterprises	Singaporean Employees aged 40 years and above
Full Fee	$580.00	$580.00	$580.00
9% GST (on full course fee)	$52.20	$52.20	$52.20
Funding Amount	$406.00 (70% off course fee)	$290.00 (50% off course fee)	$406.00 (70% off course fee)
Nett Fee Payable (incl. GST)	$226.20	$342.20	$226.20

SME: Company registered or incorporated in Singapore AND employment size of not more than 200 or with annual sales turnover of not more than $100 million
Non-SME (MCES): Employee is Singaporean aged 40 years and above

Course Fee Subsidy:
SME: 70% of course fee
Non-SME: 50% of course fee
Non-SME(MCES): 70% of course fee

Eligible for Absentee Payroll Funding

$4.50 per training hour capped at $100,000 per enterprise per calendar year

Eligible for SkillsFuture Enterprise Credit (SFEC)

Self Sponsored

Fees	Singapore Citizens (40 years and above)	Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above)
Full Fee	$580.00	$580.00
9% GST (on full course fee)	$52.20	$52.20
Funding Amount	$406.00 (70% off course fee)	$290.00 (50% off course fee)
Nett Fee Payable (incl. GST)	$226.20	$342.20

MCES: Singaporean aged 40 years and above
Normal: Singaporean / PR aged 21 years and above

Course Fee Subsidy:
MCES: 70% of course fee
Normal: 50% of course fee

Eligible for UTAP funding
Eligible for SkillsFuture Credit
Eligible for PSEA Funds