Get in Touch
 Duration 14 hours

Course Outline

Review and Data Model Design Principles

  • Comprehending the data modeling layer within Power BI
  • Concepts of star and snowflake schemas
  • Establishing and managing relationships between tables

Introduction to DAX (Data Analysis Expressions)

  • DAX syntax and data types
  • Distinguishing between calculated columns and measures
  • Essential DAX functions: SUMX, CALCULATE, FILTER, RELATED

Advanced DAX and Business Logic

  • Time intelligence functions (YTD, MTD, QTD)
  • Conditional logic and dynamic calculations
  • Ranking, running totals, and comparative metrics

Data Transformation and Optimization

  • Utilizing Power Query for advanced transformations
  • Efficiently combining multiple data sources
  • Enhancing performance via query folding and relationship management

Enhanced Visualizations and Interactivity

  • Custom visuals and marketplace extensions
  • Drill-downs, bookmarks, and what-if parameters
  • Creating paginated and dynamic reports

Performance and Governance in Power BI

  • Best practices for dataset management
  • Optimizing refresh schedules and query performance
  • Implementing row-level security (RLS)

Hands-on Project: Building a Sales Intelligence Dashboard

  • Creating KPIs using DAX measures
  • Designing a model-driven dashboard for business insights
  • Applying governance and sharing best practices

Summary and Next Steps

Requirements

  • Familiarity with the Power BI interface and report creation processes
  • Experience in building dashboards using Power BI
  • Basic knowledge of data relationships and filtering mechanisms

Audience

  • Business intelligence specialists
  • Data analysts and reporting experts
  • Developers focused on data visualization and analytics

Number of participants


Price per participant

Open Training Courses require 5+ participants.

Testimonials (4)

How to use relationships in Power BIand the differences between columns and measurements

LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

The application of Data Modelling and DAX

Rachel KY Wong - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

Emoji setting. SharePoint data source linkage. Concept of DAX in measure and column.

Lam Chit Wui (Ray) - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

Calculate, Measure

TONY ZHOU CHEN - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

Upcoming Courses

Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

2026-11-30 09:30
14 hours
Empire Tower
63214 THB (Online)
63214 THB (Classroom)

Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

2026-12-14 09:30
14 hours
Empire Tower
63214 THB (Online)
63214 THB (Classroom)

Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

2026-12-28 09:30
14 hours
Empire Tower
63214 THB (Online)
63214 THB (Classroom)

Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

2027-01-11 09:30
14 hours
Empire Tower
63214 THB (Online)
63214 THB (Classroom)

Related Courses

Advanced Power BI

 21 Hours

Delivered by an instructor in a live format (either online or onsite), this training is tailored for business analysts, data analysts, and developers seeking to leverage the sophisticated features and tools within Power BI. The primary objective is to master complex data analysis and the creation of highly interactive visual reports.

Upon completing this program, participants will be equipped to:

  • Install and configure Power BI along with all necessary dependencies.
  • Navigate and utilize the advanced features, components, and utilities available in the platform.
  • Gain deep insights into advanced data analysis methodologies and strategic approaches.
  • Implement advanced data modeling strategies.
  • Develop complex formulas and calculations using DAX.
  • Master practical techniques for efficient data handling, visualization, and presentation.
  • Transform reports and dashboards into collaborative, interactive experiences within Power BI.
  • Explore and implement embedded analytics capabilities.
Read more...

Data Analysis and Dashboarding with Power BI

 7 Hours
This live training in Thailand equips beginner and intermediate users with the skills to perform data analysis using Power BI. Learners will master data preparation, construct interactive dashboards, and securely distribute reports, thereby developing the practical abilities necessary for data-driven decision-making in contemporary business environments.
Read more...

Data Analysis with Python, R, Power Query, and Power BI

 21 Hours

This live, instructor-led training held in Thailand (online or onsite) targets entry-level professionals aiming to clean and analyze data, generate statistical forecasts, and produce meaningful visualizations using these tools.

Upon completion of this training, participants will be equipped to:

  • Grasp the fundamentals of Python, R, Power Query, and Power BI in data analysis.
  • Organize and clean datasets utilizing Python and Power Query.
  • Conduct statistical analysis and forecasting using R.
  • Develop professional dashboards and reports with Power BI.
  • Efficiently integrate and analyze data from various sources.
Read more...

Excel to Power BI

 7 Hours

This live training session in Thailand (delivered online or onsite) is tailored for data analysts aiming to refine their skills in preparing data within Excel and effectively visualizing it using Power BI.

