Next public class: Power BI Mastery Live · 24 Oct 2026 · Zoom. Register now
Digital AnalyticSolution Sdn Bhd
  • Services
  • Team trainingIn-house programmes for your organisationProgramme cataloguePower BI, Excel and AI agentsLive trainingUpcoming Zoom and classroom sessionsE-learning coursesSelf-paced video lessons, learn anytime
  • Power BI hubConsulting, training and learning in one placeLive dashboard demosClick through real Power BI dashboardsE-Learning Power BI MasterySelf-paced video libraryLive Webinar Power BI MasteryLive on Zoom with the trainerSeminar Fizikal Power BI MasteryTwo-day classroom in Shah AlamAll Access: Power BI + PL-300E-learning plus PL-300 preparation
  • ArticlesPractical notes on Power BI, automation and AIFree resourcesTemplates, guides and checklistsReporting assessmentCheck how ready your reporting is
  • About
  • Contact
Log inBook a Call
Services
TrainingTeam trainingProgramme catalogueLive trainingE-learning courses
Power BIPower BI hubLive dashboard demosE-Learning Power BI MasteryLive Webinar Power BI MasterySeminar Fizikal Power BI MasteryAll Access: Power BI + PL-300
ResourcesArticlesFree resourcesReporting assessment
AboutContactLog inBook a Call

Loading...

Digital AnalyticSolution Sdn Bhd

From data to decisions.

  • 012-341 1354
  • admin@digitalanalyticsolution.com
  • WhatsApp us

Our work

HomeServicesLive dashboardsProgramme cataloguePublic classes

Company

AboutBlogFree resourcesContact

© 2026 Digital Analytic Solution Sdn Bhd · 202401013298 (1559148-D) · Puchong, Selangor

Let’s continue on WhatsApp

Share a few details and we will reply on WhatsApp.

“”

We save your details to follow up on this inquiry.

E-learning courses/Microsoft Power BI & PL-300: Dari Zero ke Advance
MicrosoftbeginnerE-LearningBahasa Melayu HRD Corp claimableNew

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 28 students
Microsoft Power BI & PL-300: Dari Zero ke Advance

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

Monthly
RM25/mo
Annual
RM199/yr

Save more

Annual: Save RM101/yr vs monthly (34% cheaper)

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