Data Preparation in Power BI

Offered byDataCamp

Data Preparation in Power BI
at
DataCamp
Overview

Understand how investigating your dataset in Power Query can assist in determining the data transformation steps you need to take

Duration	3 hours
Total fee	Free
Mode of learning	Online
Schedule type	Self paced
Official Website	Explore Free Course
Credential	Certificate

Data Preparation in Power BI
at
DataCamp
Highlights

Learn from 9 Videos and 26 Exercises

Data Preparation in Power BI
at
DataCamp
Course details

More about this course

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

Data Preparation in Power BI
at
DataCamp
Curriculum

Profiling your Data and Introduction to Power Query

Introduction to Power Query

What is clean data?

Introduction to Power Query demo

Load data and promote headers

Rename and reorder columns

Changing data types

Data Preview features in Power Query

Data preview features in Power Query

Data preview differences

Data preview features

Column distribution and duplicates

Column quality and missing values

Column profile

Profiling to find anomalies

Data Manipulation

Transforming text in Power Query

Universally-applicable transformations

Text transformation

Trim & clean

Merge & extract length

Split & add prefix

Numerical transformations in Power Query

Numerical transformations in Power Query

Numerical vs. Date transformations

Numerical transformations

Absolute value and rounding

Multiplication, addition, and square root

Date transformations

Congratulations!

Data Preparation in Power BI
at
DataCamp
Faculty details

Maarten Van den Broeck

Maarten is an aquatic ecologist and teacher by training and a data scientist by profession. He is also a certified Power BI and Tableau data analyst. After his career as a PhD researcher at KU Leuven, he wished that he had discovered DataCamp sooner.

Khaled Choucri

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.