By the conclusion of this program, attendees will have the capability to:

  • Understand the foundational principles, key objectives, and strategic approaches to data analysis.
  • Apply DAX formulas in Power BI to execute complex calculations.
  • Develop and utilize specific visualizations and charts for targeted analysis cases.
  • Employ Power View to transition from Excel-based Power BI workflows to standalone Power BI environments.
Read more...

Power BI Dashboards

 14 Hours
Discover the techniques for building interactive dashboards using Power BI. You will learn to transform data, generate visual reports, and manage distribution within Thailand. The course addresses critical competencies such as data connectors, sophisticated filtering, and best practices for robust business intelligence and enterprise-wide access.
Read more...

Power BI for Financial Analysts: Exam Preparation (PL-300)

 7 Hours
Accelerate your preparation for the Microsoft PL-300 certification through this instructor-led training in Thailand. Tailored for financial analysts, the curriculum covers data preparation, modeling, KPI development, and dashboard visualization within Power BI. Build practical proficiency through hands-on labs and exam-centric exercises.
Read more...

POWER BI (1 day)

7 Hours
Master the art of designing interactive dashboards and reports with this one-day Power BI course in Thailand. The session delves into data modeling, DAX syntax, and visualization best practices, enabling analysts and managers to convert raw data into actionable organizational insights.
Read more...

Power BI

 14 Hours

This live, instructor-led training in Thailand (delivered either online or onsite) targets data professionals and business analysts at beginner to intermediate levels. The program focuses on mastering Power BI for efficient data analysis and visualization.

Upon completion, participants will be equipped to:

  • Grasp the architecture and core components of Power BI.
  • Integrate with diverse data sources and execute data transformations.
  • Develop compelling visualizations and interactive dashboards.
  • Apply row-level security measures and govern data access effectively.
Read more...

Power BI and Power Apps for Data Visualization and Business Process Automation

 21 Hours
This practical course in Thailand provides an introduction to Power BI and Power Apps for data visualization and workflow automation. Participants will learn to integrate data sources, construct interactive dashboards, and design low-code applications that enhance operational efficiency, eliminating the need for extensive coding.
Read more...

Power BI: Basics to Advanced

 35 Hours

This instructor-led, live training in Thailand (online or onsite) is tailored for data professionals at the beginner to intermediate level who are eager to craft compelling data visualizations and dynamic dashboards using Power BI.

Upon successful completion of this course, participants will be equipped to:

  • Ingest and refine data from a wide array of source systems.
  • Construct and fine-tune high-performance data models.
  • Design visually engaging and interactive reports and dashboards.
  • Implement industry best practices in data visualization and dashboard architecture.
  • Leverage advanced Power BI capabilities for deep-dive data analysis.
Read more...

Power BI: Basic, Intermediate, and Advanced

 14 Hours
This instructor-led training in Thailand guides users from novice to advanced levels in creating Power BI dashboards. You will master data transformation, DAX, and visualization techniques through practical exercises with real-world datasets, enabling you to effectively share impactful, interactive business insights.
Read more...

Power BI for Cash Flow and Payroll Analysis

 14 Hours
This live Power BI training in Thailand empowers finance and HR professionals to visualize cash flow and payroll data effectively. Participants will learn to construct interactive dashboards, apply DAX for financial metrics, and automate reporting workflows to enhance decision-making processes.
Read more...

Power BI - Cash Flow and Payroll Analysis

 7 Hours
This instructor-led Power BI training in Thailand empowers financial and HR professionals to construct robust dashboards for cash flow and payroll analysis. Through hands-on exercises and real-world scenarios, you will learn to apply DAX formulas, integrate diverse data sources, and visualize trends to enhance decision-making.
Read more...

Power BI DAX Fundamentals

 21 Hours

This instructor-led, live training session in Thailand (available online or onsite) is designed for beginner to intermediate-level business analysts, data analysts, and developers who aim to grasp the fundamentals of DAX in Power BI.

By the conclusion of this training, participants will be able to:

  • Achieve a comprehensive understanding of Data Analysis Expressions (DAX) in Power BI.
  • Create custom calculations and expressions in Power BI to analyze data and derive meaningful insights.
  • Learn best practices for optimizing DAX performance.
Read more...

Power BI for Data Integration, Analysis, and BIM

 21 Hours
This instructor-led live training in Thailand explores Power BI for data integration, analytics, and BIM. Suited for intermediate professionals, the course empowers real-time data retrieval, AI-driven trend identification, and seamless BIM model integration to deliver actionable insights for both technical and managerial decision-making.
Read more...

Related Categories

Power BI
Power BI