Chapter 3: Cleaning and Shaping Data - Teach Yourself VISUALLY Power BI [Book]

Skip to main content

Get full access to Teach Yourself VISUALLY Power BI and 60K+ other titles, with a free 10-day trial of O'Reilly.

There are also live events, courses curated by job role, and more.

Start your free trial

CHAPTER 3

Cleaning and Shaping Data

In an ideal world, every dataset would be clean, neatly shaped, and ready for use; but in reality, you will likely need to prepare your data carefully before you analyze it. Power BI Desktop enables you to clean and shape data by using Microsoft’s Power Query tool, which takes a visual approach to data preparation.

A screenshot exposes the custom column dialog box.

Remove Duplicate Values

Replace Values in a Column

Split a Column Using a Delimiter

Add a Calculated Column

Add an Index Column

Remove Duplicate Values

When shaping or transforming a dataset, you may discover duplicate records. You can make your data more accurate for your analysis ...

Get Teach Yourself VISUALLY Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Don’t leave empty-handed

Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.

It’s yours, free.

Get it now

Cover of Software Architecture Patterns

Check it out now on O’Reilly

Dive in for free with a 10-day trial of the O’Reilly learning platform—then explore all the other resources our members count on to build skills and solve problems every day.

Start your free trial Become a member now