In This Chapter
In information management, ETL refers to three separate functions:
You've probably been manually performing ETL processes for years — although you might not think of it that way. Whenever you pull data from a source location, manipulate that data, and integrate it into your reporting, you're performing ETL.
In an attempt to develop robust and reusable ETL processes, Microsoft released the Power Query Add-In. Power Query enhances the ETL experience by offering a mechanism to extract data from a wide variety of sources, perform complex transformations on that data, and then load the data into a workbook or the internal Data Model.
In this chapter, you see how the Power Query Add-In works and discover some of the innovative ways you can use it to help save time and automate the steps needed to ensure that clean data is imported into your reporting models.
The Power Query Add-In does not come with Excel out of the box. Your administrator might ...