BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Academy Malaysia - HRD Corp Approved Training Provider - ECPv6.15.20//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:20240101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20250514T090000
DTEND;TZID=Asia/Kuala_Lumpur:20250515T170000
DTSTAMP:20260514T042255
CREATED:20250206T021731Z
LAST-MODIFIED:20250325T034400Z
UID:13632-1747213200-1747328400@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Power Query with AI Tools: Data Cleansing and Processing
DESCRIPTION:Download the Course Brochure Link \nThis two-day course combines the robust data processing capabilities of Microsoft Power Query with the efficiency of AI tools to empower participants in performing advanced data cleansing and transformation tasks. Through practical exercises and real-world applications\, participants will learn how to automate data workflows\, handle complex transformations\, and use AI-enhanced features to streamline data management. By the end of the course\, attendees will be well-equipped to handle diverse data scenarios with confidence and efficiency. \nWhat will you learn in this Microsoft Power Query with AI Tools: Data Cleansing and Processing\n– Confidently navigate Microsoft Power Query\, understanding its interface and purpose in data processing.\n– Import and manage data from various sources\, leveraging parameters for dynamic connections.\n– Perform basic and advanced data cleansing techniques\, including filtering\, sorting\, and heandling duplicates.\n– Apply AI tools for intelligent data insights\, error detection\, and automation of repetitive tasks.\n– Execute complex transformations\, such as pivoting\, unpivoting\, and aggregating data.\n– Optimize data workflows with error handling\, query optimization\, and best practices.\n– Utilize Power Query M language for creating custom functions and automating processes. \nCourse Outline\n\nModule 1: Introduction to Microsoft Power Query and AI Tools \n– Overview of Microsoft Power Query and its role in data transformation.\n– Introduction to AI tools for data automation and intelligent insights.\n– Exploring the Power Query Editor interface. \nModule 2: Connecting to Data Sources \n– Importing data from various platforms (Excel\, CSV\, databases\, web\, etc.).\n– Using parameters for dynamic and flexible connections.\n– Understanding query folding for efficient data processing. \nModule 3: Basic Data Transformations \n– Filtering and sorting data for better organization.\n– Handling duplicates\, null values\, and data type conversions.\n– Introduction to AI-powered error detection and correction. \nModule 4: Advanced Data Transformations \n– Text and date transformations for precise data adjustments.\n– Creating custom and conditional columns using Power Query expressions.\n– Utilizing AI tools to predict data patterns and generate insights. \nModule 5: Combining Queries and Managing Relationships \n– Understanding query dependencies and join types.\n– Merging and appending queries effectively.\n– Managing relationships between queries for integrated workflows. \nModule 6: Error Handling and Query Optimization \n– Identifying and resolving errors in Power Query.\n– Optimizing query performance for large datasets.\n– Best practices for building reliable and efficient data workflows. \nModule 7: Automating Progresses with Power Query and AI Tools \n– Introduction to Power Query M language for custom functions.\n– Automating repetitive tasks using AI-enhanced tools.\n– Integrating Power Query processes seamlessly into Excel workflows.
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-power-query-with-ai-tools-data-cleansing-and-processing-2/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Power Query
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2025/02/May2025_MicrosoftPowerQuery-1.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR