O'Reilly logo

Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide by Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required