New SolidWorks weekend intake starts 18 Aug — limited seats available.

03-8063 0414
CAD Training Centre — Knowledge Tree

Excel & Data Analytics

Power BI Desktop Essentials Plus Advanced

Develop advanced business intelligence and data analysis skills with our 3-day, HRD Corp claimable Power BI Desktop Essentials Plus Advanced Training Course at CAD Training Centre. Master fundamentals, Power Query, data modelling, and advanced DAX like time intelligence to transform complex datasets into insights. Physical, online, and in-house classes available.

Book Seat Enquire for Team
  • Duration 3 Days
  • Level Advanced
  • Format Face-to-face

About this course

The Power BI Training Course at CAD Training Centre is a very comprehensive, HRD Corp claimable program designed for business analysts and corporate teams in Malaysia. Available in a flexible 2-day core essentials option or a 3-day masterclass (combining essentials with 1 day of advanced DAX and dashboard creation), this hands-on training is offered physically in Puchong, Selangor, or via live online sessions. Feeling frustrated and confused whenever using Power BI Desktop, but wish to learn how others are making visually appealing, complex multiple-page reports and dashboards. Well look no further than our Power BI Training

Days 1 and 2 cover the same foundational modules as the 2-day Power BI Desktop Essentials course. Participants will learn how to install and navigate Power BI Desktop, create single-page and multiple-page reports, use filled maps and slicers, clean and transform data using Power Query, and develop relationships between tables. Day 3 introduces additional advanced topics covering DAX functions, selected values, ranking, time intelligence, custom Power Query functions and complex data modelling. Participants will learn how to work with multiple related tables, manage data relationships and apply advanced calculations to business reporting.


Related Links
https://www.microsoft.com/en-my/power-platform/products/power-bi/desktop
https://www.techtarget.com/enterprise-software/definition/What-is-Microsoft-Power-BI-Uses-features-and-guide
https://www.tutorialspoint.com/power_bi/power_bi_quick_guide.html
https://www.onlc.com/blog/benefits-of-power-bi-career/
https://ttms.com/my/find-out-the-key-benefits-of-using-microsoft-power-bi/

Learning Outcomes

  • Understand the fundamentals of Power BI Desktop and create interactive single-page and multiple-page reports using different visualisations.
  • Connect to various data sources and manage data source settings for business reporting.
  • Clean, transform, merge and append datasets using Power Query to prepare information for analysis.
  • Create relationships between multiple tables and understand data modelling concepts such as cardinality and many-to-many relationships.
  • Apply simple and advanced DAX functions to perform calculations within Power BI reports.
  • Use advanced DAX techniques involving selected values, ranking and time intelligence to analyse business performance.
  • Apply advanced Power Query techniques, including cleaning messy datasets and creating custom functions.
  • Develop complex data models, manage relationships and create comprehensive Power BI reports for business analysis and decision-making.

Who is it for

  • Business analysts who want to develop advanced skills in Power BI reporting, data visualisation and business intelligence.
  • Data analysts and data professionals responsible for preparing, analysing and modelling complex datasets.
  • Finance and accounting professionals who manage financial information, calculations and business performance reports.
  • Sales and marketing professionals who want to analyse customer information, campaign performance and business trends.
  • Operations managers and business executives who use data to monitor performance and support strategic decision-making.
  • Microsoft Excel users and Power BI beginners who want to progress from basic reporting to advanced DAX calculations and data modelling.

Course outline

Module 1

Day 1 – Introduction to Power BI Desktop
  • Understanding the fundamentals of Power BI Desktop
  • Exploring the benefits of using Power BI for business intelligence
  • Understanding how Power BI supports data analysis and visualisation
  • Navigating the Power BI Desktop interface
Module 2

Downloading and Installing Power BI Desktop
  • Understanding how to download Power BI Desktop
  • Learning the installation process
  • Setting up a new Power BI Desktop file
  • Preparing the Power BI environment for report development
Module 3

Using Filled Maps
  • Understanding geographical data in Power BI
  • Adding filled map visualisations to a report
  • Exploring geographical data presentation
  • Customising map visualisations using different map styles
Module 4

Using Slicers and Other Visuals
  • Understanding what slicers are and how they work
  • Using slicers to filter report data
  • Applying slicers to interactive visualisations
  • Creating additional visualisations in Power BI reports
Module 5

