Intermediate Visual Analytics Using Power BI

Course Date:

Registration Period:

16 hours / 2 day

9:00am to 6:00pm

Mode of Training:
Facilitated Learning (F2F)

Singapore Polytechnic

Course Introduction

Using Power BI Professional Licence & Microsoft Suite. Real time data for dashboard creation. Scheduling and security features in the dashboard. 

Course Objective

Participants will learn advance level DAX functions where they can build more insightful dashboard. The course will also equip them with knowledge on streaming data analysis and visualisation as this skillset is currently useful for individuals in any sector or profession. In addition, participants will also learn how to automate processes such that dashboards will be refreshed on a scheduled time and alerts will be sent to stakeholders. Such features are highly sought after in most industries especially in manufacturing sector where process plants are concerned. 

Course Outline

By the end of the course, participants will be able to: 

•Perform advanced DAX Functions (Calculate, Groups, Rank, Filter & TopN)
•Perform advanced Custom Visuals (AI Visual & Text Mining – Word Cloud)
•Perform Real-time Data Processing (Real-time Data Entry & Visual, Automate Process & Visual)
•Perform Stream Analytics (Stream Analytics via IoT, Push Notifications & Alerts via SMS)
•Perform Security & Scheduling (Schedule & refresh reports at x-th hr, row level data security & filter, parameters setting on power query)

Topics to be covered

1. Advance DAX functions
2. Analytics using custom graphics
3. Real-time data processing
4. Real-time stream analytics
5. Security & scheduling

Suitable for

Data Analyst/Associate Data Engineer/Business Intelligence Manager/Business Intelligence Director

Minimum Entry Requirements / Assumed Skills and Knowledge

Participants must have attended Power BI Level 1 
Have a fair experience using Microsoft Excel
GCE O level with a pass in English & Mathematics

Award / Certification / Accreditation

• Certificate of Attendance (electronic Certificate will be issued)
A Certificate of Attendance will be awarded to participants who meet at least 75% attendance rate

• Certificate of Performance (electronic Certificate will be issued)
A Certificate of Performance will be awarded to participants who pass the assessment and meet at least 75% attendance rate

Applicants/Eligibility Total fees (incl. GST)
Singapore Citizens aged 40 and above1 $96.80
Singapore Citizens aged below 40 $256.80
Singapore Permanent Residents $256.80
SME-sponsored Singapore Citizens and Permanent Residents2
Full Course Fee $856.00
Singaporeans aged 25 years and above may use **SkillsFuture Credit balance to offset respective course fees.

1Under the Enhanced Training Support for Small & Medium Enterprises (SMEs) Scheme. For more information of the scheme, click here. To view SP's list of similar funded courses, click here. Please submit the attached “Declaration Form for Enhanced Training Support Scheme for SME” together with your online application.
2Under the SkillsFuture Mid-career Enhanced Subsidy. For more information, visit the SkillsFuture website here

Funding Incentives

Please click here for more information on funding incentives.

Register Here

Eligible for SkillsFuture Credit
Terms and Conditions

*Please note that once the maximum class size is reached, the online registration will be closed.
You may register your interest, and would be notified if there is new run.

Application Procedure

1. All applications must be made via Online Registration at
Course fees can be paid by the following payment modes:

a) Credit Cards, Internet Banking, NETS (Not Applicable for company sponsored)
For e-payment using Visa/Master cards and Internet Banking, please click on the ‘Make e-Payment’ button on the acknowledgement page to proceed.

b) For NETS payment, you can pay at:
Singapore Polytechnic
PACE Academy

c) For payment via PayNow, please enter the UEN No. T08GB0056ACET and indicate the invoice/registration number.

*With effect from 1 August 2021, cheque payment will not be available.

2. All successful applicants will be notified with a letter of confirmation via email.

Chat with us