HRDC Registered Training ProviderHRDC Registered Training Provider|HRDF Claimable TrainingAll Public Trainings are HRDF Claimable
Digital Analytic Solution
Digital Analytic Solution
Start Free
Digital Analytic SolutionDigital Analytic SolutionHomeCoursesLive TrainingCorporatePortfolioResourcesAboutContact
Log inStart Free

Loading...

Digital Analytic SolutionDigital Analytic Solution

From Data to Decisions

Practical, industry-tested data analytics training - taught by practitioners, built for real-world impact.

Quick Links

  • Home
  • Courses
  • Live Training
  • Corporate Training
  • Portfolio & Services
  • About
  • Contact

Courses

  • Power BI for Business Intelligence
  • AI Productivity Tools
  • n8n Automation
  • Vibe Coding
  • Excel for Analytics
  • Google Workspace

HRDF Claimable

All live programs eligible

Contact

  • Puchong, Selangor, Malaysia
  • admin@digitalanalyticsolution.com
  • 012-341 1354
  • digitalanalyticsolution.com
  • belajarpowerbi.com

Ready to upskill?

Start with a free course today.

Start Free →
HRDC Registered Training ProviderHRDC Registered
Training Provider
HRDF Claimable TrainingHRDF Claimable
Programmes

All public training programmes are eligible for HRDF claims via the HRD Corp e-TRiS portal.

© 2026 Digital Analytic Solution Sdn Bhd. All rights reserved.

From Data to Decisions

Privacy Policy·Terms of Use
Courses/Microsoft Power BI & PL-300: Dari Zero ke Advance
MicrosoftbeginnerE-Learning HRDF Claimable🇲🇾 Bahasa MelayuNew

Microsoft Power BI & PL-300: Dari Zero ke Advance

Stop copy-paste numbers ke slides. Build dashboards yang orang actually buka.

Master Power BI dari zero hingga advance. Belajar import data, Power Query, DAX, bina interactive dashboard, dan publish reports ke Power BI Service. Termasuk 6 portfolio projects dan PL-300 exam prep.

50 hours 111 lessons 11 modules 7 students

Preview Video

About This Course

What You Will Learn

Faham Power BI ecosystem: Desktop, Service, Mobile, dan Fabric
Install dan setup Power BI Desktop di Windows dan macOS (Parallels)
Import data dari Excel, CSV, SharePoint, OneDrive, REST API, PDF, dan Google Sheets
Clean dan transform data menggunakan Power Query (Transform, Add Column, M Language)
Faham data flow: Excel → Power Query → Power BI dan 3 rules of non-destructive transformation
Build Star Schema data model dengan Fact Table dan Dimension Table
Write DAX formulas: Measure, Calculated Column, Time Intelligence, CALCULATE, Iterator Functions
Faham Power Query vs DAX decision tree — bila guna mana
Design professional dashboard mengikut principles of layout, colour, typography, dan storytelling
Guna AI (Claude, ChatGPT, Copilot) untuk write DAX, debug errors, dan generate M code
Publish reports ke Power BI Service dengan Row Level Security dan Schedule Refresh
Build 1 complete portfolio project mengikut bidang: Sales, Marketing, HR, Finance, Operation, atau Project Management
Prepare untuk Microsoft PL-300 certification exam dengan practice questions dan simulation

Free Preview Available

20 lessons are available to preview for free. Look for the FREE badge below.

Curriculum

1.1 Apa Itu Power BI & Kenapa Ia Penting?FREE
1.2 Ekosistem Power BI: Desktop, Service, Mobile & FabricFREE
1.3 Siapa Pakai Power BI & Siapa Patut Belajar?FREE
1.4 Course Roadmap & Cara Belajar EfektifFREE

Who Should Attend

Sales & Marketing

Track sales pipeline, analyse campaigns, dan build team performance dashboard secara automatik.

HR & People Analytics

Visualise employee data, attendance, performance, dan turnover dalam dashboard yang clear.

Finance & Accounting

Automate P&L reports, budget vs actual analysis, dan financial analytics guna DAX.

Operations & Project Mgmt

Monitor operations KPI, project status, dan productivity dalam satu dashboard.

Students & Fresh Graduates

Build Power BI portfolio mengikut bidang pengajian untuk boost career opportunities.

Managers & Executives

Faham cara read dan guna data dashboard untuk make better business decisions.

Training Syllabus

Module 1

