Chapter 5: Transforming Power Query Data

In this part of this book, you will learn how to transform data using Power Query in a multitude of ways and understand why it is important to prepare your dataset prior to analysis. You will apply Unpivot and Pivot to a dataset to structure data in the correct tabular format; work with row and column tools such as split, merge, duplicate, and extract; and use conditional columns to display the output you desire from if…then…else conditions. The automatic background refresh setting will also be discussed in this chapter. We will learn how to extract ages from a date column, which saves a huge amount of time as you would normally have to work this out for each individual column from a date column entry. ...

Get Learn Power Query now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.