Udemy - Power Query Essentials - Combining And Restructuring Data

Power Query Essentials: Combining And Restructuring Data

https://WebToolTip.com

MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 530.51 MB | Duration: 0h 48m

Combine and reshape scattered spreadsheets into fast, reliable reports.

What you'll learn
Stack rows from multiple data sources with append.
Consolidate files from a folder into one table.
Join customer details to sales transactions using merge.
Identify matching and unmatched rows with merge joins.
Convert column headers into row values using unpivot.
Transform awkward reporting layouts into clean datasets.
Create new categories based on specific data conditions.
Flag records as 'valid' or 'invalid' with custom rules.
Summarize data by single or multiple grouping fields.
Calculate totals and counts before loading raw data.
Compare two datasets to find missing or changed values.
Design a repeatable workflow for ongoing data updates.

Requirements
Basic knowledge of Microsoft Excel, including working with tables and worksheets.
Microsoft Excel with Power Query (Excel 2016 or later, or Microsoft 365) or Power BI Desktop installed.
Familiarity with basic spreadsheet concepts such as rows, columns, and headers.
No previous Power Query experience is required. This course teaches each feature step by step.