What is the duration of the Professional Certificate program?

The program is delivered over 5 days and consists of four progressive modules covering Power BI fundamentals, DAX, data modelling, and data visualization and storytelling.

What will I learn during the program?

You will develop practical skills in data preparation with Power Query, DAX calculations, data modelling, and Power BI dashboard design and storytelling.

Is this program suitable for beginners?

Module 1 is designed for beginners and participants with little or no exposure to programming concepts, provided they are familiar with Microsoft Excel. Later modules require progressively stronger knowledge of Power BI, data modelling and DAX.

What certificate will I receive?

Professional Certificate Data Analytics with Microsoft Power BI Awarded by The Graduate School of Business, Universiti Sains Malaysia Certificate of Completion By GemRain Consulting Microsoft Power BI Data Analyst Associate Available with exam option upon passing the examination

Are assessments required to complete the program?

Yes. The program includes both formative and summative assessments. Depending on the module, assessments include quizzes, hands-on labs, practical tests, projects, dashboard work and an oral examination.

What are the prerequisites for the program?

Prerequisites vary by module. Module 1 is suitable for beginners familiar with Microsoft Excel, while DAX and data modelling modules recommend prior knowledge of Power BI, data modelling, or DAX.

Is this program HRDC claimable?

Yes. The Professional Certificate in Data Analytics with Microsoft Power BI is HRDC claimable under the Certification category, subject to the applicable HRDC requirements and approval process.

PROFESSIONAL CERTIFICATE PROGRAM

Professional Certificate in
Data Analytics
with Microsoft Power BI

Transform Data into Insights.

Build Analytical Capability.

A comprehensive 5-day program designed to develop your practical skills in transforming raw data into meaningful insights, building reliable data models and creating impactful Power BI dashboards.

5 DAYS

Total Duration

4 MODULES

Progressive Learning

INSTRUCTOR-LED

(Physical or Virtual)

HANDS-ON LEARNING

with Real Data Scenarios

PROFESSIONAL CERTIFICATE

Upon Completion

YOUR LEARNING JOURNEY

From Raw Data to Business Insights

A structured 5-day learning journey to help you connect and prepare data, perform advanced analysis, build robust data models, and communicate insights through effective Power BI dashboards.

Explore the Program

01

CONNECT & PREPARE

Connect to data sources and transform raw data using Power Query

02

CALCULATE

Develop practical DAX skills for advanced analysis

03

MODEL

Build accurate and sustainable data models

04

VISUALIZE & TELL THE STORY

Design impactful dashboards to communicate insights effectively

WHAT YOU WILL DEVELOP

Build Practical Skills for Real-World Impact

Gain the technical skills and confidence to turn data into decisions.

Prepare and Transform Data

Connect to data sources, clean and transform data using Power Query.

Covered in Module 1

Develop Advanced Calculations

Work with DAX functions, evaluation contexts and time intelligence.

Covered in Module 2

Build Reliable Data Models

Design star schemas, manage relationships and optimize data structures.

Covered in Module 3

Design Effective Dashboards

Apply best practices and storytelling techniques for clear and impactful insights.

Covered in Module 4

PROGRAM STRUCTURE

A 5-Day Learning Journey

Four progressive modules. Practical Skills. Real Business applications.

View Course Content

DAY 1

DAY 2 - 3

DAY 4

DAY 5

Module 1

Fundamentals of Data Analytics using Microsoft Power BI

1 DAY

Data connection
Data preparation
Power Query
Reports & dashboards

Module 2

Mastering Formulas with DAX

2 DAYS

DAX fundamentals
Measures & calculations
Evaluation contexts
CALCULATE and iterators
Time intelligence

Module 3

Data Modeling Essentials in Power BI with DAX

1 DAY

Star schema
Relationships
Date dimensions
Many-to-many
Granularity

Module 4

Dat Visualization & Storytelling with Power BI Dashboards

1 DAY

Dashboard strategy
Visualization
7 Golden Rules
Storytelling
Effective design

EXPLORE THE MODULE

