Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

Data Preparation in Power BI

via DataCamp

Overview

In this interactive Power BI course, you’ll learn how to use Power Query Editor to transform and shape your data to be ready for analysis.

In this interactive Power BI course, you’ll learn how to use Power Query Editor to transform and shape your data to be ready for analysis. You’ll also get to grips with various text and numerical transformations, including multiplication, rounding, and split and merge text columns, to help you become even more efficient in data preparation.

Syllabus

  • 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
    • In this chapter, you will learn about the key data preview features available through Power Query and how they can help you summarize the characteristics of your dataset. You’ll also understand how investigating your dataset in Power Query can assist in determining the data transformation steps you need to take.
  • Data Manipulation
    • The preparation and transformation of text data can also be carried out through Power Query. Through interactive exercises, you’ll learn about some of the most common text transformations, such as how to split and merge text columns, trim unwanted characters from any text data, and prefixes to any text data in your dataset.
  • Numerical transformations in Power Query
    • This chapter covers the most common numerical transformations you’ll use in Power Query. You’ll learn how to perform some more advanced Power Query transformations. This includes applying logarithmic and square root transformations on numerical columns, rounding numerical data, and extracting month and week names from date columns.

Taught by

Maarten Van den Broeck and Khaled Choucri

Reviews

4.7 rating at DataCamp based on 76 ratings

Start your review of Data Preparation in Power BI

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.