BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Academy Malaysia - HRD Corp Approved Training Provider - ECPv6.18.2//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Excel Academy Malaysia - HRD Corp Approved Training Provider
X-ORIGINAL-URL:https://www.excelacademy.my
X-WR-CALDESC:Events for Excel Academy Malaysia - HRD Corp Approved Training Provider
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Asia/Kuala_Lumpur
BEGIN:STANDARD
TZOFFSETFROM:+0800
TZOFFSETTO:+0800
TZNAME:+08
DTSTART:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20261118T090000
DTEND;TZID=Asia/Kuala_Lumpur:20261119T170000
DTSTAMP:20260928T091851Z
CREATED:20260709T063339Z
LAST-MODIFIED:20260928T091851Z
UID:14788-1794992400-1795107600@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Power Query with AI Tools: Data Cleansing and Processing
DESCRIPTION:Download The Course Brochure Link \nMicrosoft Power Query with AI Tools is a two-day intensive programme designed to help professionals transform messy\, inconsistent and multi-source data into clean\, structured and analysis-ready datasets. The programme focuses on building practical and repeatable data-preparation workflows that reduce manual effort\, improve accuracy and support more efficient reporting and analysis. \nParticipants will learn how to connect Power Query to multiple data sources\, clean and standardise information\, combine datasets from different files and systems\, and perform advanced transformations such as pivoting\, unpivoting\, aggregation and custom-column creation. The Microsoft Power Query with AI Tools programme also introduces AI-assisted techniques that can support error detection\, pattern identification\, data cleansing and repetitive data-processing activities. \nThrough hands-on exercises\, this Microsoft Power Query with AI Tools programme helps participants develop more efficient approaches to preparing and transforming business data. Participants will also explore query dependencies\, error handling\, query optimisation and the Power Query M language for creating more flexible and automated workflows. \nBy the end of the Microsoft Power Query with AI Tools training\, participants will be able to create reliable\, refreshable data-processing solutions that transform raw information into structured datasets ready for reporting\, analysis and business decision-making. \nWhat will you learn in Microsoft Power Query with AI Tools: Data Cleansing and Processing?\nThis Microsoft Power Query with AI Tools training will help participants develop practical skills in: \n\nNavigate Microsoft Power Query confidently\, understanding its interface\, workflow\, and role in modern data preparation and processing.\nConnect and import data from multiple sources including Excel files\, CSV files\, databases\, web sources\, and other business systems\, while using parameters to create more dynamic and flexible connections.\nClean and standardise raw data efficiently by filtering and sorting records\, removing duplicates\, managing null values\, correcting data types\, and performing text and date transformations.\nApply advanced Power Query transformations including custom and conditional columns\, pivoting\, unpivoting\, aggregation\, merging\, and appending to prepare complex datasets for analysis.\nLeverage AI tools for data cleansing and processing\, including intelligent error detection\, pattern identification\, data insights\, and automation of repetitive tasks.\nCombine multiple datasets and manage query relationships by understanding join types\, query dependencies\, merging techniques\, and integrated data workflows.\nImprove the reliability and performance of Power Query solutions through effective error handling\, query optimisation\, and best practices for working with larger datasets.\nUse Power Query M language for greater automation\, including creating custom functions and extending Power Query beyond standard interface-based transformations.\nBuild reusable and refreshable data workflows that integrate smoothly with Excel and reduce the time spent repeatedly preparing data for reporting and analysis.\n\nCourse Outline\nThe Microsoft Power Query with AI Tools course outline progresses from connecting and cleaning data to advanced transformations\, query optimisation and automated data-processing workflows. \nModule 1: Connecting to Data Sources \n– Importing data from various platforms including Excel\, CSV\, databases\, web sources\, and other business data sources– Using parameters to create dynamic and flexible data connections– Understanding query folding and its role in efficient data processing– Establishing a strong foundation for repeatable and refreshable data workflows \nModule 2: Basic Data Transformations \n– Filtering and sorting data for better organisation and analysis– Identifying and removing duplicate records– Handling null and missing values effectively– Managing and converting data types for greater consistency– Introducing AI-powered approaches to error detection and correction \nModule 3: Advanced Data Transformations \n– Applying text transformations to clean and standardise inconsistent data– Performing date transformations for accurate time-based analysis– Creating custom columns using Power Query expressions– Building conditional columns to apply business rules to datasets– Using AI tools to identify data patterns and generate useful insights \nModule 4: Combining Queries and Managing Relationships \n– Understanding query dependencies and how different queries interact– Understanding different join types and selecting the appropriate approach– Merging queries to combine related datasets– Appending queries to consolidate multiple datasets with similar structures– Managing relationships between queries for more integrated data-processing workflows \nModule 5: Error Handling and Query Optimisation \n– Identifying common Power Query errors and understanding their causes– Applying appropriate techniques to resolve data and transformation errors– Optimising query performance when working with large datasets– Applying best practices for building reliable\, maintainable\, and efficient data workflows \nModule 6: Automating Processes with Power Query and AI Tools \n– Introduction to the Power Query M language for more advanced customisation– Creating custom functions to support reusable data-processing logic– Automating repetitive data preparation tasks using AI-enhanced tools– Integrating Power Query processes seamlessly into existing Excel workflows– Developing more efficient\, repeatable\, and scalable approaches to data cleansing and processing \nBy completing this Microsoft Power Query with AI Tools programme\, participants will be better prepared to build reusable data-preparation workflows\, improve data quality and reduce repetitive manual processing in everyday reporting and analysis. \nFor more information about our training programmes\, visit Excel Academy Malaysia.  
URL:https://www.excelacademy.my/event/microsoft-power-query-with-ai-tools/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Power Query
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2026/07/NOV26_MicrosoftExcelIntermediateAdvanced-2.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR