Introduction

Data analytics and visualisation through Microsoft Power BI can assist organisation in making informed decisions for complex problems (such as on products or services) through data insights produced by the tool. Data insights can be obtained from the data patterns generated through data analysis and visualisation processes. Participants will be able to extract, examine, experiment, and present data attractively with ease and speed.

This course is designed to help participants learn how to analyze data and create interactive reports and dashboards using Power BI. It teaches how to gather data from different sources, clean and transform it, and turn it into meaningful visuals that support better decision-making. The course also introduces basic data analysis concepts and gives hands-on experience with tools like Power Query and DAX, making it easier to understand trends and share insights in a simple and clear way.

Learning Outcome

At the end of the program, participants will be able to:

• Import data to Microsoft Power BI.
• transform data using Query Editor.
• Manage Table Relationships.
• utilise Data Analysis Expressions (DAX).
• create Data Visualisations.

Key Topics

Key topics include:

• Setting up the data
• Join multiple data sources into one
• Combine diverse sources of information in one analytical solution
• Design Data Model
• Hierarchies 
• Time series
• Use of aggregations
• Summarise information
• Create various charts
• Maps
• Scatterplots
• Interactive dashboards for each project
• Create histograms
• Brickcharts

Duration

3 Days | 19.5 Hours

Target Participant

• Executive Services 1 (ES 1) – Bahagian I: Kumpulan 1 | 2 | 3
• Executive Services 2 (ES 2) – Bahagian II: B3 | B2
• Executive Services 3 (ES 3) – Bahagian III: C3 | C2 | C1

Pre-Requisite

N/A

Language

English

Methodology

The course will be delivered using:

• Instructor-Led Training
• Hands-On Laboratory
• Demonstration
• Case-Study

Assessment Methods

Pre-Test & Post-Test

Program Evaluation