Microsoft Power BI Data Analyst
This 3-day Power BI training in Malaysia course takes participants from zero experience to building AI-powered, interactive dashboards — covering data connection, transformation, DAX formulas, report design, and built-in AI analytics.
Fully aligned to the Microsoft PL-300 exam domains. No prior Power BI experience required. This is 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
This course covers the methods and best practices aligned with business and technical requirements for modeling, visualizing, and analyzing data using Microsoft Power BI Desktop.
Participants learn to connect and transform data from multiple sources — including relational databases, Excel files, SharePoint, and web data. They then build optimized data models, write calculated measures using DAX (Data Analysis Expressions), and design interactive dashboards for business reporting.
This course also covers AI-powered features built into Power BI Desktop: automated anomaly detection, Key Influencers analysis, Smart Narratives, and natural language Q&A — tools that surface insights without any coding.
The course runs across 5 structured stages with hands-on labs at every stage. Participants complete a full Power BI dashboard from raw data to final published report as their final exercise.
All content maps directly to the four exam domains of the PL-300: Microsoft Power BI Data Analyst exam. Participants who want to pursue the Microsoft Certified: Power BI Data Analyst Associate credential will leave with the foundation to do so.
Who should attend?
This course is suitable for:
- Data analysts and business analysts transitioning from Excel-based reporting to Power BI
- IT professionals supporting business intelligence tools within their organization
- Managers and decision-makers who need to read, build, or commission data dashboards
- Finance, operations, and HR professionals who work with data regularly but have no formal BI training
- Individuals preparing for the PL-300 exam who want structured, instructor-led preparation
No prior Power BI experience is required.
Learning Outcome
By the end of this course, participants will be able to:
- Connect and transform data from multiple sources including databases, Excel, SharePoint, and the web
- Build optimized relational data models using star schema design
- Create calculated fields and business measures using DAX
- Design interactive reports with drill-through navigation, slicers, and bookmarks
- Apply Power BI AI features to detect anomalies, identify key influencers, and generate automated insights
- Query data using natural language via the Q&A visual
- Publish reports and understand row-level security (RLS) basics
- Produce a complete Power BI Desktop dashboard from raw data to final report
Prerequisites
There are no formal prerequisites for this course. Participants are expected to have:
- Basic familiarity with Microsoft Excel
- A general understanding of what business data looks like
- No prior Power BI experience required
Participants who have completed the Fundamentals of Microsoft Power BI (Desktop) course will find this course a natural next step.
Course Content
Module 1: Connecting and Shaping Data
- Power BI Desktop interface, data connectors (Excel, CSV, databases, SharePoint, OneDrive, web), Power Query Editor, table transformations, data profiling, text/numerical/date tools, pivoting and unpivoting, merging and appending queries, importing Excel models.
- Hands-on Lab: Transform raw Excel data into a clean analytical dataset.
Stage 2: Creating a Relational Data Model
- Database normalization, fact and dimension tables, star and snowflake schemas, relationship cardinality, filter context and flow, bi-directional filters, model layouts, hierarchies, and date models.
- Hands-on Lab: Build a star-schema model from transformed data.
Stage 3: Adding Calculated Fields with DAX
- Introduction to DAX, calculated columns versus measures, DAX syntax and operators, mathematical and statistical functions, CALCULATE / FILTER / ALL, time intelligence patterns, RELATED and LOOKUPVALUE.
- Hands-on Lab: Create sales, profit, growth, and time-based measures.
Stage 4: Visualizing Data with Reports
- Dashboard design best practices, KPI cards, bar/line/combo charts, conditional formatting, drill-up/drill-down/drill-through, slicers, bookmarks, page navigation, row-level security overview, mobile report layouts, publishing concepts.
- Hands-on Lab: Build an interactive sales performance dashboard.
Stage 5: AI Features in Power BI Desktop
- Key Influencers visual, Decomposition Tree, Q&A natural language queries, Smart Narratives, Anomaly Detection, overview of Copilot in Power BI.
- Hands-on Lab: Use AI visuals to analyze performance drivers, trends, and anomalies.
Final Exercise: Load and transform data, build a relational model, write DAX measures, design interactive reports, apply AI visuals, and produce a complete Power BI Desktop dashboard.
At this time, this course is available for private class and in-house training only. Please contact us for any inquiries.