DATA VISUALISATION FUNDAMENTALS USING MICROSOFT POWER BI (SYNCHRONOUS E-LEARNING)

DATA VISUALISATION FUNDAMENTALS USING MICROSOFT POWER BI (SYNCHRONOUS E-LEARNING)

Funded

Course Duration

16.0 hr(s)

Mode of Assessment

Participants will be required to complete a paper-based assessment during class.

Who Should Attend

This course is intended for learners who are experienced with analysing data using Microsoft Excel and wish to expand on improving their BI techniques using Power BI. It is also for learners who are SQL Server report creators and are interested in using Power BI as an alternative tool of presenting data.

  • Users with limited Microsoft Excel knowledge but require to work with IT and other departments within the organisation to conduct data analysis
  • Business professionals requiring Microsoft Excel knowledge for data analysis

What's In It for Me

  • Learn the fundamentals of data visualisation using Power BI
  • Understand the job functions and roles of business analysts and data engineers

Course Overview

Power BI’s powerful collection of functions and features will help you to analyse your organisation’s data, uncover insights and trends. With this course, you will learn how to model data and create visual reports that reveal data insights. Although the Power BI desktop client will be the primary focus, an introduction to the Power BI web app will also be provided.

Course Schedule

Next available schedule

See All Schedules

Course Objectives

  • Perform data analysis in Power BI
  • Identify data types and explain how they are interpreted as visualisations
  • Design and create visualisations, based on user-centred workflows, for others to use
  • Discuss concepts of data visualisation and how they are implemented in Power BI
  • Identify best practices for Power BI visualisation design
  • Share insights with Power BI

Pre-requisites

The admission requirements are:

  • Basic working knowledge of Microsoft Excel
  • Working knowledge of relational databases
  • Extensive knowledge on the use Microsoft Excel’s worksheets features and functions such as formulas, charts, filtering, sorting, and sub-total etc.
  • Read, write, and speak English at WPL Level 4
  • Manipulate numbers at WPN Level 4
  • Hardware & Software
    • This course will be conducted as a Virtual Live Class (VLC) via Zoom platform
    • Participants must own a Zoom account and have a laptop or a desktop with “Zoom Client for Meetings” installed. Download from zoom.us/download.

System Requirement

Must-have:
Please ensure that your computer or laptop meets the following requirements.

  • Operating system: Windows 10
  • Processor/CPU: 1.8 GHz, 2-core Intel Core i3 or higher 
  • Minimum 20 GB hard disk space 
  • Minimum 8 GB RAM 
  • Webcam (camera must be turned on for the duration of the class) 
  • Microphone 
  • Internet Connection: Wired or Wireless broadband 
  • Latest version of Zoom software to be installed on computer or laptop prior to the class.

Good-to-have:

  • Wired internet connection
    Wired internet will provide you with stable and reliable connection.
  • Dual monitors
    Using a dual monitor setup will undoubtedly improve your training experience, enabling you to simultaneously participate in hands-on exercises and maintain engagement with your instructor. 

Not recommended:
Using tablets are not recommended due to their smaller screen size, which could cause eye strain and discomfort over the course of the program's duration.

Course Outline

Module 1: Get Started with Power BI

    • Introduction to Power BI
    • Working with Power BI Desktop Files
    • Connecting to Data Sources with Power BI Desktop
    • Creating a Report with Visualisations
    • Doing More with Visualisations

Module 2: Working with Data

    • Transforming and Sanitising Data
    • Using the Query Editor
    • Data Modelling
    • Managing Relationships

Module 3: Working with Reports and Visualisations

    • Managing Report Pages
    • Changing Report View Options
    • Working with Visualisations
    • Adding Static Objects to a Report

Module 4: A closer look at Visualisations

    • Matrixes, Tables, and Charts
    • Maps
    • Cards, Gauges, and KPIs
    • Slicers

      Module 5: Getting started with Power BI Web App

    • Connecting to Data Sources with the Power BI Web App
    • Using Workspaces, Dashboards, and Reports
    • Creating Custom Dashboards
    • Power BI Web App Features

