Home > Uncategorized > daily 07/01/2015

daily 07/01/2015

    • At the moment, there is a lot of overlap between what you can achieve on the Data tab in Excel and with Power Query; in the future, Power Query might be the replacement for the Data tab.
    • Where Power Query supports a data source that is already supported natively by the Excel Data tab, it is often the case that it improves on the native functionality. One example is the ability to scrape data from a web page; Power Query is able to extract data from far more web pages than the native functionality is able to. Another example is the way that Power Query can merge data from a folder containing multiple csv files into a single result set with minimal effort.
    • Building on from the previous point, as you saw in the walkthrough, Power Query makes it very easy to filter, aggregate, sort, pivot and unpivot, as well as to add calculations, just by clicking a button.
    • A full discussion of this behavior, called “query folding,” is given in Chapter 3.
    • Although Power Query steps may connect to external data sources, there is no concept of a connection to a data source as a separate object, and Power Query cannot use connections defined elsewhere in Excel (that’s to say, the connections that can be found on the Data tab in the ribbon). However, the output of a Power Query query does become a traditional Excel connection and can be used just like any other connection. This allows Power Query to be able to output results to a table in a worksheet, for example.
    • If you load your data into the Excel Data Model, you no longer have to use a hidden worksheet to store your data; once the data is in the Excel Data Model, you can create PivotTables directly from it and you can use Excel‘s Cube Formulas to import individual values into cells in the worksheet.

Posted from Diigo. The rest of my favorite links are here.

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: