Discovering and Loading Data with Get & Transform in Excel 2016

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.