Skip to main content

Data Preparation in Power BI

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.

Start Course for Free
3 Hours9 Videos26 Exercises2050 XPData Analyst TrackPower BI Fundamentals Track

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA. You confirm you are at least 16 years old (13 if you are an authorized Classrooms user).

Loved by learners at thousands of companies


Course Description

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 advanced Power BI topics, including how to use M language and the Advanced Editor, to help you be even more efficient in data preparation.

  1. 1

    Profiling your Data and Introduction to Power Query

    Free

    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.

    Play Chapter Now
    Introduction to Power Query
    50 xp
    What is clean data?
    50 xp
    Introduction to Power Query demo
    50 xp
    Load data and promote headers
    100 xp
    Rename and reorder columns
    100 xp
    Changing data types
    100 xp
  2. 2

    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.

    Play Chapter Now
  3. 3

    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.

    Play Chapter Now
  4. 4

    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.

    Play Chapter Now

In the following tracks

Data AnalystPower BI Fundamentals

Collaborators

carlrosseel-73112126-9ed2-4866-942a-96fbf265b088Carl Rosseel
Maarten Van den Broeck Headshot

Maarten Van den Broeck

Content Developer at DataCamp

Maarten is an aquatic ecologist and teacher by training and a data scientist by profession. After his career as a Ph.D. researcher at KU Leuven, he wished that he had discovered DataCamp sooner. He loves to combine education and data science to develop DataCamp courses. In his spare time, he runs a symphonic orchestra.
See More
Khaled Choucri Headshot

Khaled Choucri

Strategic Analyst

Khaled is a Power BI certified Strategic Analyst at Trilogy. He has a strong focus on data engineering and financial analytics. Khaled is passionate about studying human behavior and financial decision-making, particularly using machine learning and AI. He has a great desire to develop solutions for the technology-enabled future.
See More

What do other learners have to say?

I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.

Devon Edwards Joseph
Lloyds Banking Group

DataCamp is the top resource I recommend for learning data science.

Louis Maiden
Harvard Business School

DataCamp is by far my favorite website to learn from.

Ronald Bowers
Decision Science Analytics, USAA