WSQ Data Visualization Techniques using Power BI

Funding Validity Period

24 May 2022

17 May 2026

Course 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: What Is Data Visualization?

What is Data Visualization?
Purpose of Data Visualization
Understanding the types of visualization available for various purpose
Understanding interactivity between data visualization

Learning Unit 2: Navigating through Power BI Desktop and Data Models

Understanding the different views in Power BI Desktop
Understanding the use of data formats and types
Getting Various Data Type into Power BI Desktop
Data Transformation in Power Query
Creating Basic Visualization
Creating Relationships between Tables

Learning Unit 3: Setup and Data Visualization Techniques with Visual Filters and Power Query

Setting up page size and tool tips to support data visualization
Using Visual Filters on Single Visual, Visuals on Page and Visuals all Page
Applying advance slicer techniques
What is a calculated column?
What is a measure

Learning Unit 4: Creating Scorecards, KPIs and Gauge Charts and DAX Formulas

Create DAX Formulas
Using scorecards
Using KPIs
Using Gauge Charts

Learning Unit 5 Publishing Dashboards on Analysis Services

What is Power BI Analysis Services?
Using the Publish feature
Creating reports on Workplace
Creating Dashboards

Learning Unit 6: Techniques to Provide Context and Details to Data and Using Predictive Analytic

Predictive Analysis
Using Tooltips
Creating Drillthroughs

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

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

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)

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

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