Data Preparation in Power BI Data Camp

Overview

Context

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

By the end of this Data Preparation in Power BI course offered by Data Camp, 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.

What you'll learn

• Identify how to load, transform, structure, and prepare data, including using conditional/custom logic and the Advanced Editor
• Recognize how to perform simple & advanced text/string, numerical, and date manipulations on your data
• Recognize how to use the features in Power Query to diagnose and fix common errors (data entry/missing values/etc.) in the data