WSQ Data Visualization Techniques using Power BI
TGS-2022013778
Course Overview
This course equips learners with knowledge in Microsoft Power BI, teaching them to create data visualisations, understand data relationships, and use visualisation techniques for business forecasting and trend analysis. Participants will also learn to develop interactive dashboards, KPI scorecards, and effectively communicate data insights to share their information in a clear and concise manner.
Training Type
Full Time
Who Should Attend
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.
Course Duration
2 Days
Total Training Duration (Hour)
16
Course Outline
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 visualisation
- Using KPI visualisation and other visualisation 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
Course Learning Outcome
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
Pre-requisites
- 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.
Funding Information
24 May 2022 To 17 May 2026
Course Pre-Requisites
Price
| Course Fee Payable | ||
|---|---|---|
| Original Fee | Before GST | With GST (9%) |
| Course Fee | $550.00 | $599.50 |
| Individual Pricing (Fee payable to Training Provider) | Before GST | With GST (9%) |
| Individual (Baseline) | $275.00 | $324.50 |
| Individual (MCES) | $165.00 | $214.50 |
| Corporate Pricing (Fee payable to Training Provider) | ||
| SME | Before GST | With GST (9%) |
| Corporate (SME) | $165.00 | $214.50 |
| Non-SME | Before GST | With GST (9%) |
| Corporate (Non-SME, Baseline) | $275.00 | $324.50 |
| Corporate (Non-SME, MCES) | $165.00 | $214.50 |
Company Sponsored Funding Types
- 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
- 70% of course fee funded
- Non-SME (Baseline)
- Non-SME companies, employee is Singaporean or PR aged below 40
- 50% of course fee funded
- Non-SME (MCES)
- Non-SME companies, employee is Singaporean aged 40 years and above
- 70% of course fee funded
Absentee Payroll Funding for Companies:
- $4.50 per training hour capped at $100,000 per enterprise per calendar year
------------------------------------------------------------------------
Self-sponsored Funding Types
- MCES
- Singaporean aged 40 years and above
- 70% of course fee funded
- Normal
- Singaporean / PR aged 21 years and above
- 50% of course fee funded
