Advanced Data Visualisation using Power BI

Funding Validity Period

19 August 2024

18 August 2026

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.

Skills Acquired

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 Modules

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

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

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

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

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

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

Who is this course is for

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

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	$1,500.00	$1,500.00	$1,500.00
9% GST (on full course fee)	$135.00	$135.00	$135.00
Funding Amount	$1,050.00 (70% off course fee)	$750.00 (50% off course fee)	$1,050.00 (70% off course fee)
Nett Fee Payable (incl. GST)	$585.00	$885.00	$585.00

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	$1,500.00	$1,500.00
9% GST (on full course fee)	$135.00	$135.00
Funding Amount	$1,050.00 (70% off course fee)	$750.00 (50% off course fee)
Nett Fee Payable (incl. GST)	$585.00	$885.00

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