CHAPTER 13
Transforming Data with Power Query
In the previous chapter we saw some of the ways in which you can find and load data into Power Query. Inevitably this will be the first part of any process that you create to extract, transform, and load data. Yet it is quite definitely only a first step. Once the data is in Power Query, you will need to know how to adapt it to suit your requirements in a multitude of ways.
The transformations that you can apply to the raw data are many and varied. They can include the following:
- Renaming, removing, and reordering columns
- Subsetting columns to extract part of the available data in a column
- Excluding ...
Get High Impact Data Visualization with Power View, Power Map, and 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.
