O'Reilly logo

High Impact Data Visualization with Power View, Power Map, and Power BI by Adam Aspin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 13

image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required