Detailed Content for Each Module

Click on each module to view the full details, learning objectives and key topics.

analytics dashboard interface on desk.png

Module 1: Fundamentals of Data Analytics using Microsoft Power BI

Build a strong foundation in Power BI and the data analytics process. Learn how to connect to different Data sources, understand datasets and relationships, clean and transform data using Power Query, and create reports and dashboards.

Key Topics Include:

What is Power BI?
Connecting to data sources
Data preparation with Power Query

Transforming and cleaning data
Creating reports and dashboards
Hands-on exercise and practical scenarios

View Full Module Details

data analyst working on modern dashboards.png

Module 2: Mastering Formulas with Data Analysis Expressions (DAX)

Develop practical skills in DAX, the native expression language used in Power BI. Learn to write formulas, work with table functions and evaluation contexts, and apply CALCULATE, iterators, and time intelligence to solve analytical scenarios.

Key Topics Include:

Introduction to DAX and data types
Calculated columns and measures
Table functions and filtering
Evaluation contexts

CALCULATE function
Iterators and ranking
Time intelligence calculations
Hierarchies in DAX

View Full Module Details

data analytics and business chart close up.png

Module 3: Data Modeling Essentials in Microsoft Power BI with DAX

Learn the essential techniques for building accurate, sustainable, and well-performing data models in Power BI. Explore schema design, relationships, date dimensions, many-to-many scenarios, and different data granularities through practical examples.

Key Topics Include:

Introduction to data modelling
Facts, dimensions and star schemas
Normalization and denormalization
Date and time dimensions

Many-to-many relationships
Bidirectional filtering
Different data granularities
Data modelling with DAX

View Full Module Details

modern data dashboard glowing on tablet screen with automated metrics.png

Module 4: Data Visualization & Storytelling with Power BI Dashboards

Transform data and analysis into clear, effective, and engaging Power BI dashboards. Learn the principles of dashboard design, apply the 7 Golden Rules of Dashboard Design, and use visualization and storytelling techniques to communicate insights effectively.

Key Topics Include:

Strategizing a Power BI dashboard
The 7 Golden Rules of Dashboard Design
Dashboard visualization techniques
Selections and bookmarks

Storytelling and navigation
Designing for a target audience
Highlighting relevant information
Creating clear and effective dashboards

View Full Module Details

ASSESSMENT & CERTIFICATION

Learn. Apply. Demonstrate Your Capability.

The program includes formative and summative assessments to ensure practical learning and application.

Formative Assessment

60%

Hands-on labs
Quizzes
Short assignments
Projects and participation

Summative Assessment

60%

Practical tests
Data modeling project
Dashboard project
Examination (where applicable)

Certificate

Certicate awarded by The Graduate School of Business, Universiti Sains Malaysia
Certificate of completion
Microsoft Power BI Data Analyst Associate Certificate (after passing the exam)

WHO SHOULD ATTEND?

Designed for Professionals Across Industries

Whether you are a business professional, data user or part of a reporting team, this program will help you build practical data analytics skills.

Business & Data Professionals

Power BI Users

looking to deepen their skills

Reporting & Business Intelligence Teams

Professionals Building Technical Capability

Prerequisites

Basic familiarity with Microsoft Excel
No prior programming experience required
Suitable for beginners and existing Power BI users

FREQUENTLY ASKED QUESTIONS

Your Questions, Answered

Find answers to common questions about the program, certification and registration.

Professional Certificate in Data Analytics with Microsoft Power BI

From Raw Data to Business Insights

Build Practical Skills for Real-World Impact

A 5-Day Learning Journey

Detailed Content for Each Module

Learn. Apply. Demonstrate Your Capability.

Designed for Professionals Across Industries

Your Questions, Answered

What is the duration of the Professional Certificate program?

What will I learn during the program?

Is this program suitable for beginners?

What certificate will I receive?

Are assessments required to complete the program?

What are the prerequisites for the program?

Is this program HRDC claimable?

Enquire About the Program

Professional Certificate in
Data Analytics
with Microsoft Power BI