Using Power BI

Using Power BI

Course Information

2 Days Course

Fee: $1280 (before GST)

Course Dates:

  • 11 & 12 Nov 2025
  • 18 & 19 Dec 2025
  • 27 & 28 Jan 2026
  • 26 & 27 Feb 2026

 

Time: 9.15am – 5pm

Contact: [email protected] 

Venue: Hotel (near MRT)

Note:

  • Tea breaks and buffet lunch will be served. Car park coupons are available upon request. 
  • For 3 pax and above, 10% discount across the board

Refer A Friend

Get a $15 NTUC voucher for every successful referral! T&Cs apply & while stocks last!

  • Rewards are issued only after their referral has completed the course.
  • Referred individuals must not have attended our courses in the last 12 months.
  • Referrals from the same company or organization as the referrer are not valid.

Course Introduction

This 2-day practical workshop is aimed at equipping participants with the fundamentals of using Power BI Desktop as well as the applied skills required to enable them to communicate insights in the form of BI reports to make the right business decisions. 

Learning Outcome

By the end of this workshop, participants will be able to:

  •  Understand what data visualization is and its importance to data analytics
  • Learn about the types of data analytics  Understand the data analytics cycle and iteration 
  • Apply data visualization techniques and dashboard  Equip with skills to create scorecards, KPIs and gauge charts
  • Create DAX formulas and functions for enhance visualization
  • Apply advanced visualization techniques for stakeholder engagement

Who Should Attend

This course would be suitable for any working professionals who are interested to advance their knowledge in using Power BI Desktop and its applications for their businesses.

Course Outlines

  • Purpose of data visualization
  • Why is data visualization important?
  • 4 types of data analytics
  • The data analytics cycle  
  • Navigating through Power BI
  • Understanding data formats and types
  • Data Transformation in Power Query Editor
  • Creating Relationships between Tables
  • Create Basic Visualization
  • Setting up Page Size and Tools
  • Using Visual Filters
  • Applying Advance Slicer Techniques
  • Calculated Column
  • Create Measures Table
  • Calculated Measure
  •  Create DAX Formulas
  • Aggregation and Iteration Functions
  • Using SUM, CALCULATE, FILTER
    Functions
  • SUMX Function
  • AVERAGE and AVERAGEX Functions
  • Using COUNT and COUNTROWS Functions
  • DISTINCTCOUNT Function
  • MAX and MIN Functions
  • DIVIDE Function
  • FILTER Function
  • ALL Function
  • ALLEXCEPT Function
  • Using Score Cards
  • Using Key Performance Indicators (KPIs)
  • Using Gauge Charts
  • Power BI Analysis Services
  • Using the Publish Feature
  • Creating Reports on Workplace
  • Creating Dashboards
  • Predictive Analytics
  • Using Smart Narrative
  • Creating Drill-Throughs
  • Creating Hierarchy