Creating a Basic One-Page Report
  • Understanding the Power BI report canvas
  • Adding visualisations to a report page
  • Formatting visualisations for clearer data presentation
  • Applying basic calculations within a Power BI report
Module 6

Creating a Multiple-Page Report
  • Understanding how to work with multiple report pages, Using simple DAX measures for calculations
  • Changing data sources within Power BI
  • Building reports that display information across different pages
Module 7

Cleaning and Transforming Data with Power Query
  • Introduction to Power Query
  • Understanding the purpose of data cleaning and transformation
  • Using Power Query to clean and transform datasets
  • Applying data transformations such as unpivoting columns
  • Preparing information for analysis and report creation
Module 8

Q&A and Conclusion
  • Answering participant questions about Power BI Desktop
  • Reviewing key concepts covered during Day 1 
  • Discussing next steps and additional learning resources
Module 9

Day 2 –Review of Power BI Desktop Basics
  • Reviewing fundamental Power BI Desktop concepts
  • Revisiting the Power BI Desktop interface
  • Reinforcing the basic reporting features covered during Day 1
Module 10

Building Multiple-Page Reports (Simple DAX)
  • Creating new pages in a Power BI report
  • Adding different visualisations to report pages
  • Creating navigation between multiple pages
  • Applying simple DAX measures within multiple-page reports
Module 11

Changing Data Source
  • Connecting Power BI Desktop to different data sources
  • Understanding data source connections
  • Managing data source settings
  • Changing existing data connections within Power BI
Module 12

Power Query – Merge and Append Data
  • Understanding how to combine data using Power Query
  • Merging data from multiple sources
  • Appending data from different sources
  • Preparing combined datasets for reporting and analysis
Module 13

Data Modelling
  • Understanding data modelling concepts in Power BI
  • Introduction to cardinality
  • Creating relationships between multiple tables
  • Applying advanced data modelling techniques
  • Understanding and handling many-to-many relationships
Module 14

Cleaning and Transforming Data with Power Query
  • Using Power Query to clean and transform information
  • Identifying and handling messy datasets
  • Improving data structure and consistency
  • Preparing transformed data for reporting
Module 15

Q&A and Conclusion
  • Answering participant questions about Power Query and data modelling
  • Reviewing important concepts learned during Day 2
  • Discussing additional Power BI learning resources and next steps
Module 16

Day 3 – Review of Power BI Desktop Basics
  • Reviewing the fundamental concepts of Power BI Desktop
  • Revisiting basic DAX calculations
  • Reviewing Power Query concepts covered during the first two days
  • Preparing for advanced data analysis and modelling topics
Module 17

Advanced DAX Functions
  • Understanding advanced Data Analysis Expressions (DAX)
  • Using selected values in DAX calculations
  • Applying ranking functions to analyse and compare data
  • Introduction to time intelligence functions
  • Using advanced DAX calculations for more complex business analysis
Module 18

Advanced Power Query Techniques
  • Applying advanced data cleaning and transformation techniques
  • Working with messy and inconsistent datasets
  • Understanding how to restructure information for analysis
  • Creating custom functions in Power Query
  • Preparing transformed data for complex reporting requirements
Module 19

Data Modelling
  • Linking more than one table within Power BI
  • Creating complex relationships between data tables
  • Managing relationships within a data model
  • Understanding how related tables support advanced reporting
  • Handling complex data models for business analysis
Module 20

Q&A and Conclusion
  • Answering participant questions about advanced Power BI concepts
  • Reviewing advanced DAX, Power Query and data modelling techniques
  • Summarising key learning outcomes
  • Discussing additional resources and next steps for continued Power BI learning

Course format

Choose the delivery mode that fits your team and timeline.

  • 01

    Classroom

    Instructor-led sessions in our Bandar Puteri labs with guided exercises, live demos, and peer discussion.

  • 02

    Online

    Live virtual delivery with the same syllabus, shared files, and instructor checkpoints — ideal for distributed teams.

  • 03

    In-house

    Private cohorts for your organisation, scheduled around project deadlines with content tailored to your standards.

Upcoming schedule

Public intakes coming up.

  • 30 Nov 2026 - 2 Dec 2026 9:00 AM – 5:00 PM · Face-to-face
    Book seat

Certification & policies

Certificate of attendance

Receive a certificate of attendance upon completing the programme, suitable for HR records and continuous learning portfolios.

Free Repeat Class

Free Repeat Class: if you need another pass at the same public syllabus within 6 months, you may re-attend subject to seat availability.

Materials provided

  • Course workbook / digital notes
  • Exercise files and sample templates
  • Certificate of attendance
  • Post-class support window for clarification questions

Frequently asked questions

01 What is the Power BI Desktop Essentials Plus Advanced course about?

Our Power BI Desktop Essentials Plus Advanced Training Course helps participants develop practical skills in data analysis, reporting and business intelligence using Microsoft Power BI. The programme covers Power BI fundamentals, interactive visualisations, Power Query, DAX calculations, data modelling and advanced reporting techniques. Participants will learn how to transform datasets into meaningful business insights and create reports that support workplace decision-making.

02 Is the Power BI Desktop Essentials Plus Advanced course suitable for beginners?

Yes. Although the programme includes advanced topics, it starts with Power BI fundamentals and gradually progresses to more complex features. No prior Power BI experience is required. However, participants should have a basic understanding of Microsoft Excel to help them follow the data analysis and reporting concepts.

03 What is the difference between Power BI Desktop Essentials and Power BI Desktop Essentials Plus Advanced?

Power BI Desktop Essentials is a 2-day course covering the fundamentals of Power BI, including report creation, data visualisation, Power Query, simple DAX calculations and data modelling. Power BI Desktop Essentials Plus Advanced is a 3-day programme that includes the same foundational modules from the 2-day course, followed by an additional day covering advanced DAX functions, selected values, ranking, time intelligence, custom Power Query functions and complex data modelling. Participants will develop skills for working with more challenging datasets and reporting requirements.

04 Do I need to complete the 2-day Power BI Essentials course before joining the 3-day Advanced programme?

No. The 3-day Power BI Desktop Essentials Plus Advanced programme already includes the topics covered in the 2-day Essentials course. Participants can start with the fundamentals before progressing to advanced DAX calculations, Power Query techniques and data modelling. A basic understanding of Microsoft Excel is recommended.

05 What advanced DAX functions will I learn during the course?

Day 3 introduces advanced Data Analysis Expressions (DAX), including selected values, ranking functions and time intelligence calculations. These techniques help participants analyse information, compare performance and work with calculations involving dates and time periods.

06 How long does the Power BI Desktop Essentials Plus Advanced course take?

The course takes three days, with training sessions running from 9:00 AM to 5:00 PM .Days 1 and 2 cover Power BI fundamentals, report creation, Power Query and data modelling. Day 3 focuses on advanced DAX functions, Power Query transformations and complex data models.

07 Do I need to bring my own laptop or purchase Power BI software?

No. CAD Training Centre provides laptops with Power BI Desktop installed for participants attending physical classes at our Puchong centre. You may bring your own laptop if preferred but must have the software Power BI installed . Training handouts and reference materials are also provided.

08 Will I receive a certificate after completing the Power BI Desktop Essentials Plus Advanced course?

Yes. Participants receive a Power BI Certification of Achievement after completing the training. The certificate recognises completion of the 3-day programme covering Power BI reporting, advanced DAX, Power Query and data modelling.

09 What language is the Power BI Desktop Essentials Plus Advanced course conducted in?

The training is conducted bilingually in English and Bahasa Melayu.

10 Is the Power BI Desktop Essentials Plus Advanced course HRD Corp claimable?

Yes. Our Power BI Desktop Essentials Plus Advanced Training Course is HRD Corp claimable under the SBL Khas scheme, subject to applicable eligibility and approval requirements.

11 Is there a surau (prayer room) available at CAD Training Centre?

Yes, we have a surau available at our training centre in Puchong. Muslim participants can use the prayer room during breaks throughout the training day.

12 Can I attend the Power BI Desktop Essentials Plus Advanced training online instead of in a classroom?

Classroom training means physical attendance in Puchong with face-to-face guidance and co-learning with other participants. Online training runs live via Zoom with hands-on, screen-shared exercises, better if you're outside the Klang Valley or want to save on travel time.

13 Can I repeat the Power BI Desktop Essentials Plus Advanced course if I need more practice?

Yes, free repeat classes , no questions asked, if you need a refresher.

Next step

Register your interest

Share a few details and we will confirm seats, HRD Corp claimability, and the best public or in-house option for this course.

Training type