Exploring Power Query in Excel 2013
In this lab, query and transform web data by using Power Query, and then add the query to an existing Power Pivot data model. Once added, the query result—in the form of data model table—is used to extend the data model with new calculated fields to enable sales per capita analysis. (This is Lab 02 in a series of labs which explore self-service BI with Excel 2013 and Office 365 Power BI. If you plan to complete all of the labs, we recommend that you complete them in the order in which they were designed, although the labs can be completed in any order you choose.)
Click here to run this lab in a Virtual Machine.
Click here to view the lab manual