Data Preparation in Power BI

Profiling your Data and Introduction to Power Query
-Data preparation is key to becoming a successful data analyst. You’ll learn how to do essential data preparation steps such as filtering and renaming columns and how to use data preview in Power BI to identify common errors that appear in datasets.

Data Preview features in Power Query
-Data preparation is key to becoming a successful data analyst. You’ll learn how to do essential data preparation steps such as filtering and renaming columns and how to use data preview in Power BI to identify common errors that appear in datasets.

Data Manipulation
-This chapter covers the most common numerical and text transformations you’ll use in Power Query. Through interactive exercises, you’ll learn how to split and merge text columns, apply logarithmic and square root transformations on numerical columns, and extract month and week names from date columns.

Numerical transformations in Power Query
-This chapter covers the most common numerical and text transformations you’ll use in Power Query. Through interactive exercises, you’ll learn how to split and merge text columns, apply logarithmic and square root transformations on numerical columns, and extract month and week names from date columns.