Time for action – self-service ETL with Power Query

In this example, we will retrieve smartphone data from the Web and perform some transformations on it, such as combining, unpivoting, splitting, and adding extra columns by performing the following steps. We will also append data from two different sources:

  1. Open a new blank Excel spreadsheet and go to the POWER QUERY tab.

    Tip

    If you cannot find the POWER QUERY tab, download and install the Power Query add-in for Excel 2013 from http://www.microsoft.com/en-nz/download/details.aspx?id=39379.

  2. In the POWER QUERY tab, click on the first icon from the left, named Online Search, as shown in the following screenshot. This option is a part of getting data from external sources. Also, with Online Search, you ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial