Fundamentals of Microsoft Power BI
This 2-day Power BI fundamentals course in Malaysia gives participants the practical foundation to connect data sources, build relationships between datasets, write basic DAX formulas, and produce dashboards that tell a clear business story.
Designed for corporate professionals with no prior Power BI experience. Thisi is a HRD Corp claimable course.
per person
Level
Duration
Training Delivery Format
Face-to-face / Virtual Class
per person
Level
Duration
Training Delivery Format
Face-to-face (F2F) / Virtual Class
Class types
Public Class
Private Class
In-House Training
Bespoke
About this course
Power BI is Microsoft’s business intelligence tool used by organizations globally to turn raw data into visual dashboards and reports. This course introduces participants to the core features of Power BI Desktop — from connecting a data source all the way through to building a working dashboard.
The course emphasizes practical, hands-on learning. Participants work with Excel spreadsheets throughout, making the content immediately relevant for anyone already working with business data. By the end of Day 2, participants will have built their own data model and produced a dashboard from scratch.
This is a non-certification course. It does not lead directly to the Microsoft PL-300 exam. It is designed for corporate professionals who need to use Power BI at work.
Who should attend?
This course is suitable for:
- Corporate executives and managers who need to read or build Power BI dashboards
- Operations, finance, HR, and sales professionals transitioning from Excel-based reporting
- Individuals in the corporate industry who work with business data regularly and want to visualize it more effectively
- Anyone starting from zero with Power BI and needing a practical, tool-focused foundation
No prior Power BI experience is required. Basic familiarity with Excel is helpful.
Learning Outcome
By the end of this course, participants will be able to:
- Connect Power BI Desktop to data sources including Excel files and databases
- Import and query data using the direct query and import methods
- Build a working relational data model with configured relationships
- Create calculated columns and measures using basic DAX (Data Analysis Expressions)
- Design dashboards using bar charts, column charts, KPI cards, tables, slicers, and map visualizations
- Apply conditional formatting and drill-up/drill-down navigation
- Transform a raw data source into a complete, presentation-ready Power BI dashboard
Prerequisites
There are no formal prerequisites for this course. Participants are expected to have:
- Basic familiarity with Microsoft Excel (able to open, read, and work with spreadsheet data)
- No prior Power BI experience needed
Course Content
Module 1: Introduction to Power BI Desktop
- What Power BI is and how it fits into business intelligence.
- Obtaining and setting up Power BI Desktop.
- Overview of the interface and key working areas.
Module 2: Obtaining Data Sources
- Understanding the data window and core concepts.
- Connecting to data sources using direct query or data import.
- Choosing the right connection method for your use case.
Module 3: Data Modelling
- Introduction to data modelling concepts.
- The fundamental qualities of effective dashboards.
- Configuring and managing relationships between tables.
- Adding and formatting columns to enhance data presentation.
- Understanding the difference between calculated columns and measures.
- Activity: Participants build their own data model from a provided dataset.
Module 4: Introduction to DAX (Data Analysis Expressions)
- What DAX is and how it differs from Excel formulas.
- Writing and structuring clear DAX expressions.
- Key DAX functions: compute functions and time intelligence DAX.
- When to use measures versus calculated columns.
- Activity: Participants write and test their own DAX expressions.
Module 5: Data Visualization
- Why data visualization matters for business communication.
- Overview of the Power BI visualization window. Building tables with conditional formatting.
- Using cards, gauges, and KPIs for business objective tracking.
- Creating bar and column charts. Applying slicers and timeline slicers for interactivity. Using the formatting panel, sort order, drill-up and drill-down, data hierarchies, target lines, and map visualizations.
- Final Exercise: Participants transform a raw data source into a complete, presentation-ready dashboard.
At this time, this course is available for private class and in-house training only. Please contact us for any inquiries.