WSQ

Advanced Data Visualisation using Power BI

course details

Duration and Time

Training Time

9am - 6pm

Course Duration

24 HRS

Course Information

Course Reference Number

TGS-2024048385

Funding Validity Period

19 Aug 2024 To
18 Aug 2026

Mode of Training

Classroom

COURSE OVERVIEW

This 3-day course is designed for Power BI users who want to take their data visualisation skills to the next level. Participants will delve into advanced techniques for creating compelling and informative dashboards and reports. The course will cover advanced data manipulation, custom visuals, DAX (Data Analysis Expressions), storytelling with data, and best practices for deployment and sharing.

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

  • Apply Advanced Data Visualisation via Power Query Editor.
  • Analyse Data Patterns, Trends and Correlations in Advanced Data Visualisation.
  • Implement DAX Techniques in Dashboard and Scorecard Development Process.
  • Develop Custom Visuals in the Form of Tables, Graphs and Dynamic Data Display.
  • Determine Storytelling Techniques to Support Presentation of Data Analysis.

Learning Unit 1: Power Query Editor Deep Dive

  • Advanced data transformations (pivoting, unpivoting, merging
  • M language fundamentals for custom data manipulation
  • Appraising error handling and data quality checks

Learning Unit 2: Beyond Basic Charts

  • Waterfall charts, funnel charts, gauges, and other advanced visuals
  • Formatting and customizing visuals for impact
  • Interactive elements and user experience considerations

Learning Unit 3: DAX Advanced Techniques

  • Calculated columns and measures
  • DAX syntax and common functions
  • Filtering and aggregation with DAX
  • Time intelligence functions (DATES, PERIODS, etc.)
  • Utilizing advanced filtering and calculated tables
  • Creating complex KPIs and performance metrics

Learning Unit 4: Custom Visuals and the Power BI Marketplace

  • Identifying and integrating custom visuals for specific needs
  • Evaluating and selecting appropriate custom visuals
  • Leverage custom visuals for unique data storytelling

Learning Unit 5: Storytelling with Data

  • Designing dashboards and reports with a narrative flow
  • Engaging users with visuals and data insights
  • Best practices for layout, hierarchy, and user interaction

Admin, operational, and managerial staff who use Power BI to perform advanced data analysis and create interactive dashboards for reporting purposes.

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

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

COURSE FEES

Company Sponsored

Funding Type Full Fee 9% GST (on full course fee) Funding Amount Nett Fee Payable (incl. GST)
Small Medium Enterprises (SMEs) $1,500.00 $135.00 $1,050.00 (70% off course fee) $585.00
Non Small Medium Enterprises $1,500.00 $135.00 $750.00 (50% off course fee) $885.00
Singaporean Employees aged 40 years and above $1,500.00 $135.00 $1,050.00 (70% off course fee) $585.00

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

Funding Type Full Fee 9% GST (on full course fee) Funding Amount Nett Fee Payable (incl. GST)
Singapore Citizens (40 years and above) $1,500.00 $135.00 $1,050.00 (70% off course fee) $1,634.00
Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) $1,500.00 $135.00 $750.00 (50% off course fee) $885.00

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

REGISTER TODAY

Select a date below

There is no course available now

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

Related Courses

IT

24 HRS

WSQ

IT

8 HRS

Non-Certifiable

IT

8 HRS

Non-Certifiable

GET IN TOUCH WITH US

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

enquiry form

Leave a message

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

Training hotline

Give us a call at
+65 6737 5761