WSQ Data Visualization Techniques using Power BI

Funding Validity Period
24 May 2022
-
17 May 2026

Courses Overview

Organisations now have access to many sources of digital data. Organisations must cultivate staff with the necessary skills to be able to analyse these data and apply contemporary techniques to create dynamic and interactive visual displays in order to better illustrate and articulate to business stakeholders.
This course sets out the skills and abilities for learners to master the features and functions of Microsoft Power BI. Learners will be able to understand key concepts and techniques on creating data visualization, create visuals, understand data relationships and generate data for forecasting and trends.

Skills Acquired

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

  • Select the appropriate visualisation techniques to convey findings with usage of interactive visual display
  • Present different data types to reflect business trends using visualization techniques to show correlations between data sets
  • Incorporate suitable chart elements to create informative and interactive data displays
  • Develop basic dashboards KPI scorecards to display benchmark and results achieved
  • Incorporate interactive graphical visuals dashboard presentations
  • Communicate the limitations of data in dashboard with visualisation to show business insights

Learning Modules

Learning Unit 1: Importing Data into Power BI Desktop
  • Using Get Data feature
  • Get Data from text files
  • Get Data from spreadsheet files
  • Get Data from database files
  • Get Data from websites
Learning Unit 2: Shape and Clean Data using Power Query
  • Navigating Power Query Editor
  • Removing rows and columns within Power Query
  • Changing Data Types
  • Entering data via Power Query
  • Creating headers in Power Query
  • Find and replacing values in columns
  • Splitting and merging columns
  • Using Unpivot feature
  • Understanding Applied Steps in Query Editor
Learning Unit 3: Building Data Models
  • What is a Data Model?
  • Types of Relationships
  • Creating Relationships between Tables
  • Creating a Link Table
  • Creating a New Calculated Columns
Learning Unit 4: Creating Basic Data Visualization
  • Conditional Formating using background colours and data bars
  • Using Bar, Column, Pie and other standard visualization
  • Using KPI visualization and other visualization types
Learning Unit 5: Introduction to Measures
  • What is a measure?
  • Creating measures
  • Using measures for Gauge chart and KPI visualization
  • Creating measures table
Learning Unit 6: Introduction to DAX
  • What is DAX?
  • Basic DAX functions and formulas like SUM, AVERAGE, CALCULATE
  • Difference between Iterator and Aggregator functions i.e. SUM vs SUMX
  • Creating DAX with multiple tables
  • Other DAX functions like COUNT, COUNTROWS, MAX, MIN, DIVIDE functions
Learning Unit 7: Additional Data Visualization
  • Creating Drillthroughs
  • Creating Tooltips
Learning Unit 8: Using Predictive Analytics and other Reference Lines
  • Using Constant Line
  • Using Min and MAX Line
  • Using Average Line
  • Using Median Line
  • Using Percentile Line
  • Creating Forecasting values
  • Using Get Data feature
  • Get Data from text files
  • Get Data from spreadsheet files
  • Get Data from database files
  • Get Data from websites
  • Navigating Power Query Editor
  • Removing rows and columns within Power Query
  • Changing Data Types
  • Entering data via Power Query
  • Creating headers in Power Query
  • Find and replacing values in columns
  • Splitting and merging columns
  • Using Unpivot feature
  • Understanding Applied Steps in Query Editor
  • What is a Data Model?
  • Types of Relationships
  • Creating Relationships between Tables
  • Creating a Link Table
  • Creating a New Calculated Columns
  • Conditional Formating using background colours and data bars
  • Using Bar, Column, Pie and other standard visualization
  • Using KPI visualization and other visualization types
  • What is a measure?
  • Creating measures
  • Using measures for Gauge chart and KPI visualization
  • Creating measures table
  • What is DAX?
  • Basic DAX functions and formulas like SUM, AVERAGE, CALCULATE
  • Difference between Iterator and Aggregator functions i.e. SUM vs SUMX
  • Creating DAX with multiple tables
  • Other DAX functions like COUNT, COUNTROWS, MAX, MIN, DIVIDE functions
  • Creating Drillthroughs
  • Creating Tooltips
  • Using Constant Line
  • Using Min and MAX Line
  • Using Average Line
  • Using Median Line
  • Using Percentile Line
  • Creating Forecasting values

Who is this course is for

This training is relevant to Executives, Senior Executives and Data Analyst, Managers who are keen to learn how to fully utilise Power BI Desktop as a BI tool. This training is relevant to learners who are keen to explore data analytics as a job role.

Academic prerequisites

  • Learners must be able to read, write, speak and listen English at Secondary level.
  • Learner should have at least 1 year’s working experience in any industry.
  • Learners must have basic knowledge on Power BI.

Course Fees

Company Sponsored

Fees Small Medium Enterprises (SMEs) Non Small Medium Enterprises Singaporean Employees aged 40 years and above
Full Fee $650.00 $650.00 $650.00
9% GST (on full course fee) $58.50 $58.50 $58.50
Funding Amount $455.00 (70% off course fee) $325.00 (50% off course fee) $455.00 (70% off course fee)
Nett Fee Payable (incl. GST) $253.50 $383.50 $253.50

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

Fees Singapore Citizens (40 years and above) Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above)
Full Fee $650.00 $650.00
9% GST (on full course fee) $58.50 $58.50
Funding Amount $455.00 (70% off course fee) $325.00 (50% off course fee)
Nett Fee Payable (incl. GST) $253.50 $383.50

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

 

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

WSQ Data Visualization Techniques using Power BI

Course Highlight

Course Duration

16 HRS

Training Time

9am - 6pm

Mode of Training

Classroom

Course Reference Number

TGS-2022013778

Corporate Subsidy
Individual Subsidy

Have More Questions?

Lets start a conversation to upgrade your skillset

Other relevant courses

Lorem ipsum dolor sit amet consectetur. Arcu eu diam urna eu lorem leo tellus lectus. Enim proin hac quis placerat maecenas aliquam nunc viverra quis.

WSQ Advanced Data Visualisation using Power BI
24 HRS Certification Course
Introduction to Data Analysis using Excel and Power BI
16 HRS Certification Course
Retail Analytics and Market Intelligence
16 HRS Certification Course

UEN No.: 198802365N

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