Data Manipulation using Power Query and Power Pivot

added by kalyanms1
11/19/2013 6:16:02 PM


Power Query is an excel Add-in which allows you to connect wide variety of data sources. Power Query has an intelligence to find a data set on a webpage. Once you have the data set you may notice that is not in right shape. Using Power Query you can combine data sets using join, merge operations. Power Query generates the script when you are performing the steps in loading and cleansing the data and later that script can refreshed with a button click. The Power Query can be downloaded from here.