Introduction to Power BI

  • Apa itu Power BI & kelebihan vs Excel & Tableau
  • Ecosystem: Desktop, Service, Mobile, Fabric
  • License: Free vs Pro vs Premium
  • Siapa yang pakai & course roadmap
Module 2

Setup & Installation

  • Install di Windows (system requirements & steps)
  • Setup di macOS (Parallels, Service, Azure VM)
  • Cara guna e-learning ini dengan efektif
  • Best practice monthly update
  • Kenali interface: Report, Data, Model View
Module 3

Data World & Import

  • Data analogy & basic concepts (row, column, table)
  • Data types, file formats, free dataset sources
  • Import dari Excel, CSV, Folder (multiple files)
  • Import dari SharePoint, OneDrive, REST API, PDF, Google Sheets
  • DirectQuery vs Import Mode
  • Data flow concept: Excel → Power Query → Power BI
Module 4

Power Query & First Dashboard

  • Power Query Editor basics & Applied Steps
  • Add Transform: Split, Merge, Extract, Group By, Format
  • Add Column: Conditional, Custom (M Code), From Examples, Index
  • Append, Merge, Pivot, Unpivot
  • 5 hands-on exercises (data type, rename, replace, null, split)
  • Build first visual: Chart, Card, Slicer
  • First dashboard siap ← end of FREE preview
Module 5

Data Modeling & Star Schema

  • Kenapa data modeling penting
  • Star Schema: Fact Table & Dimension Table
  • Exercise: Duplicate/Reference split Fact & Dim
  • Create relationships & cardinality
  • Date Table: M Code & DAX CALENDAR()
Module 6

DAX — Basic to Advanced

  • DAX basics: Measure vs Column, Filter Context
  • CALCULATE, FILTER, ALL, ALLEXCEPT, RELATED
  • Iterator Functions: SUMX, RANKX, TOPN, DIVIDE
  • Time Intelligence: YTD, YoY, DATEADD, Rolling Average
  • VAR...RETURN & P&L statement
  • Power Query vs DAX: Decision Tree
Module 7

AI-Powered Workflow

  • Traditional vs AI: bila guna mana
  • Template Prompt DAX, Debug Error, M Code
  • Microsoft Copilot in Power BI
Module 8

Dashboard Design & Best Practices

  • Design principles: grid, hierarchy, colour, typography, whitespace
  • Choosing the right visual: comparison, trend, composition, KPI, geography
  • Advanced UX: Drillthrough, Tooltip, Bookmark, Button Navigation
  • Themes, Conditional Formatting (7 exercises), Custom Visuals
Module 9

Portfolio Projects — 6 Industries

  • Sales: TechMart — Revenue, Achievement %, Salesperson Ranking
  • Marketing: GlowUp Beauty — Leads, CPL, ROAS, Funnel
  • HR: Maju Corp — Headcount, Turnover, Absenteeism
  • Finance: Warung Sedap — P&L, Budget Variance, EBITDA
  • Operations: PrecisionParts — OEE, Availability, Defect Rate
  • Project Mgmt: BuildRight — On Track %, Budget Util, Overdue Tasks
Module 10

Publish, Share & Production

  • Publish ke Power BI Service
  • Row Level Security (RLS) Static & Dynamic
  • Schedule Refresh & On-Premises Gateway
  • Share, Embed dalam Teams/SharePoint, Power BI Apps
Module 11

PL-300 Exam Preparation

  • Exam overview, registration & cost
  • 4 exam domains with practice questions
  • Microsoft Learn free study path
  • Exam tips & answer strategy
  • Full practice exam simulation

Benefits for Your Organisation

Reduce manual reporting time up to 80%
Single source of truth untuk semua departments dalam shared dashboard
Real-time dashboard accessible dari mana-mana device
Data-driven decisions, bukan guesswork
Claimable melalui HRDF/HRDC untuk staff training
Staff boleh build reports sendiri tanpa depend on IT team

Frequently Asked Questions

Your Instructor

H

Hariz

Founder & Lead Trainer

Digital Analytic Solution Sdn Bhd

HRDC Certified Trainer, Microsoft PL-300 Certified, Power BI Hackathon Champion. From oil and gas engineer to data analytics practitioner and trainer.

HRDC CertifiedPL-300MBOT Ts.First Class Honours

Enrol Now

Lifetime
RM999RM329
67% OFFSave RM670
Or get All Access Pass for or

This Course Includes

  • 111 structured lessons
  • 11 modules
  • 50 hours of content
  • Certificate of completion
  • HRDF/HRDC claimable
  • 20 free preview lessons