Course Overview
Develop dynamic reports with Microsoft Power BI
Transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.
What are the skills covered
- Get started building with Power BI
- Get data in Power BI
- Clean, transform, and load data in Power BI
- Configure a semantic model
- Design Power BI reports
- Get started with Copilot in Power BI
- Introduction to end-to-end analytics using Microsoft Fabric
Who should attend this course
- IT professionals
Course Curriculum
What are the Prerequisites
Completion of the Get started with Microsoft data analytics is recommended.
Download Course Syllabus
Course Modules
-
Introduction
-
Use Power BI
-
Building blocks of Power BI
-
Tour and use the Power BI service
-
Knowledge check
-
Summary
- Introduction
- Get data from files
- Get data from relational data sources
- Create dynamic reports with parameters
- Get data from a NoSQL database
- Get data from online services
- Select a storage mode
- Get data from Azure Analysis Services
- Fix performance issues
- Resolve data import errors
- Exercise – Get data in Power BI
- Check your knowledge
- Summary
- Introduction
- Shape the initial data
- Simplify the data structure
- Evaluate and change column data types
- Combine multiple tables into one table
- Profile data in Power BI
- Use Advanced Editor to modify M code
- Exercise – Load data in Power BI Desktop
- Check your knowledge
- Summary
- Introduction
- Configure relationships
- Configure tables
- Configure columns
- Configure hierarchies
- Configure measures
- Configure parameters
- Exercise – Configure a semantic model in Power BI Desktop
- Check your knowledge
- Summary
- Introduction
- Design the analytical report layout
- Design visually appealing reports
- Use report objects
- Select report visuals
- Apply filters and slicers to reports
- Understand filtering techniques and considerations
- Case study – Configure report filters based on feedback
- Exercise – Design Power BI reports
- Check your knowledge
- Summary
-
Introduction
-
Use Copilot in Power BI to prepare and model data
-
Create reports with Copilot in Power BI
-
Get your data ready for AI usage in Power BI
-
Module assessment
-
Summary
- Introduction
- Explore end-to-end analytics with Microsoft Fabric
- Explore data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
- Module assessment
- Summary
Request More Information
Training Options
- ILT: Instructor-Led Training
- VILT: Virtual Instructor-Led Training
RM1,200.00Enroll Now
RM1,200.00Enroll Now
RM1,200.00Enroll Now
RM1,200.00Enroll Now
RM1,200.00Enroll Now
RM1,200.00Enroll Now
Exam & Certification
Note: There is no exam directly associated with this course. However, Microsoft offers an extensive portfolio of industry-recognized certifications that can help you stand out as a tech professional in 2025 and beyond. Achieving Microsoft certification is one of the most effective ways to validate your skills and accelerate your career.
With our expert-led training, you’ll be prepared to:
- Master in-demand capabilities across Cloud, Data & AI, and Cybersecurity — areas driving global digital transformation.
- Prove your expertise with a globally respected credential recognized by employers worldwide.
- Advance your career by enhancing your credibility, increasing your earning potential, and opening doors to new opportunities.
Explore our full range of Microsoft certifications and start building the skills that matter today.
Training & Certification Guide
Mastery Program: Learn AI with Microsoft in 2025
Artificial Intelligence (AI) has been one of the hottest topics in the tech industry for the past decade. With its rapid advancements and potential to impact our daily lives, learning AI has become a highly sought-after skill.
We are thrilled to announce the launch of our Microsoft AI Mastery Program in 2024, made possible through our partnership with Microsoft, a renowned leader in AI technology. This program is tailored for individuals and tech professionals passionate about acquiring and mastering the fundamental and advanced principles of AI.
Top AI Skills Malaysia Needs Today: Advance Your IT Career in 2025
In the quest for AI-driven innovation, Malaysia seeks sharp minds with the right IT skills. Data science, machine learning—these are the tools in high demand. This article examines the AI skills Malaysia needs, the industries driving this change, and how to develop these skills to enhance your career trajectory.
Which AI Certification Is Right for You? A Role-by-Role Guide to Upskilling in 2025
Certifications are more than just a résumé boost—they’re often a key deciding factor. Employers are prioritizing candidates with industry-recognized credentials, not only for technical roles but also for positions in operations, strategy, and product development that now rely on data fluency and AI awareness.
Top 5 High-Paying Cloud Jobs in Malaysia & How to Get Them
In this blog, we break down the top five highest-paying cloud roles in Malaysia, what they entail, and how you can start building a career in this space.
Addressing the AI Skills Gap in Malaysia
The Artificial Intelligence (AI) surge across global industries has created immense potential for innovation and economic growth. For Malaysia, AI is pivotal in its ambition to become a digital-first economy. However, despite this goal, the country faces a significant AI skills gap—a shortfall in the number of skilled professionals equipped to meet the rising demands for AI expertise across various industries.
This blog examines the causes, impact, and initiatives underway to bridge this gap, ensuring Malaysia remains competitive in the digital age.
Top Microsoft Applied Skills Courses to Boost Your Career
Microsoft Applied Skills are scenario-based practical credentials that confirm your ability to tackle real-world challenges using Microsoft technologies.
In this article, we will dive into what these skills are, how they differ from traditional certifications, and the benefits they bring to your career. Expect insights on top courses, the assessment process, and tips for success.
Top AI Machine Learning Certifications to Boost Your Career in 2025
Looking to excel in AI and machine learning? The right certification can make all the difference. This article covers the top AI machine learning certifications for 2025 that can boost your career and validate your expertise in this ever-evolving field.
The Ultimate Guide to the Top Data and AI Skills for 2026
This guide serves as your comprehensive roadmap to navigating this new landscape. We will deconstruct the four essential pillars of Data and AI mastery for 2026, providing a clear blueprint for a future-proof career.
This cornerstone article will provide a high-level strategic overview, setting the stage for our deep-dive blog series that will explore each pillar in granular detail.
Mastering the Foundational Data Analytics Skills That Get You Hired in 2026
This article is your deep dive into the three non-negotiable, must-have data analytics skills that will get you hired in 2026.
Which AI and Machine Learning Skills Will Define 2026?
This article will guide you through the specific, advanced skills that separate a data professional from a true AI specialist in 2026.
Why Data Engineering is the Hottest Tech Career of 2026
In the race to dominate the AI-powered future, companies are investing billions in advanced algorithms and brilliant data scientists. This article explores the essential skills you need to become a data engineer and build the very backbone of AI.
4 Strategic AI Skills Every Manager Needs in 2026
This article breaks down the four essential strategic AI skills every leader needs to master to navigate this new frontier
DP-600T00: Microsoft Fabric Analytics Engineer
This Microsoft course covers methods and practices for implementing and managing enterprise-scale data analytics solutions using Microsoft Fabric.
DP-601T00: Implementing a Lakehouse with Microsoft Fabric
This DP-601T00: Implementing a Lakehouse with Microsoft Fabric course is designed to build your foundational skills in data engineering on Microsoft Fabric, focusing on the Lakehouse concept.
DP-602T00: Implement a data warehouse with Microsoft Fabric
Explore the data warehousing process and learn how to load, monitor, secure, and query a warehouse in Microsoft Fabric.
DP-603T00: Implement Real-Time Intelligence Solution with Microsoft Fabric
Gain the skills to implement real-time analytics using Microsoft Fabric.
DP-604T00: Implement a data science and machine learning solution for AI in Microsoft Fabric
Explore the data science process and learn how to train machine learning models to accomplish artificial intelligence in Microsoft Fabric.
The Microsoft Certified: Power BI Data Analyst Associate certification equips professionals with advanced skills to prepare, model, visualize, and analyze data using Power BI.
Microsoft Certified: Azure AI Engineer Associate
This certification validates the skills of Azure AI Engineers in building, managing, and deploying AI solutions using Azure AI. Candidates participate in all phases of AI solution development, from design and development to deployment, integration, and monitoring.
Microsoft Certified: Azure Data Scientist Associate
The Microsoft Certified: Azure Data Scientist Associate certification is designed for professionals who specialize in data science and machine learning on the Azure platform.
Microsoft Certified: Fabric Analytics Engineer Associate
The Microsoft Fabric Analytics Engineer Associate certification (exam DP‑600) is an intermediate-level credential for data engineers and analysts.
Microsoft Certified: Fabric Data Engineer Associate
The Microsoft Certified: Fabric Data Engineer Associate certification is a role-based credential designed for professionals who specialize in data engineering on the Microsoft Fabric platform.
