Corporate Training • 2 Days • HRD Corp Claimable

Power BI Training Malaysia: Basic to Intermediate (2 Days)

From raw spreadsheets to published, decision-ready dashboards

Microsoft Power BI: Basic to Intermediate is a two-day hands-on programme (HRD Corp programme no. 10001724993) that takes participants from connecting and cleaning raw data through to publishing interactive dashboards in the Power BI Service. Redefine Learning Asia structures the course progressively — Power Query transformations, star-schema data modelling, core DAX functions, and visualization design — with a guided lab in every module and a capstone case study that consolidates the full workflow end to end.

Duration

2 Days

Group Size

Up to 25 participants

Format

On-site / Virtual

HRD Corp

Claimable

When This Programme Is the Right One

The symptom: Reporting eats days every month, and the numbers still arrive as static spreadsheets nobody drills into.

Start from the symptom your team is showing rather than the programme name — buying in the wrong order usually convinces leadership that training does not work. Compare every programme side by side in our symptom-to-programme comparison table.

Learning Outcomes

Participants connect Power BI to Excel, CSV, and database sources and profile data quality before building on it.
Raw data is cleaned and transformed in Power Query Editor — merging, appending, unpivoting — without touching the source files.
Participants build relational models with correct relationships and cardinality, and write core DAX measures including SUM, AVERAGE, and CALCULATE.
Each participant publishes an interactive, multi-page dashboard to the Power BI Service and configures sharing and access.

Programme Agenda

Time	Module	What Happens
Day 1, 9.00am – 10.30am	Introduction to Power BI	The BI ecosystem; Desktop versus Service; reports, dashboards, and datasets. Lab: interface setup and workspace navigation.
Day 1, 10.45am – 12.30pm	Data connectivity	Importing from Excel, CSV, and databases. Lab: live connection drills with structured data files.
Day 1, 1.30pm – 3.30pm	Data import and profiling	Connecting multiple sources; data profiling and quality checks. Lab: column quality, profile, and distribution checks.
Day 1, 3.45pm – 5.00pm	Data transformation masterclass	Advanced Power Query transformations. Lab: merging and appending tables, unpivoting columns, replacing values.
Day 2, 9.00am – 10.30am	Relational data modelling	Star and snowflake schema design; relationships and cross-filtering. Lab: table relationships, active versus inactive joins, cardinality.
Day 2, 10.45am – 12.30pm	DAX foundations	Calculated columns versus measures; SUM, AVERAGE, CALCULATE. Lab: custom KPIs and dynamic table calculations.
Day 2, 1.30pm – 3.30pm	Interactive visualization design	Chart selection, formatting, slicers, and drill-downs. Lab: an executive-ready multi-page template with dynamic tooltips.
Day 2, 3.45pm – 5.00pm	Publishing and collaboration	Publishing to the Power BI Service; sharing and dashboard pinning. Lab: live cloud deployment and access configuration; capstone case study audit.

Activities

Guided labs every module

Concepts are exercised immediately — live connections, profiling drills, transformation clean-ups, KPI building, dashboard formatting.

Capstone case study

A Day 2 end-to-end exercise consolidating modelling, DAX, visualization, and publishing on one realistic dataset.

Progressive difficulty

Foundational to intermediate in two days — no prerequisites, but the pace assumes daily Excel familiarity.

Delivery, Pricing & HRD Corp

Formats: Instructor-led classroom, available in-house or as a public programme; participants need laptops with Power BI Desktop installed. English or Bahasa Malaysia.
Group size: Up to 25 participants
Indicative investment: Quoted per group; typically structured as two facilitated days under a single HRD Corp grant application. Full breakdowns in the 2026 cost guide, or model your claim with the HRD Corp claim calculator.
HRD Corp claimable: Yes. This programme is structured as HRD Corp claimable training under SBL-Khas — certified trainer, documented learning outcomes, minimum contact hours, attendance records, and a completion report formatted for your claim. The grant must be approved at least 14 calendar days before the training date under Employer’s Circular No. 2/2026, so book three to four weeks ahead. See the full claim walkthrough in our HRD Corp claimable training guide.

Microsoft Power BI: Basic to Intermediate FAQs

No — the course starts from foundational concepts. Participants should be comfortable with everyday Excel, because the pace assumes familiarity with tables and formulas. By the end of Day 2 they are writing DAX measures and publishing to the Service.

Yes — it runs as HRD Corp registered programme no. 10001724993, claimable under SBL-Khas for both in-house and public sessions. The claim should be submitted with the standard 14-day lead time.

A laptop with the free Power BI Desktop installed and, for the publishing module, access to a Power BI Service account — a free trial or your organisation's Microsoft 365 tenant both work. We send a setup checklist before the session.

Core working DAX: calculated columns versus measures, and the SUM, AVERAGE, and CALCULATE patterns that cover most business reporting. It deliberately stops short of advanced time intelligence — participants leave able to build real KPIs, not overwhelmed by syntax.

Instructor-led classroom, available in-house or as a public programme; participants need laptops with Power BI Desktop installed. English or Bahasa Malaysia. Redefine Learning Asia delivers nationwide, including Kuala Lumpur, Selangor, Penang and Johor.

Request a proposal for Microsoft Power BI: Basic to Intermediate

Tell us your team size and the problem you need this to fix. You will get a customised proposal with pricing, agenda, and the HRD Corp claim pathway.

WhatsApp Us Send an Enquiry

Related Programmes

AI Training · 1 Day

See every programme and format on our Corporate Training Malaysia page, or browse all corporate training courses.