Data Transformation with Power Query

Topics Covered

• Removing duplicates
• Filtering data
• Sorting records
• Splitting columns
• Merging columns
• Pivoting and unpivoting
• Replacing values
• Data type management
• Appending queries
• Merging queries

Module Description

• This module demonstrates how Power Query simplifies complex data preparation tasks. Participants learn to clean, standardize, and reshape datasets to ensure consistency and accuracy before analysis.

Hands-on Lab

• Clean and transform sales and customer data
• Merge multiple datasets into a single reporting table