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
- Topic 1. What Is Data Visualisation
- Purpose of data visualization
- Why is data visualization important?
- 4 types of data analytics
- The data analytics cycle
- Topic 2. Navigating through Power BI Desktop and Data Models
- Navigating through Power BI
- Understanding data formats and types
- Data Transformation in Power Query Editor
- Creating Relationships between Tables
- Create Basic Visualization
- Topic 3. Setup and Data Visualization Techniques with Visual Filters and Power Query
- Setting up Page Size and Tools
- Using Visual Filters
- Applying Advance Slicer Techniques
- Calculated Column
- Create Measures Table
- Calculated Measure
- Topic 4. Creating Scorecards, KPIs and Gauge Charts and DAX Formulas
- 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
- Topic 5. Publishing Dashboards on Analysis Services
- Power BI Analysis Services
- Using the Publish Feature
- Creating Reports on Workplace
- Creating Dashboards
- Topic 6. Techniques to Provide Context and Details to Data and Using Predictive Analytics
- Predictive Analytics
- Using Smart Narrative
- Creating Drill-Throughs
- Creating Hierarchy