Get in Touch
 Duration 14 hours

Course Outline

Overview of Power Query

  • Exploration of the Power Query user interface
  • Grasping the concepts of queries and applied steps
  • Navigating the integration features with Power BI and Excel

Establishing Data Source Connections

  • Importing data from Excel, CSV, and text files
  • Handling folder-based and structured data collections
  • Linking to online resources and database systems

Essentials of Data Cleaning

  • Eliminating errors and redundant entries
  • Filtering, sorting, and restructuring data formats
  • Addressing missing values effectively

Data Transformation and Reshaping

  • Techniques for splitting and consolidating columns
  • Performing pivot and unpivot operations
  • Applying grouping and aggregation methods

Integrating Multiple Queries

  • Distinguishing between appending and merging queries
  • Considering join types and underlying data structures
  • Constructing models from multiple data sources

Fundamentals of M Language

  • Comprehending M language formulas
  • Modifying queries via the Advanced Editor
  • Developing custom transformation scripts

Automation and Data Refresh

  • Building reusable transformation pipelines
  • Setting up automated refresh schedules
  • Optimizing query dependencies and performance

Advanced Methodologies

  • Implementing parameters within queries
  • Leveraging functions within M language
  • Applying best practices for scalable transformation architectures

Conclusion and Future Directions

Requirements

  • Proficiency in spreadsheet-based data operations
  • Hands-on experience with fundamental data analysis procedures
  • Knowledge of standard file formats, including CSV and Excel

Target Audience

  • Data professionals tasked with cleansing and preparing datasets
  • Business analysts managing regular data processing workflows
  • Individuals involved in data reporting and operational automation

Number of participants


Price per participant

Open Training Courses require 5+ participants.

Testimonials (2)

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

Method of training.

Ineshia Bilankulu - National Transmission Company South Africa
Course - Power BI: Basics to Advanced

Upcoming Courses

Power Query for Data Transformation and Automation

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

Power Query for Data Transformation and Automation

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

Power Query for Data Transformation and Automation

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

Power Query for Data Transformation and Automation

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

Power Query for Data Transformation and Automation

2027-01-06 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...

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

 14 Hours
This live, instructor-led training in Thailand empowers intermediate professionals with advanced Power BI capabilities, including complex data modeling, DAX calculations, and interactive visualization techniques to construct effective business intelligence solutions.
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...

Related Categories

Power BI
Power BI