UEN No.: 198802365N

WSQ Data Visualization Techniques using Power BI

COURSE synopsis

Course Details

Training Provider:

Course Duration

16 HRS

Course Reference Number


Funding Validity Period

24 May 2022 To
17 May 2024

Mode of Training


Course Objectives

  • Create data visualizations using Power BI Desktop
  • Understand key concepts and techniques on creating data visualization
  • Understand data relationships and how linkages are formed
  • Understand and generate data for forecasting and trends

Course Outline

  • What is Data Visualization?
  • Navigating through Power BI Desktop and Data Models
  • Setup and Data Visualization Techniques with Visual Filters and Power Query
  • Creating Scorecards, KPIs and Gauge Charts and DAX Formulas
  • Publishing Dashboards on Analysis Services
  • Techniques to Provide Context and Details to Data and Using Predictive Analytics

Target Audience

  • Executives, Senior Executives and Data Analyst, Managers
  • Those keen to learn how to fully utilise Power BI Desktop as a BI tools
  • Those keen to explore data analytics as a job role


  • Interactive lecture, hands-on demonstration and hands-on practical exercises

Course Content

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
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
Building Data Models
  • What is a Data Model?
  • Types of Relationships
  • Creating Relationships between Tables
  • Creating a Link Table
  • Creating a New Calculated Columns
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
Introduction to Measures
  • What is a measure?
  • Creating measures
  • Using measures for Gauge chart and KPI visualization
  • Creating measures table
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
Additional Data Visualization
  • Creating Drillthroughs
  • Creating Tooltips
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
Course Outline

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


Company Sponsored

Funding Type Full Fee GST Funding Amount Nett Fee Payable (incl. GST)
SME $550 $44 $385 $209
Non-SME $550 $44 $275 $319
$550 $44 $385 $209

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


Funding Type Full Fee GST Funding Amount Nett Fee Payable (incl. GST)
MCES $550 $44 $385 $209
Normal $550 $44 $275 $319

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


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

Related Courses


16 HRS



16 HRS



16 HRS



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

enquiry form

Leave a message


Chat on WhatsApp at
+65 8767 0614

Training hotline

Give us a call at
+65 6737 5761