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. In addition, we will look at using various delimiter constraints, as well as grouping data from various rows into a single value.
In this chapter, we're going to cover the following main topics:
- Turning data with...