BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Computer Training Source - ECPv6.15.18//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://computertrainingsource.com
X-WR-CALDESC:Events for Computer Training Source
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20260122T090000
DTEND;TZID=UTC:20260122T160000
DTSTAMP:20260405T021108
CREATED:20250530T225346Z
LAST-MODIFIED:20251125T211110Z
UID:8671-1769072400-1769097600@computertrainingsource.com
SUMMARY:Power Query: Data Transformation Mastery
DESCRIPTION:Power Query: Data Transformation Mastery\nCourse Length: 1 Day  \nAudience: Business analysts\, Excel users\, Power BI beginners \nPrerequisites: Basic knowledge of Excel or Power BI \n  \nModule 1: Introduction to Power Query  \n\nWhat is Power Query?\nPower Query vs. Excel formulas vs. VBA\nWhere Power Query lives (Excel vs. Power BI)\nThe Power Query interface (Navigator\, Formula Bar\, Query Settings)\n\nActivity: Load a simple CSV file into Power Query and explore the interface. \nModule 2: Connecting to Data Sources  \n\nImporting from Excel\, CSV\, Web\, and databases\nCombine multiple files from a folder\nRefreshing and managing connections\n\nActivity: Connect to multiple CSVs in a folder and append them. \nModule 3: Transforming Data  \n\nRemoving rows/columns\nFiltering and sorting\nSplitting and merging columns\nChanging data types\nFill down/up and transpose\n\nActivity: Clean up a messy sales report using these tools. \nModule 4: Shaping Data for Analysis  \n\nUnpivot and pivot columns\nGrouping and summarizing\nCreating calculated columns\nUsing the “Applied Steps” panel efficiently\n\nActivity: Reshape survey data from wide to long format and summarize responses. \nModule 5: Combining Queries  \n\nAppend vs. Merge explained\nMerge join types (Inner\, Left Outer\, etc.)\nCreating relationships for modeling\n\nActivity: Merge customer and order tables to build a single clean dataset. \nModule 6: Intro to the M Language  \n\nViewing and modifying the formula bar\nCommon M functions: Text\, Table\, List\, Record\nCustom columns and basic logic\n\nActivity: Write a custom column using M to classify sales as “High\,” “Medium\,” or “Low”. \nModule 7: Loading and Using Queries (30 mins) \n\nLoad to Excel sheet vs. Power Pivot\nLoad to Power BI Model\nRefresh strategies and query dependencies\n\nActivity: Load cleaned data into Excel pivot table or Power BI table visual. \nWrap-Up & Q&A (30 mins) \n\nBest practices for Power Query projects\nWhere to go next: M Language deep dive\, performance optimization\, Power BI integration\n\n\n\n\n  \nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/power-query-data-transformation-mastery/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR