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

Develop practical data analysis and reporting skills with our 2-day, HRD Corp claimable Microsoft Power BI Desktop Essentials Training Course at CAD Training Centre. Master fundamentals, Power Query, DAX, and interactive reporting to transform raw data into insights. Physical, online, and in-house training available.

Book Seat Enquire for Team
  • Duration 2 Days
  • Level Basic
  • 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

This course  covers eight sections, beginning with an introduction to Power BI Desktop, its interface and installation process. Participants will learn how to create filled maps, use slicers and other visualisations, build single-page and multiple-page reports, and apply simple DAX measures. The day also introduces Power Query for cleaning and transforming data, including unpivoting columns. Day 2 builds on these foundations by exploring multiple-page report navigation, changing data sources, merging and appending queries, and creating relationships between tables. Participants will also learn about data modelling, cardinality, many-to-many relationships and handling messy datasets.

A “Start-from-zero” Course experience that will guide the participants through the basics to advanced concepts of Power BI Desktop, starting from how to install Power BI Desktop and creating basic reports using different visualizations.

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 Microsoft Power BI Desktop, including its interface, features and applications for business intelligence.
  • Download, install and configure Power BI Desktop to create reports and visualisations.
  • Create single-page and multiple-page reports using filled maps, slicers and other interactive visualisations.
  • Apply simple Data Analysis Expressions (DAX) measures to perform calculations within Power BI reports.
  • Import, clean and transform data using Power Query, including unpivoting columns and handling inconsistent datasets.
  • Merge and append data from multiple sources to prepare information for reporting and analysis.
  • Create and manage relationships between tables using data modelling concepts such as cardinality and many-to-many relationships.
  • Develop structured Power BI reports that support data analysis, business performance monitoring and informed decision-making.

Who is it for

  • Beginners who have basic Microsoft Excel knowledge and want to start learning Power BI Desktop.
  • Business analysts who need to create interactive reports and visualise business performance.
  • Data analysts who want to improve data preparation, modelling and reporting skills.
  • Finance and accounting professionals who work with financial information, calculations and business reports.
  • Managers and business executives who want to understand business information through interactive reports and data visualisations.

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 the training
  • Discussing additional Power BI learning resources and next steps

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 - 1 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 course about?

Our Power BI Desktop Essentials Training Course introduces participants to Microsoft Power BI, a business intelligence tool used for analysing and visualising data. The programme covers data connections, interactive reports, slicers, Power Query, simple DAX calculations and data modelling. Participants will learn how to organise information and create reports that support business analysis and decision-making.

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

Yes. The course is designed for beginners and participants with some experience using Power BI Desktop. No prior Power BI knowledge is required. However, participants should have a basic understanding of Microsoft Excel, as this will help them understand 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 Power BI fundamentals, report creation, data visualisation, Power Query, simple DAX measures and data modelling. Power BI Desktop Essentials Plus Advanced is a 3-day course that includes the same foundational modules from the 2-day programme, followed by an additional day covering advanced DAX calculations, ranking, time intelligence, advanced Power Query techniques and complex data modelling.

04 What will I learn about Power Query and DAX during the Power BI Essentials course?

You will learn how to use Power Query to clean, transform, merge and append data from different sources. The course also introduces simple DAX measures for performing calculations within Power BI reports. These skills help prepare information for analysis and improve the accuracy of reporting.

05 How long does the Power BI Desktop Essentials course take?

The course takes two days, with training sessions running from 9:00 AM to 5:00 PM. Day 1 focuses on Power BI fundamentals, visualisations and basic report creation. Day 2 covers multiple-page reports, data connections, Power Query and data modelling.

06 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 Power BI software installed . Training handouts and reference materials are also provided.

07 Will I receive a certificate after completing the Power BI Desktop Essentials course?

Yes. Participants receive a Power BI Certification of Attendance after completing the training. This certificate recognises completion of the 2-day programme covering Power BI reporting, data transformation and modelling

08 What language is the Power BI Desktop Essentials course conducted in?

The training is conducted bilingually in English and Bahasa Melayu.

09 Is the Power BI Desktop Essentials course HRD Corp claimable?

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

10 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.

11 Can I attend Power BI Desktop Essentials 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.

12 Can I repeat the Power BI Desktop Essentials course if I need more practice?

Yes, free repeat classes are offered every month, no questions asked, if you need a refresher. The online repeat-class arrangement is subject to confirmation

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