Certificate Obtained and Conferred by

  • Upon meeting 75% attendance and passing the assessment, participants will be awarded with a digital Statement of Attainment (SOA), accredited by SkillsFuture Singapore. SOA will be reflected as [ICT-DIT-3006-1.1 Data Visualisation].
  • Certificate of completion from NTUC LearningHub

Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from NTUC LearningHub.

Additional Details

Medium of Instruction: English
Trainer to trainee ratio: 1:20
Mode of Delivery: Mode of Delivery: <Virtual Live Class (VLC) via Zoom> or <Physical class>

Price

Course Fee and Government Subsidies

  

Individual Sponsored 

Company Sponsored 

 

Non-SME 

SME 

Before GST 

After GST 

Before GST 

After GST 

Before GST 

After GST 

Full Course Fee
(For Foreigners and those not eligible for subsidies)

$1,200.00

$1,308.00

$1,200.00

$1,308.00

$1,200.00

$1,308.00

For Singapore Citizens aged 39 years and below
and
For all Singapore Permanent Residents
(The minimum age for individual sponsored trainees is 21 years)

$360.00

$392.40

$360.00

$392.40

$120.00

$152.40

For Singapore Citizens aged 40 years and above

$120.00

$152.40

$120.00

$152.40

$120.00

$152.40


Funding Eligibility Criteria

Individual Sponsored Trainee

Company Sponsored Trainee
  • Singapore Citizens or Singapore Permanent Residents

  • From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses

  • Trainee must pass all prescribed tests / assessments, and attain 100% competency
  • NTUC LearningHub reserves the right to claw back the funded amount from trainee if he/she did not meet the eligibility criteria
  • Singapore Citizens or Singapore Permanent Residents

  • From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses

  • Trainee must pass all prescribed tests / assessments, and attain 100% competency
  • NTUC LearningHub reserves the right to claw back the funded amount from the employer if trainee did not meet the eligibility criteria


Remarks

Individual Sponsored Trainee

Company Sponsored Trainee

SkillsFuture Credit: 

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.

UTAP: 

  • This course is eligible for Union Training Assistance Programme (UTAP).
  • NTUC members can enjoy up to 50% funding (capped at $250 per year) under UTAP.

PSEA: 

  • To check for Post-Secondary Education Account (PSEA) eligibility for this course, visit:
    (a)     SkillsFuture (TGS-2023037673) for Virtual Learning Class (VLC)
    (b)     SkillsFuture (TGS-2023037672) for Face-to-Face class
  • Scroll down to “Keyword Tags” to verify for PSEA eligibility. 
  • If there is “PSEA” under keyword tags, the course is eligible for PSEA.  
  • And if there is no “PSEA” under keyword tags, the course is ineligible for PSEA. 
  • Not all courses are eligible for PSEA funding.

Absentee Payroll (AP) Funding: 

  • $4.50 per hour, capped at $100,000 per enterprise per calendar year.
  • AP funding will be computed based on the actual number of training hours attended by the trainee.
  • Note: Courses / Modules under Professional Conversion Programme (PCP) will not be eligible for AP funding claim.


Terms & Conditions apply. NTUC LearningHub reserves the right to make changes or improvements to any of the products described in this document without prior notice.

Prices are subject to other LHUB miscellaneous fees.

What Others Also Enrolled In

Funded

ANALYZING AND VISUALIZING DATA WITH POWER BI (SF)

View detail
Before Funding $1,800.00
View detail
Funded

ANALYZING AND VISUALIZING DATA WITH POWER BI (SF)

View detail
Before Funding $1,800.00
View detail
Funded

DATA VISUALISATION FUNDAMENTALS USING MICROSOFT POWER BI (SYNCHRONOUS E-LEARNING)

View detail
Before Funding $1,200.00
View detail
Funded

DATA ANALYSIS USING EXCEL: ESSENTIALS (SF) (SYNCHRONOUS E-LEARNING)

View detail
Before Funding $1,200.00
View detail
Funded

DATA ANALYSIS USING EXCEL: POWER USER (SF) (SYNCHRONOUS E-LEARNING)

View detail
Before Funding $1,200.00
View detail