Skip to main content
HomePower BI

course

Data Preparation in Power BI

Beginner
4.6+
79 reviews
Updated 12/2024
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

Included for FreePremium or Teams

Power BIData Preparation3 hours9 videos26 exercises2,050 XP42,840Statement of Accomplishment

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.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course Description

Learn How to Use Power Query Editor

Transform and shape your data in Power BI. In just 3 hours, you’ll cover essential data preparation steps, previewing data in power query, and transformations.

By the end of this course, you’ll feel confident using a range of Power Query Editor tools and techniques and know how to clean and prepare your data for the next stage in the data analysis workflow.

Manipulate Data in Power BI

Power Query is a powerful data manipulation framework available throughout a number of Microsoft tools, which allows you to clean different data types ready for analysis. You’ll learn how to deal with duplicates, missing values, and profiling to find anomalies. After each new topic is introduced, you'll have the opportunity to put your new knowledge into practice with hands-on exercises, such as splitting and merging text columns.

Master Data Transformation in Power Query

The last two chapters of this course are focused on helping you with transformations in Power BI, allowing you to transform text, apply logarithmic and square root transformations, and date transformations.

This course is part of the Data Analyst and Power BI tracks, offering you plenty of ways to improve your Power BI skills or even build towards a career in data analysis.

Prerequisites

Introduction to Power BI
1

Profiling your Data and Introduction to Power Query

Start Chapter
2

Data Preview features in Power Query

Start Chapter
3

Data Manipulation

Start Chapter
4

Numerical transformations in Power Query

Start Chapter
Data Preparation in Power BI
Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Enroll now

Don’t just take our word for it

*4.6
from 79 reviews
75%
19%
5%
1%
0%
  • Meng L.
    10 days

    Excellent learning!

  • Karla V.
    17 days

    It was great, easy to follow along and the terms were well explained.

  • Cetin E.
    about 1 month

    Very good content

  • Michael M.
    about 2 months

    Power BI is a great tool to learn and I love the Data Camp model to bring me up to speed on a tool I can definitely use in my capacity as a senior manager overseeing a large team (dashboarding, analysis, etc.)

  • Alejandro C.
    3 months

    Excelent

"Excellent learning!"

Meng L.

"It was great, easy to follow along and the terms were well explained."

Karla V.

"Very good content"

Cetin E.

FAQs

Join over 15 million learners and start Data Preparation in Power BI today!

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.