WSQ

Introduction to Data Analysis using Excel and Power BI

course details

Duration and Time

Training Time

9am - 6pm

Course Duration

16 HRS

Course Information

Course Reference Number

TGS-2023020424

Funding Validity Period

25 Apr 2023 To
24 Apr 2025

Mode of Training

Classroom

COURSE OVERVIEW

This course provides learners with essential data analysis skills using Excel and Power BI, enabling them to import and shape data from diverse sources, create interactive dashboards and sophisticated visualisations, and enhance business insights with KPIs and trend analysis

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
  • Use Functions and Features to Create Statistical Data Visualisation in Excel and Power BI
  • Utilise basic DAX function and formulas

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?

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

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

 

  • 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 Outline

Download the PDF below for a summary of the course outline.

COURSE FEES

Company Sponsored

Funding Type Full Fee 9% GST (on full course fee) Funding Amount Nett Fee Payable (incl. GST)
Small Medium Enterprises (SMEs) $480.00 $43.20 $336.00 (70% off course fee) $187.20
Non Small Medium Enterprises $480.00 $43.20 $240.00 (50% off course fee) $283.20
Singaporean Employees aged 40 years and above $480.00 $43.20 $336.00 (70% off course fee) $187.20

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

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

Self-Sponsored

Funding Type Full Fee 9% GST (on full course fee) Funding Amount Nett Fee Payable (incl. GST)
Singapore Citizens (40 years and above) $480.00 $43.20 $336.00 (70% off course fee) $187.20
Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) $480.00 $43.20 $240.00 (50% off course fee) $283.20

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

REGISTER TODAY

Looking at in-house training or have an enquiry? Contact us!

Related Courses

IT

24 HRS

WSQ

IT

24 HRS

WSQ

IT

8 HRS

Non-Certifiable

GET IN TOUCH WITH US

Have an enquiry? Feel free to connect via any of the channels below.

enquiry form

Leave a message

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

Training hotline

Give us a call at
+65 6737 5761

SHARE THIS COURSE
Main Category
IT COURSES
Generative AI Series
SOFT SKILLS COURSES
COURSE MONTH
Certification
COURSE LEVEL
Course Duration