Clean, transform, and load data in Power BI

  • Module
  • 10 Units
Intermediate
Data Analyst
Power BI
Microsoft Power Platform

Use Power Query to clean and prepare data for analysis. Learn to simplify models, change data types, rename objects, pivot data, and profile columns to identify valuable data for deeper analytics.

Learning objectives

By the end of this module, you’ll be able to:

  • Resolve inconsistencies, unexpected or null values, and data quality issues.
  • Apply user-friendly value replacements.
  • Profile data so you can learn more about a specific column before using it.
  • Evaluate and transform column data types.
  • Apply data shape transformations to table structures.
  • Combine queries.
  • Apply user-friendly naming conventions to columns and queries.
  • Edit M code in the Advanced Editor.

Prerequisites

None

Mula