Advertisement

Discovering and Loading Data with Get & Transform in Excel 2016

  • Adam Aspin
Chapter

Abstract

Before you can present any analysis or insight, you need data. Your sources could be in many places and in many formats. Nonetheless, you need to access them, look at them, select them, and quite possibly clean them up to some extent. You may also need to join many separate data sources before you shape the data into a coherent model that you can use as the foundation for your dashboards and reports. The amazing thing is that you can do all of this using Excel 2016 without needing any other tools or utilities thanks to the Get & Transform function. What is more, you can feed the output from Get & Transform either into a spreadsheet (if the data is not too voluminous) or into the in-memory data model for larger—and even extremely large—data sets.

Keywords

Relational Database Text File Data Warehouse Small Triangle Recent Source 
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