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-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:20220101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231018T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231019T170000
DTSTAMP:20260514T023450
CREATED:20230830T074501Z
LAST-MODIFIED:20230927T061525Z
UID:9557-1697619600-1697734800@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Data\, Import\, Cleanse & Automation with Power Query
DESCRIPTION:Power Query can connect to a wide range of data sources. Databases such as SQL Server\, Oracle\, Text files\, Big data and Hardtop data sources\, online searches and Data feeds\, Cloud storage\, Facebook\, SharePoint and many other types of data storage. Power Query extracts the data from sources\, and does transformations such as splitting columns\, data conversions\, lookups\, merge\, append\, data cleansing and many other data transformations AUTOMATICALLY without the use of VBA. Power Query introduced a new expression language called “M” for data transformations. Power Query is simply the best transformation and data manipulation tool for Excel and easier to use\, understand and master than other tools. Upon successful completion of this course\, the delegate should be proficient with Power Query and have the necessary skills to implement and automate the process of pulling in data\, perform data transformation and data cleansing. \nWhat will you learn in this Data\, Import\, Cleanse & Automation with Power Query Training?\n• Import / connect to external data from multiple sources\n• Automate the data transformation & data cleansing processes\n• Combine data from multiple sources into a single source\n• Merging data without the need of formulas such as VLOOKUP\, INDEX & MATCH\n• Perform calculation to aggregate data \nCourse Outline\nINTRODUCTION TO POWER QUERY\nThis module explains what a power query is and how you can download and\ninstall the power query on your computer. Learn how data files are imported\n/ connected whether it’s a text files\, CSV file\, database\, or any other source. Once the connection\nis built\, refreshing the connection will automatically load the latest changes. \nAPPENDING DATA FROM MULTIPLE SOURCES / FORMATS\nIn this module\, you will append data together into one source from multiple file formats\, multiple\nsources and even an entire folder for the purpose of analysis. If the source is an Excel file\,\nlearn to pull data from multiple workbooks\, multiple sheets\, and multiple tables. \nMERGING TABLES\nThis module shows how easy to merge data without using formulas such as VLOOKUP\, INDEX & MATCH.\nPerform more advanced merges using Inner\, Outer\, Full\, and Anti Joins. Learn to automate\nreconciliations and throw out exceptional items. \nPOWER QUERY FORMULAS\nThis module shows how to perform calculations such as SUM\, AVERAGE & COUNT just like a pivot table.\nMore complicated data transformation can be done using “M” language for Power Query. \nTRANSFORMING DATA\nIn Power Query\, you will be able to transform selected columns into attribute value pairs where\ncolumns become rows for data analysis which is required for Pivot Tables. Data that is structured\nincorrectly can be transformed easily. \nCLEANING DIRTY DATA\nThe complete removal of dirty data from a source is virtually impossible. Power Query has some\ntools which can be used to clean some common\nproblems such as missing data\, data formatted incorrectly or date problems.
URL:https://www.excelacademy.my/event/hrd-corp-claimable-data-import-cleanse-automation-with-power-query-2/
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/2023/08/53.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR