Login / Register

Shopping cart

Microsoft Power BI Intermediate

Last Update:

July 31, 2026

Accredited by:

Course Overview

Course Synopsis
This one-day Power BI Intermediate Training is designed for individuals who have some prior
experience with Power BI and want to deepen their knowledge and skills. The course will cover
advanced data transformation techniques, creating complex visualizations, and exploring more
advanced Power BI features. Participants will leave with the ability to tackle more complex data
analysis and reporting tasks.

Course Objectives

By the end of this course, participants should be able to:

  • Perform advanced data transformations using Power Query.
  • Create complex and interactive visualizations.
  • Build advanced reports with drill-through actions.
  • Understand advanced DAX functions for calculations.
  • Work with Power BI features for time intelligence and advanced analytics.

Target Audience

  • Data analysts with some prior experience in Power BI.
  • Business intelligence professionals.
  • Data professionals looking to enhance their Power BI skills.
  • Those who want to create more sophisticated and impactful reports.

Prerequisites

  • Completion of Power BI Basic training or equivalent knowledge.
  • A solid understanding of data modeling concepts.
  • Familiarity with DAX functions (basic knowledge is acceptable).
  • Access to a computer with Power BI Desktop installed (the free version is sufficient).

Training Content

1. Advanced Data Transformation
  • Power Query Advanced Techniques
  • Merging and appending queries
  • Conditional columns and custom functions
  • Data Modeling
  • Understanding relationships and cardinality
  • Managing relationships in the data model
2. Advanced Visualization Techniques
  • Heat maps, tree maps and funnel charts
  • Use custom visuals and marketplace visuals
  • Creating drill-through actions in reports
  • Implementing hierarchical navigation
3. Advanced DAX Calculations
  • Introduction to DAX
  • Review of basic DAX functions
  • Understanding evaluation context
  • Advanced DAX functions
  • CALCULATE, FILTER and ALL functions
  • Time intelligence functions (DATESYTD, TOTALYTD, etc.)
4. Sharing and Publishing Power BI Reports
  • Create reports and dashboards
  • Explore Power BI Service
  • Collaboration and sharing options
  • Power BI apps and content distribution

Price From:

RM799.00

Enquire for More Info

Courses You May Like

CERTIFICATION

CERTIFICATION

CERTIFICATION

2 Days

Intermediate

RM10,500.00