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:20230101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20241015T090000
DTEND;TZID=Asia/Kuala_Lumpur:20241016T170000
DTSTAMP:20260509T005616
CREATED:20240711T025509Z
LAST-MODIFIED:20241008T063145Z
UID:13248-1728982800-1729098000@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Power Query : Data Cleansing and Processing
DESCRIPTION:Download the Course Brochure Link \nThis two-day course provides a deep dive into Microsoft Power Query\, focusing on mastering advanced data transformation techniques. Participants will progress from basics to advanced functionalities\, gaining hands-on experience through practical exercises and real-world case studies. The course ensures a blend of theoretical understanding and practical application\, allowing participants to confidently navigate and utilize Power Query in professional settings. By the end of the course\, attendees will possess a practical toolkit for implementing advanced data transformations\, bolstering their ability to tackle real-world scenarios with confidence and expertise. \nWhat will you learn in this Microsoft Power Query Mastering Data Transformation?\n• Confidently navigate Power Query\, understanding its purpose and efficiently using the Power Query Editor.\n• Master importing data from various sources\, like Excel and databases\, and use parameters for flexible connections.\n• Gain skills in basic data transformations—filtering\, sorting\, handling duplicates\, and managing data types and conversions.\n• Proficient in advanced transformations\, including working with dates\, text\, and functions in Power Query.\n• Master advanced transformations\, like aggregating data and merging queries\, while smoothly managing relationships between them.\n• Learn to manage errors\, optimize queries for better performance\, and follow best practices for trustworthy data transformations.\n• Get introduced to Power Query M language\, enabling the creation of custom functions\, integrating with Power BI and Excel\, and automating data tasks \nCourse Outline\nModule 1: Introduction To Power Query\n• Overview of Power Query and its role in data transformation\n• Installing and configuring Power Query\n• Exploring the Power Query Editor interface \nModule 2: Connecting To Data Sources\n• Importing data from various sources (Excel\, CSV\, databases\, web\, etc.)\n• Understanding query folding and its implicationsPower PoQuer\n• Parameters and dynamic data source connections \nModule 3: Basic Data Transformations\n• Filtering and sorting data\n• Removing duplicates\n• Handling null values and errors\n• Introduction to data types and type conversion \nModule 4: Advanced Data Transformations\n• Working with date and time functions\n• Text transformations and manipulation\n• Conditional columns and custom columns\n• Using functions and expressions in Power Query \nModule 5: Advanced Transformations And Integration\n• Aggregating data with Group By\n• Merging and appending queries\n• Pivot and unpivot transformations \nModule 6: Combining Queries And Managing Relationships\n• Understanding query dependencies\n• Join types and merging queries\n• Managing relationships between queries \nModule 7: Error Handling And Query Optimization\n• Handling errors and exceptions in Power Query\n• Optimizing query performance\n• Best practices for efficient data transformation \nModule 8: Automation And Integration\n• Introduction to Power Query M language\n• Creating custom functions\n• Incorporating Power Query into Power BI and Excel workflows\n• Automating data refresh and transformations
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-power-query-mastering-data-transformation-5/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Power Query
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2024/07/HRDCorpClaimableCourse_Microsoft_Power_Query_Data_Cleansing_and_Processing_Oct2024.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR