Transforming Data Sets Using Get & Transform

  • Adam Aspin


In the previous chapter, you saw some of the ways in which you can find and load data into either Excel worksheets or the Excel in-memory data model using Get & Transform. Inevitably, this is the first part of any process that you create to extract, transform, and load data. Yet it is only a first step. Once the data is accessible using Get & Transform, you need to know how to adapt it to suit your requirements in a multitude of ways. This is because not all data is ready to be used immediately. Quite often, you have to do some initial work on the data to make it more easily usable in Get & Transform. Tweaking source data is generally referred to as data transformation, which is the subject of this chapter.


Data Transformation Query Window Excel Worksheet Original Column Enterprise Data Warehouse 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

©  Adam Aspin 2016

Authors and Affiliations

  • Adam Aspin
    • 1
  1. 1.StaffordUK

Personalised recommendations