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 Mastery E-Learning
MicrosoftbeginnerE-LearningBahasa Melayu

Microsoft Power BI Mastery E-Learning

Dari Excel ke dashboard interaktif. Belajar Power BI step by step.

Kuasai Power BI dari sifar hingga mahir. Belajar import data, Power Query ETL, data modeling, DAX, bina dashboard interaktif, dan publish ke Power BI Service.

10h 4m 97 lessons 14 modules 410 students
Microsoft Power BI Mastery E-Learning

Preview Video

About This Course

What You Will Learn

Kenal pasti komponen utama Power BI dan kegunaannya dalam analisis data
Install dan setup Power BI Desktop dengan settings yang optimum
Import data dari pelbagai sumber: Excel, CSV, Website, SharePoint
Bersihkan dan transform data menggunakan Power Query (Split, Merge, Append, M-Language)
Faham konsep ETL (Extract, Transform, Load) dalam Power BI
Bina data model Star Schema dengan relationship yang betul
Tulis formula DAX: SUM, SUMX, COUNTROWS, RELATED, CALCULATE
Gunakan Advanced DAX: Time Intelligence, Cumulative Sales, Sales Last Year
Reka bentuk dashboard profesional mengikut best practice visualisasi data
Guna teknik lanjutan: Drill-through, Conditional Formatting, Edit Interactions, Bookmarks
Publish dashboard ke Power BI Service dan share dalam organisasi
Setup Gateway dan Schedule Refresh untuk data yang sentiasa terkini

Free Preview Available

1 lesson is available to preview for free. Look for the FREE badge below.

Curriculum

Pengenalan CourseFREE
4 min
Disclaimer
4 min
Persediaan Sebelum Mula Pembelajaran

Who Should Attend

Data Analyst & Business Analyst

Yang ingin kuasai Power BI untuk bina dashboard dan laporan analisis data yang profesional.

Pengurus & Eksekutif

Yang ingin faham cara baca dan guna dashboard data untuk buat keputusan bisnes yang lebih baik.

Pelajar & Fresh Graduate

Yang ingin tambah skill Power BI untuk meningkatkan peluang kerjaya dalam bidang data.

Professional dari semua bidang

Sales, Marketing, HR, Finance, Operations — sesiapa yang berurusan dengan data dan laporan.

Excel Power Users

Yang sudah mahir Excel dan ingin naik taraf ke Power BI untuk analisis data yang lebih berkuasa.

Training Syllabus

Modul 1-3

Pengenalan & Setup

  • Pengenalan course dan persediaan pembelajaran
  • Apa itu Data Analysis dan roles dalam data industry
  • Install Power BI Desktop dan setup options
Modul 4

Get Data (Power Query)

  • Import data dari Excel, CSV dan pelbagai sumber
  • Tukar data ke format table
  • Kenali Power Query interface dan navigation
Modul 5

Clean, Transform & Load (ETL)

  • Profiling data dan data cleansing
  • Split Column, Append, Merge Queries
  • M-Language dalam Advanced Editor
  • Create Date Table dan Queries Management
  • Pivot, Unpivot dan Load to Power BI
Modul 6

Data Modeling

  • Konsep Star Schema: Fact Table & Dimension Table
  • Relationship dan cardinality
  • Hands-on data modeling dan optimization tips
Modul 7-8

DAX & Measure Management

  • Asas DAX: SUM, SUMX, COUNTROWS, RELATED
  • CALCULATE, FILTER, Percentage calculation
  • Change data format dan Key Measure management
Modul 9-10

Advanced DAX & Add Column

  • Time Intelligence: Sales Last Year, Cumulative Sales
  • Tambah column menggunakan DAX dan Power Query
  • Bonus: Gunakan AI tools untuk DAX dan M-Language
Modul 11

Dashboard Building

  • Bina dashboard lengkap: Charts, KPI Cards, Slicers, Maps
  • Themes, Conditional Formatting, Edit Interactions
  • Drill-through, Tooltips, Bookmarks, Button Navigation
  • Best practice visualisasi data dan storytelling
Modul 12-13

Publish, Share & Data Source

  • Publish ke Power BI Service
  • Share dalam organisasi dan secara public
  • Setup Gateway dan Schedule Refresh
  • Urus datasource: OneDrive, SharePoint integration

Benefits for Your Organisation

Kurangkan masa membuat laporan manual dengan dashboard automatik
Keputusan bisnes berdasarkan data real-time, bukan tekaan
Dashboard interaktif yang boleh diakses dari mana-mana peranti
Satu sumber kebenaran untuk semua jabatan dalam organisasi
Staf boleh bina laporan sendiri tanpa bergantung kepada pasukan IT
Integrasi lancar dengan Microsoft ecosystem (Excel, SharePoint, Teams)

Frequently Asked Questions

Enrol Now

Monthly
RM20/mo
Annual
RM149/yr

Save more

Annual: Save RM91/yr vs monthly (38% cheaper)

Or get All Access Pass for or

This Course Includes

  • 97 structured lessons
  • 14 modules
  • 10h 4m of content
  • Certificate of completion
  • 1 free preview lesson
  • Downloadable resources